The Excel Advanced course assumes students are confident in working with Excel and the spreadsheet environment. Students will want to learn more functions available to them other than the standard sum function. Typically in their workplace they are required to use Excel a great deal to evaluate, extract and analyse results and desire techniques to automate tasks. They may also have an interest in gaining a basic knowledge of VBA code to understand macros more fully.
As a result of this course students will be able to use a variety of lookup, logical, financial and statistical functions. Analytical features of the Goal Seek, Scenario Manager will be demonstrated, and students will gain exposure to Macros including an introduction to VBA code.
Microsoft Excel Intermediate 2010 or equivalent