IT Training

MS Excel - Advanced - ONLINE

Objectives

• This course is designed to follow-on from MS Excel Intro- Intermediate.
• Having already familiarised yourself with the most efficient way of performing everyday tasks, and having covered some intermediate topics, it is now time to build on that knowledge.
• 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

Upcoming dates:

No training dates available at the moment.