Find your next Excel guide.

Charts and Weekly Dashboards

Build a weekly office dashboard from a small dataset. Pick a chart that answers a specific question and audit the numbers before sharing.

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.

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.

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.

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.

Inventory and Reorder Basics

Make a simple inventory sheet for office supplies. Track stock, flag items that reach a reorder point and check the numbers against a physical count.

Monthly Expense Tracker

Create an office expense log and summarize costs by category and month. Reconcile the summary with the source rows before sharing it.

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.

Print and Share Excel Reports

Prepare a worksheet for readers who need a clean printout or PDF. Set the print area, review page breaks and check for information you don’t want to share.

Task and Deadline Tracker

Build a tracker that shows what is overdue, coming up or complete. Use a fixed reference date for the exercises, then make the tracker work for your team.

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.

Timesheets with Excel

Calculate elapsed time and convert it to decimal hours. Practice shifts that cross midnight, subtract breaks and check weekly totals.