Practical guides for the workweek

Make Excel
work for you.

Get the spreadsheet in front of you done. Learn to clean data, track deadlines and build clear reports with twelve guides for everyday office work.

Laptop showing a spreadsheet beside a green notebook, a pen and lilac sticky notes Featured guide Excel Office
Starter
View the guide
  • 12 Excel guides
  • Worked examples
  • English PDFs

Start here

Start with one useful worksheet.

Build an office supply order from a blank sheet. Enter data, add totals and check the finished result.

See the starter guide
Excel Office Starter cover

How the guides work

Choose an office taskFrom a first table to a weekly report.

Start with Excel Office Starter for your first worksheet, or choose a guide that covers a report or tracker you already use.

Work through sample dataType the examples into your own workbook.

The examples use English function names and commas between arguments. Some versions and regional settings use different menus or separators.

Check your resultCompare your totals before using your own data.

Each PDF contains sample data, practical steps and ways to check your results.

Pivot Tables for Office Reports cover

The reporting collection

Explore the PivotTable guide

The e-book shop

Find your next Excel guide.

Browse practical guides for the spreadsheets, reports and trackers you use at work.

Excel Office Starter e-book cover

Excel E-book · Beginner

Excel Office Starter

Build a tidy worksheet for a real office task. Enter data, format numbers, use AutoSum and turn a supply order into a workbook someone else can read.

$19.00
Formulas for Office Work e-book cover

Excel E-book · Beginner

Formulas for Office Work

Use everyday formulas to total amounts, count entries and flag exceptions. Practice on a small office dataset and learn when to lock a reference.

$24.00
Clean and Fix Spreadsheets e-book cover

Excel E-book · Beginner

Clean and Fix Spreadsheets

Turn a messy data export into a list you can sort and report on. Clean text, fix numbers stored as text and review duplicate records while keeping the original.

$24.00
Excel Tables and Filters e-book cover

Excel E-book · Beginner

Excel Tables and Filters

Make a growing list easier to sort, filter and summarize. Practice table formulas and learn to check what changes when a filter hides rows.

$22.00
The Office Lookup Playbook e-book cover

Excel E-book · Intermediate

The Office Lookup Playbook

Match a record to the details you need using exact lookups. Handle missing IDs and duplicates, and practice a VLOOKUP alternative.

$29.00
Pivot Tables for Office Reports e-book cover

Excel E-book · Intermediate

Pivot Tables for Office Reports

Turn a list of office requests into a report by team and status. Practice sorting, filtering and refreshing a PivotTable, then check the totals.

$29.00

Learn with a real task

Practice once.
Use it at work.

  1. Pick a guide

    Pick a task you already do at work.

  2. Try the example

    Follow the steps with the sample data.

  3. Check your result

    Compare your sheet with the worked answer.

Before you begin

A few good
questions.

Which e-book should I start with?

Choose Excel Office Starter if you’re new to Excel. If you already use it, pick a guide for one task you want to do better.

What format are the e-books?

The guides are downloadable PDFs in English, with instructions and sample data in each guide.

Which version of Excel do I need?

The guides were written for Microsoft 365 Excel on Windows. Some menus and formulas may differ in older versions, on Mac or in a browser.

Is Microsoft Excel included?

The purchase includes the PDF guide. You’ll need your own access to Microsoft Excel to follow the exercises.

Need a hand choosing a guide?

Contact us