Advanced Non-Credit Course Listings

  • sessions can be up to four half-days in length
  • exact dates and times are listed on the registration form
  • a course manual is included in the cost and will be supplied on the first day
  • Office 2010 and 2016 users can also attend any of the course offerings listed below

Are you considering a Level II course?
All courses require the completion of the Level I introductory course (or its equivalent); check the course listing below for more details.

Are you considering a Level III advanced course?
The concepts are definitely more difficult in these courses and build upon a majority of material that was covered in Level II; refer to each course listing below for more information. 

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 LI course, or have equivalent experience.Send an email its-courses@uwo.ca if you need to check your eligibility for this course.

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. These courses would be more advantageous to those users who have had time to put into practice what they learned in Level I. If you have not had time to work with the Level I material, you may want to consider waiting until another term before registering for this Level II course.

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 LI course, or have equivalent experience. These courses would be more advantageous to those users who have had time to put into practice what they learned in Level I. If you have not had time to work with the Level I material, you may want to consider waiting until another term before registering for this Level II course.

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

This two half-day Level III course covers 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 Excel Level II: Functions & Formulas non-credit course or have equivalent experience.

Excel 2013 - Level III: Macros

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

Photoshop-Advanced 3 half-days
Registration Form 

This course is designed for users who want to explore some of the intermediate to advanced skill sets that Photoshop has to offer. Participants will be introduced to advanced tools that allow them to create text paths, advanced cloning features and working with complicated backgrounds. This course will teach the concept of masks for combining difficult photo imagery; removing objects or adding images to bleed through text. Participants will learn how to fit images into defined shapes or objects, and use a puppet warp feature for object manipulation. This course covers many other advanced features that extends what was learned in the Photoshop-Intro course.
Who Should Attend: People who are familiar with Windows and have taken the Photoshop-Intro course or have equivalent experience.

PDF icon Course Brochure (PDF) to print


Published on  and maintained in Cascade CMS.