Level 1
Excel Expert Short Course (half day)
Level 1
Excel Expert Short Course (half day)
Want to master Excel like a pro? Our Excel Expert Short Course is designed for confident users who are ready to unlock the most powerful tools Excel has to offer.
What will I study?
In this intensive half-day session, you’ll dive into advanced functions, dynamic arrays, and data modelling techniques used by professionals. Learn how to automate and transform data with Power Query, build powerful insights with Power Pivot, and apply best practices to create efficient, reliable spreadsheets. This course is ideal for anyone looking to work smarter, handle complex data, and stand out with high-level Excel skills.
Advanced Functions and Dynamic Arrays
- INDEX, MATCH, XLOOKUP, XMATCH, UNIQUE
- Array formulas and dynamic arrays
Power Query
- Importing data (CSV, Excel, web)
- Cleaning and transforming data
- Merging and appending queries
- Loading data to Excel tables or PivotTables
Power Pivot and Data Modelling
- Enabling Power Pivot
- Creating data models and relationships
- Writing calculated columns and measures (DAX basics)
- Building advanced PivotTables with Power Pivot
Best Practices
- Auditing formulas and tracing errors
- Reducing file size and improving performance
- Protecting workbooks and worksheets
- Documentation and version control
Course Details
Course: Excel Basics Short Course - Half Day Location: Winter Gardens, North, Royal Parade, Weston-super-Mare BS23 1AJ Date: 17th June 2026 Duration: Half day from Time: 13:30 to 17:00 Delivery: Face to face Cost: £65 per person
Full Fee: £0.00 ?
Supported Fee: £0.00
Most people qualify for FREE tuition and material fees due to discounts we offer. Click on the icon(s) below to find out what you’ll need to pay.
HEAR ABOUT THE LATEST VACANCIES
Sign up to our Apprenticeship Vacancy Mailing list and be the first to hear about the latest opportunities