Division of Information Technology Services

Advanced Non-Credit Course Listings

Level II Prerequisites:
  • completion of Level I introductory course (or equivalent education) 

Level III Prerequisites:
  • completion of Level II course; check course description for more details 

PDF icon Course Brochure (PDF) to print

Access 2013: Level II 4 half-days
Registration Form 

This Level II 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 2013 - Level I course, or have equivalent experience.

Acrobat LiveCycle Designer    

This course will not be offered this term; email its-courses@uwo.ca if you would like to be put on next term's contact list.

Excel 2013 - Level II:
Data Analysis and Presentation
3 half-days
Registration Form

This 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 2013 - Level I course, or have equivalent experience.

Excel 2013 - Level II:
Functions and Formulas
3 half-days
Registration Form 

This 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 2013 - Level I course, or have equivalent experience.

Excel 2013 - Level III: 
Advanced Formulas
2 half-days
Registration Form

This Advanced 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 2013 - Level III:
Macros
4 half-days (2+2)
Registration Form 

This Level III course introduces techniques to automate common repetitive tasks that are used in the Excel workbook development. Participants will learn how to use the Excel built in macro recorder to create basic macros and the Visual Basic for Applications (VBA) Editor to enhance, customize and create methods of deployment. This course is run over two weeks so participants can review and practice more between sessions.
Who Should Attend: People who have taken any previous Excel 2013 Level II course, or have equivalent experience.


Powered by Cascade ServerPublished on