Microsoft Excel Intermediate

Course overview

Ideal for those with a good knowledge of Excel, who are responsible for the analysis and manipulation of data to automate spreadsheets.

Ready to take your Excel skills to the next level? This intermediate course is designed for users who already know the basics and want to unlock more powerful features. Building on your foundation, you’ll discover advanced functions, smarter data management tools, and techniques to work faster and more accurately.

Through practical exercises, you’ll master logical and lookup functions (including VLOOKUP and XLOOKUP), link and manage data across multiple sheets, and use sorting, filtering, and subtotals to structure and analyse information efficiently. You’ll also get hands-on with PivotTables for dynamic data analysis and learn how to use conditional formatting and advanced charting to create professional, impactful reports.

By the end of the course, you’ll confidently manage and analyse complex data, produce polished reports, and save time with smarter formulas and shortcuts, laying the groundwork for advanced Excel and business intelligence.

Course benefits

• Work smarter, not harder: Learn practical techniques to keep your data clean, organised, and error-free.
• Build confidence with formulas & functions: Master calculations, cell references, and automation to reduce manual work.
• Turn data into insight: Create clear charts and graphs to spot trends and patterns at a glance.
• Professional presentation: Control layouts, page setup, and printing for polished, print-ready spreadsheets.
• Highlight what matters: Use conditional formatting to make important data stand out.
• Foundation for further learning: Build the skills needed for advanced Excel, analytics, or business intelligence courses.
• High-impact learning in one day: Gain practical skills you’ll use immediately, delivering value far beyond the course fee.