Overview of course
What will I learn?
- More complex Pivot Tables and slicers
- More advanced formulas and functions e.g. VLOOKUP, text and date functions. Using names and dealing with formula errors
- Working with external data
- Data Validation
- An introduction to Macros
Who is the course for?
Those who already have a good knowledge of Excel but want to use the more advanced features of Excel to create complex formulas, interactive reports and dashboards and automate tasks.
Will I have to provide anything?
Computers and handouts will be provided; however, if you have one, you can bring in a USB (memory) stick so you can take home the example files and work completed in the course.
Days & times
Saturday 10:00 - 15:00