Video lessons
Each tool built step by step in full-screen Excel, with a large formula strip so you can always read what is typed.
Course 2 of 6 · The Data Analytics pathway
XLOOKUP, PivotTables & Power Query
Go from opening your first file to building a refreshable business dashboard. Clean data, write formulas, match tables with XLOOKUP, summarise with PivotTables and automate with Power Query to answer questions from the fictional Kettle & Bean team.
Free preview lesson
What you will learn
Microsoft 365 desktop Excel on Windows or Mac. Excel for the web and Excel 2021 or earlier are missing some functions and tools the course uses. The course files are a free download in Section 1. No Excel experience is needed.
What's included
Each tool built step by step in full-screen Excel, with a large formula strip so you can always read what is typed.
A handbook for every section, so you can review the ideas and examples at your own pace.
Short checks at the end of each section to confirm you have understood the key ideas.
A challenge brief to work through on your own in each section, then a solution walkthrough to compare your work with.
Three years of sales, customer and returns data from the fictional company, with start and finish files for each lesson.
Let AI draft a PivotTable, a chart or a formula, then prove it right against a trusted figure.

Inside the handbook
Each section has its own handbook with the notes, analogies, every worked example with its real result, and space for your answers. Type in the fillable PDF or print it.
Shown: the Section 4 cover and the Lesson 4.2 page on XLOOKUP.
Course content
Open a CSV, check what arrived, and work with Excel Tables, sort, filter and freeze panes.
Write formulas, copy them with relative and absolute references, round, format and highlight.
Fix text, split and combine columns, repair dates and remove duplicates the right way.
Make decisions with IF and IFS, look up values with XLOOKUP and handle lookups that fail.
Use SUMIFS, COUNTIFS and SUMPRODUCT, then build and filter PivotTables.
Clean, append and merge files that refresh, and build live lists with FILTER and SORT.
Choose the right chart, show distributions, and plan with Goal Seek and data tables.
Design and check a one-page dashboard, present your findings and use Copilot with checks.
In Section 8 you build a one-page dashboard for Kettle & Bean that refreshes with Power Query, with KPI cards, revenue against target, regional and channel views and a check sheet. You finish with a short summary for the board that explains what the results mean.

See inside the course
Explore slides from the actual lessons, including the live demonstrations. Click or tap any image to see it full size.
Kettle & Bean Co. is a fictional company created for teaching.
The learning scenario
Each lesson starts with a realistic request from a colleague at a fictional UK coffee and tea retailer. You query the data, check the result and explain what it shows.
Amara
Priya
Grace
Marcus
Tom
Ellie
Created by Virtavis Learning
Data and Business Intelligence Specialist, founder of Virtavis Learning
Sophie Lumpa created this course and designed the Kettle & Bean learning scenario, bringing realistic business questions into the learning experience. The Virtavis teaching team provides additional training and learner support through the Bootcamp and live cohorts.
On the pathway
Questions
If your question isn't answered here, send it to us and the Virtavis team will reply by email.
Contact us ›See how the lessons work before you choose.