Excel Cheat Sheet
Shortcuts, common functions, and chart tips on one page.
Open PDFWhat You’ll Learn
- Excel basics: sheets, rows/columns/cells, efficient data entry (text, numbers, dates)
- Formatting: number/currency (£), dates, borders, column width/auto-fit, basic layout polish
- Productivity: copy/paste, AutoFill, Undo/Redo, quick selection tricks
- Core formulas:
SUM,AVERAGE,MIN,MAX - Cell references: relative vs absolute (
$A$1) and when to use each - Charts: column & line charts, titles, axis labels, legends, choosing the right chart type
- Data tools: sorting, filtering, conditional formatting, data validation (restrict entry)
- Everyday functions:
IF,COUNT,COUNTA,COUNTIF,TODAY,NOW - Word + Excel: intro to Mail Merge using a simple contact dataset
- Mini-projects: budget sheet, ice-cream sales vs temperature charts, simple job/task trackers
User Guides
Chekc out our guides.
VLOOKUP Cheat Sheet
VLOOKUP, data validation, and IF statements all in one please.
Open PDFPractice Files
Grab a starter dataset.
Starter Dataset (XLSX)
Use this for our introduction to tables.
Download XLSXPixar Dataset (XLSX)
Use this for formulas, sorting/filtering, and charts.
Download XLSXFruit-Seller Sales Dataset
Perfect for column/line charts and conditional formatting.
Download CSVExercises
Come exercises to practice in class and at home.
Exercise Sheets 1
Data entry, formulae, functions, and sorting.
Download PDFExercise Sheets 2
VLOOKUP, data validation, IF statements, and dealing with errors
Download PDFPC vs Mac
Using a Mac? No worries. Here is a helpful conversion guide.
Open PDFOutcomes
- Enter, format, and organise data clearly and consistently
- Write reliable formulas and use absolute/relative references correctly
- Create and format clear, purposeful charts
- Apply sorting, filtering, conditional formatting, and validation to real data
- Build small but useful projects (budget sheet, ice-cream analysis, job tracker)
- Understand how to link Excel with Word via Mail Merge