Extras
Workbooks to learn by doing
Small downloadable workbooks, one skill each, released part by part. Every one uses invented data, live formulas and practice questions that check themselves. The labs stay free; these are extras.
The first part is free now. Paid parts open once payments are set up: you will pay by UPI and the workbook arrives by email from [email protected].
6 parts
Workforce management in Excel
Plan a contact centre or any team the way WFM analysts do, one small workbook at a time. Invented data, live formulas, and questions that check themselves.
- 1Forecast the workFind the weekly pattern, forecast four weeks ahead and backtest it with MAPE, WAPE and bias.
- 2Turn contacts into hoursHandle time, workload and why averages hide the busy hour.
- 3Staff it with Erlang CHow many people answer 80% of calls in 20 seconds, built from the formula up.
- 4Shrinkage and the rosterLeave, breaks, training and meetings, and how they change the headcount you hire.
- 5Intraday: plan against actualAn hourly tracker that flags where the day is drifting.
- 6A WFM dashboardOne page with service level, occupancy and accuracy that refreshes from the other parts.
3 parts
Power Query
Clean and combine data with steps Excel remembers, so next month takes one click.
- 1Import and clean a messy fileSplit columns, fix dates, remove blanks and duplicates.
- 2Merge and append tablesLookups without VLOOKUP, and stacking monthly files.
- 3A report that refreshes itselfPoint a query at a folder and refresh.
3 parts
Macros and VBA
Automate the boring parts of a workbook, safely.
- 1Record your first macroWhat the recorder writes and when to trust it.
- 2Read and edit the codeVariables, ranges and loops in plain words.
- 3Buttons and a monthly reportA one-click routine with checks and a log.
3 parts
Dashboards in Excel
PivotTables, slicers and charts that update, laid out on one readable page.
- 1PivotTables and slicersSummaries you can filter with a click.
- 2Charts that updateTables, dynamic ranges and the right chart for each question.
- 3A one-page KPI dashboardLayout, colour and the numbers a manager reads first.
2 parts
Pictures in Excel
Put images inside cells and look them up like any other value.
- 1Pictures in cellsThe IMAGE function and Place in Cell in Microsoft 365.
- 2A picture lookupShow a product photo next to its code.
2 parts
Big data in Excel
Work past the million-row limit with the Data Model and Power Pivot.
- 1Past a million rowsLoad data into the Data Model instead of a sheet.
- 2Power Pivot measuresRelationships and your first DAX measures.
3 parts
Connections in Excel
Pull data from files, folders, the web and databases, and refresh it.
- 1Files and foldersCSV, text and folder connections.
- 2Web and databasesTables from a web page, and a SQL database query.
- 3Refresh and credentialsScheduled refresh, privacy levels and what breaks.
4 parts
SQL workbook
Short, easy examples on a small practice database, each with a task and an answer.
- 1SELECT and WHEREPick columns and filter rows.
- 2GROUP BYTotals and averages by group, and HAVING.
- 3JOINsInner, left and the mistakes that double rows.
- 4Window functionsRunning totals, ranks and the previous row.
4 parts
Python workbook
pandas from the first table to a chart, with small examples you can run anywhere.
- 1pandas basicsRead, select and filter.
- 2Cleaning dataMissing values, types and duplicates.
- 3Group and pivotSummaries by group.
- 4ChartsFrom a table to a clear picture.
3 parts
R workbook
The tidyverse way: dplyr, tidyr and ggplot2.
- 1dplyr basicsFilter, select, mutate and summarise.
- 2Tidy dataLong, wide and why it matters.
- 3ggplot2Charts in layers.
2 parts
Power BI
A model, measures and a report, from a small dataset.
- 1The modelTables, relationships and a date table.
- 2DAX measuresCALCULATE and filter context in plain words.
Want one sooner?
Tell us which part you would use first: [email protected]. We build the most asked-for next. You can also support the labs.