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 | Tuesday 7 October | 6pm to 8:30pm |
Please note the date change for the second day of the above course
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:
- for October start: Enrol on the course
- for December start: Enrol on the course
- in person: Visit Weymouth Library
- by phone: Call the training provider, Skills and Learning on 01202 123444