A solid Intro / Intermediate for those new to spreadsheets, and for self-taught users wanting to enhance their knowledge. These courses focus on workspace familiarisation, creating and managing data, formatting worksheets, charting and creating formulas and functions.
Courses designed for people who can already create moderately complex spreadsheets and want to add greater sophistication and automation. These Excel courses examine advanced functionality such as: Pivot Tables, Goal Seeking, Macros, Conditional Formatting, Filtering, Outlines, Range Names and Advanced: Charting and Functions (incl. database functions).
Excel VBA training is for highly skilled developers who wish to add high-end automation to their spreadsheets. You will examine VBA and programming techniques, concepts and terminology, then move on to create user defined functions, work with the VBA editor, create procedures and sub-routines, variables and more.
Learn the new and improved features of this powerful spreadsheeting program in a concise ½ day session. This course examines only new program features and thus is a time effective way to get up to speed with Excel 2010 and 2013. It is ideal for those already familiar with the advanced functionality of an older version.
