Course Overview
This comprehensive training course is designed for individuals looking to enhance their Excel skills, focusing on advanced functionalities and techniques essential for efficient data management and analysis. Participants will revisit foundational concepts in formulas and functions before delving into advanced topics, including nested functions, Pivot Tables, and data validation.
- Advanced Formulas to check and reference a variety of criteria
- Using Formulas to combine or reformat cells and text
- Protecting/Locking Sheets and Workbooks
Course Benefits
This Advanced Excel course is designed to help users maximise the power of Excel by developing advanced data analysis, reporting, and automation skills. Delegates will learn how to use complex formulas, PivotTables, dashboards, and data management tools to work more efficiently, improve accuracy, and save time. The course is ideal for anyone who regularly works with data and wants to create more insightful reports, streamline processes, and increase their confidence in Excel.
What You'll Learn
- Formulas & Functions (re-cap)
- Formulas & Functions (advanced)
- Pivot Tables & Charts
- Data Validation
- Advanced Filters
- Protecting & Sharing Workbooks
- Macros
Who It's For
- Excel users with a good understanding of Excel functionality able to write formulas.
Additional Information
Should you require any further information please talk to us on 0345 222 1551 | Option 3 or email training@schoolbusinessservices.co.uk
Upcoming Dates
-
Friday 20th November 2026 10:00am - 11:45amBook Now