MS Excel - Advanced Level
Objectives
- A large proportion of the course is dedicated to using the Database Features in MS Excel – this is a very powerful side to Excel that not many people utilise to its fullest potential.
- Useful functions such as IF and Lookups are covered in addition to automating tasks using Macros etc.
- These online webinars have been designed to replace classroom-based training whilst people are required to work from home.
Content includes
- Module 1 - Dates / Protecting Content / Data Validation
- Module 2 - More on Functions (Part 1)
- Module 3 - More on Functions (Part 2)
- Module 4 - Pivot Tables and Pivot Charts
- Module 5 - Macros
Who should attend
MS Excel users who are currently at Intermediate level and would like to learn the advanced features.
Qualification
CPD Accredited