Learn to use Microsoft Excel (2026) like a Pro - Intermediate Level

Excel 2026 Intermediate: Practical Data Analysis & Reporting

This Excel 2026 Intermediate course is designed for learners who already understand the basics of Excel and want to work faster, smarter, and more confidently with real-world data.

You will move beyond simple spreadsheets and learn how to structure, clean, analyse, and visualise data using the tools professionals rely on every day. The course focuses on practical workflows, helping you turn raw data into meaningful insights while maintaining accuracy and control.

What you’ll learn in this Excel Course

• Work efficiently with structured data using lists and Excel Tables
• Apply advanced sorting and filtering techniques, including multi-level and custom rules
• Use database-style functions (DSUM, DAVERAGE, DCOUNT, SUBTOTAL) to analyse data based on criteria
• Control data entry with dropdown lists, validation rules, and error alerts
• Import, clean, and export data from text files, CSVs, Access, and other sources
• Create clear, professional charts and keep them dynamically updated
• Build powerful PivotTables and PivotCharts to summarise and explore large datasets
• Use slicers, grouping, and drill-down tools for interactive analysis
• Manage and consolidate large datasets across multiple worksheets or workbooks
• Master essential lookup functions, including VLOOKUP, HLOOKUP, INDEX & MATCH, and XLOOKUP
• Apply additional financial and productivity functions such as FV, PMT, and hyperlinks

Who this course is for

• Excel users who have completed a beginner-level course and want to progress
• Professionals working with reports, lists, or datasets in Excel 365
• Entrepreneurs, analysts, and office users who want faster, more reliable data analysis
• Anyone looking to gain confidence working with larger and more complex spreadsheets

Outcome

By the end of this course, you will be able to analyse data more efficiently, reduce errors, and produce clear, insightful reports using Excel 365’s modern tools. You’ll not only know how the features work, but when and why to use them in real-world scenarios.