Overview of course
This is a 1 day workshop for those designed for those who already have a good knowledge of Excel but want to enhance their knowledge to help them use the advanced features of Excel to create complex formulas, interactive reporting dashboards and automate tasks.
The format will be 'teach and try' where we show you what to do then you will be given files to try it out for yourself.
At the end of the course you will be able to use Pivot Tables and charts to create interactive reports and dashboards and use a wider range of formulas and functions to get the answers you need quickly.
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
Starting 03/07/2021
Saturday 10:00 - 15:00