Learn to use Microsoft Excel (2026) like a Pro – Intermediate Level
Curriculum
Excel – Intermediate2 lessons
- Microsoft Excel 365 Overview
- Essential Keyboard Shortcuts
Lists6 lessons
- What Are Lists
- Sorting A List
- Advanced Multi-Level Sorting
- Custom Sort Options
- Filtering Data
- Converting Lists To Tables
DataBase Functions7 lessons
- Introduction To Database Functions
- Dsum
- Dsum With Single Criteria
- Dsum With Multiple Criteria
- Daverage
- Dcount
- Subtotal
Data Validation3 lessons
- Dropdown Lists
- Decimal And Numeric Rules
- Input And Error Alerts
Importing and Exporting3 lessons
- Importing Text And Csv Files
- Importing Data From Ms Access And Other Sources
- Exporting Data To Text Files
Creating Basic Charts4 lessons
- Building Basic Charts
- Chart Tools And Ribbon
- Editing Chart Data
- Chart Formatting
Pivot Tables9 lessons
- Understanding Pivottables
- Creating Pivottables
- Pivot Calculations
- Grouping Data
- Formatting Pivottables
- Drill Down Analysis
- Pivotcharts
- Filtering Pivottable Data
- Pivottables And Slicers
Working with Large Data2 lessons
- Grouping Rows And Columns
- Data Consolidation
LookUp Functions4 lessons
- Vlookup
- Hlookup
- Index And Match
- Xlookup
Advanced Functions4 lessons
- Fv (Future Value)
- Pmt
- Hyperlinks
- Text To Columns
Excel Intermediate – Conclusion1 lesson
- Course Wrap Up
Excel Intermediate Resources2 lessons
- Exercises – Importing & Exporting Data – Nails Sales Data
- Resources
Marketing Videos2 lessons
- Advanced
- In Todays Modern World
About this course
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.