Division of Information Technology Services

Advanced Non-Credit Course Listings

PDF icon Complete Course Brochure (PDF)

Access 2010: Level II Apr 21, 22, 23, 24
9:00am-12:00n 280.00 ACCII10 Register 

This 4 half-day course is designed for users who can create simple applications with Access and now want to explore some of the intermediate to advanced skill sets. Participants will start by designing a database with a more complex relational model, then set table properties and relationships to further improve data quality, create forms with subforms and create grouped reports. Users will learn to create advanced queries such as those based on other queries, queries to manipulate data, and queries to summarize data. Finally, participants will learn to use macros to create event-driven programming to automate routine processes and incorporate these into the application.
Who Should Attend: People who are familiar with Windows and have taken the Access 2010 - Level I course, or have equivalent experience.

Acrobat LiveCycle Designer Mar 18 & 19
1:00pm-4:00pm 150.00 LCD Register 

In this two half-day course, users learn how to design a fillable form using the LiveCycle Designer included in Adobe Acrobat Professional to create interactive PDF forms to distribute, fill out, and then submit electronically. Participants will also learn how to organize the collected data in a spreadsheet.
Who Should Attend: People who are familiar with Windows, Adobe Acrobat Pro and Microsoft Office applications, such as Word and Excel.

Excel 2010 - Level II:
Data Analysis and Presentation
Mar 10, 11, 12
9:00am-12:00n 220.00 EXII10-D Register 

This three half-day Excel Level II course introduces participants to tools for analyzing data using features such as sorting, filtering, importing and sharing data. Users will be introduced to various methods for presenting data in report format using Pivot Tables and Charts. Additional topics include conditional and customized formatting.
Who Should Attend: People who are familiar with Windows and have taken the Excel 2010 - Level I course, or have equivalent experience.

Excel 2010 - Level II:
Formulas and Functions
May 12, 13, 14
1:00pm-4:00pm 220.00 EXII10-F2 Register 
Excel 2010 - Level II:
Formulas and Functions - FULL
Apr 28, 29, 30
1:00pm-4:00pm 220.00 EXII10-F FULL

This three half-day Excel Level II course introduces advanced Excel formulas using functions for conditional, logical, financial and date calculations. Participants will learn how to create formulas to look up and manipulate data when working with lists of data. Techniques for auditing and troubleshooting formulas will also be discussed.
Who Should Attend: People who are familiar with Windows and have taken the Excel 2010 - Level I course, or have equivalent experience.

Excel 2010 - Level III:
Advanced Formulas**
May 20 & 21
1:00pm-4:00pm 150.00 EXIIIAF2 Register 
Excel 2010 - Level III:
Advanced Formulas - FULL
May 27 & 28
1:00pm-4:00pm 150.00 EXIIIAF FULL

This two half-day Excel Level III course uses a combination of many functions to create formulas for summarizing, extracting and formatting data.  Conditional, logical, duplicate and date types of calculations will be analyzed.
**Who Should Attend: For this advanced formulas course, users must have completed the Level II: Functions & Formulas course or have equivalent experience.

Excel 2010 - Level III: Macros NOTE: This course will not be offered this term.

This is a four half-day Level III course that provides techniques to automate common repetitive tasks that are used in the Excel workbook development. Please send an email to its-courses@uwo.ca if you want to be added to next term's contact list.


Last updated on and Powered by Cascade Server