This advanced Excel course is designed for professionals who use Excel regularly and want to master its more powerful tools for data analysis and productivity. It’s ideal for learners who have completed an intermediate-level course or already feel confident with basic Excel functions.

You'll learn:

  • advanced analysis tools to work with complex data sets
  • advanced functions and formulas for deeper insights
  • data validation and protection techniques
  • pivot tables and charts for dynamic reporting
  • logical functions like IF, AND, OR, and nested formulas
  • lookup functions such as VLOOKUP, HLOOKUP, and INDEX/MATCH
  • what-if analysis tools like Goal Seek and Scenario Manager
  • macros and automation basics to streamline repetitive tasks

Who is it for

This course is ideal for:

  • professionals who want to enhance their Excel skills for work
  • learners who have completed the Intermediate Excel course
  • anyone looking to analyse data more effectively and work more efficiently

This course is repeating in October and December. 

October

Session Date Time
Evening 1 Monday 6 October 6pm to 8:30pm
Evening 2 Wednesday 8 October 6pm to 8:30pm

 

December

Session Date Time
Evening 1 Monday 8 December 6pm to 8:30pm
Evening 2 Wednesday 10 December 6pm to 8:30pm

 

This course is run at Weymouth Library, Great George Street, DT4 8NN. Please note access to the library is restricted during the evenings. You will need to arrive at least 5 minutes early, and enter from the side entrance. A staff member will be present to ensure you can access the building. If you arrive late for your class, you may be unable to enter.

Materials and Costs

  • completely free for all learners
  • computers provided at Weymouth Library
  • light buffet or packed meal provided
  • access to Office 365 included
  • optional: bring a pen and notebook for personal notes
  • no home computer required - library access is available

Register

You can register with in one of the following ways: