Attendance / Duration
2 Days (9:30am - 4:30pm)Overview
Start Date: Tuesday 15 December 2026. This 2 day course is designed to equip participants with the knowledge and practical skills to harness the potential of Microsoft Excel for data analysis, reporting, and automation.Cost
£360 (Payment Plan options available, please contact our finance department for further information). Full funding is available through the New Flexible Workforce Development Fund (NFWDF) subject to individual eligibility. Please note, the NFWDF requires you to discuss your application with your employer before applying. If you have already done this, or if you/your employer is paying your fee, please click 'Apply Now'.
Course Dates
- Tuesday, 15 December 2026 (09:30 - 16:30)
- Wednesday, 16 December 2026 (09:30 - 16:30)
Whats Involved?
This Excel Advanced course is designed to equip participants with the knowledge and practical skills to harness the potential of Microsoft Excel for data analysis, reporting, and automation.
Participants should have a solid foundation in Microsoft Excel, including proficiency in basic functions (SUM, AVERAGE, IF, etc.), using charts and pivot tables, and working with worksheets and workbooks. Knowledge of Excel's intermediate features is recommended.
Microsoft Office 2013 or above is required.
Course Content
This course will cover the following:
- Summarise data with grouping, outlining, subtotals and PivotTables
- Manage and analyse data with Excel Tables
- WhatIF Analysis - Scenarios, Goal Seek and Data Tables
- Advanced functions – Logical, Financial, LOOKUP
- Working with dates and times
- Visualise data with more advanced chart techniques
- Record Macros to automate tasks
By the end of this course participants will have an understanding of the more advanced functions of Excel. They will be able to manipulate and analyse data to extract meaningful information which will help increase their productivity.