top of page

What’s Included in Our Intermediate Microsoft Excel Course?

  • 7 days ago
  • 2 min read

If you already understand the basics of Excel but want to work more efficiently, confidently, and professionally, our Intermediate Excel Course is the next step.


This course is designed for users who can already create simple spreadsheets and basic formulas but want to move into more structured data handling, smarter calculations, and reporting tools.


It bridges the gap between basic use and advanced data analysis.


Who Is This Course For?


This course is ideal if:


  • You already use SUM and basic formulas

  • You can format spreadsheets confidently

  • You understand rows, columns, and worksheets

  • You want to analyse data rather than just enter it

  • You use Excel regularly at work

You may not need this course if you already confidently use PivotTables, advanced lookups, and data analysis tools.



What You Will Learn


Below is a full overview of the syllabus so you can assess your current level.


1️⃣ Advanced Formatting Techniques

  • Custom number formatting

  • Conditional formatting

  • Professional report layout

  • Formatting for readability and presentation


2️⃣ Logical Functions

  • IF statements

  • Nested IF statements

  • AND / OR functions

  • Using logic to automate decision-making in spreadsheets


You will learn how to make Excel think for you.


3️⃣ Lookup Functions

  • VLOOKUP

  • Introduction to XLOOKUP

  • Understanding lookup structure

  • Linking data between sheets


This is essential for administrative and finance roles.


4️⃣ Working with Multiple Worksheets

  • Linking data across sheets

  • Creating summary sheets

  • 3D formulas

  • Managing larger workbooks


5️⃣ Data Validation & Drop-Down Lists

  • Creating controlled entry fields

  • Preventing user errors

  • Improving spreadsheet accuracy


6️⃣ Text Functions

  • LEFT

  • RIGHT

  • MID

  • CONCAT / TEXTJOIN


Useful for cleaning and restructuring data.


7️⃣ Date & Time Functions

  • TODAY

  • NOW

  • DATEDIF

  • Calculating durations


8️⃣ PivotTables

  • Creating PivotTables

  • Summarising large datasets

  • Grouping data

  • Filtering and sorting Pivot data


This is where Excel becomes a reporting tool.


9️⃣ PivotCharts

  • Turning data summaries into visual reports

  • Customising PivotCharts

  • Creating dynamic reports


🔟 Introduction to What-If Analysis

  • Goal Seek

  • Basic forecasting techniques


🔐 Protecting Workbooks

  • Locking cells

  • Protecting sheets

  • Preventing accidental changes


What You Will Be Able To Do After This Course


By the end of this course, you will be able to:


✔ Use logic-based formulas

✔ Link data across multiple sheets

✔ Retrieve information automatically

✔ Create structured reports using PivotTables

✔ Control data entry with validation tools

✔ Analyse information instead of just listing it


💡 Do You Need This Course?


You likely need this course if:


  • You manually search for information instead of using lookups

  • You don’t use IF statements

  • You’ve heard of PivotTables but don’t use them

  • You rely heavily on manual calculations

  • You want to improve efficiency in your role


If you already confidently use PivotTables, INDEX & MATCH, dynamic arrays, dashboards, or Power Query, you may be ready for our Advanced Excel Course instead.

Comments

bottom of page