Our experienced trainers will help you extend your understanding and knowledge of Microsoft Excel, whether that be further formatting options, or automated data analysis and manipulation tools.
The course covers conditional formatting, lookup functions, pivot tables, pivot charts, using named cells/ranges, goal seeking, data validation, linking, consolidating sheets, importing and exporting, sheet protection, plus an introduction to Macros.
You will have the opportunity to learn about more complex formulas and functions beyond what is covered in the Introduction course – for example, statistical, date, logical, lookup and financial functions.
This is an intermediate level course. Participants are required to have completed our Introduction to Excel course, or have equivalent experience with the software.
This course is part of the Office 365 course.