Microsoft Excel Advanced
This course is the last of a 3-Level study program for Microsoft Excel. This course aims to provide skills and knowledge which will allow the attendee to create complex lookup functions, enhance charts, perform advanced data operations using summarising, PivotTables, data consolidations, goal seeking, and Solver, and create and use macros.
This course assumes the learner has a good level skills and knowledge in creating and editing spreadsheets, as well as a good level of experience writing formulas and using functions, including basic logical (IF) and lookup (VLOOKUP) functions.
At the completion of this course you should be able to: