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.
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.
The memory needed will be less than 1 Gigabyte so any old memory stick you have lying around with a little bit of space on it would be OK.
Am I ready to start?
I'm interested. What should I do now?
To enrol and pay for this course you must visit www.wsc.ac.uk and apply for course code 19LP3123CHA by clicking the Enrol Online button.
Days & times
Saturday 10:00 - 14:00