Excel Cheat Sheet
Shortcuts, common functions, and chart tips on one page.
Open PDFA practical syllabus for real-world spreadsheets—clean data entry, rock-solid formulas, clear charts, and essential data tools.
SUM, AVERAGE, MIN, MAX$A$1) and when to use eachIF, COUNT, COUNTA, COUNTIF, TODAY, NOWChekc out our guides.
Grab a starter dataset.
Use this for our introduction to tables.
Download XLSXUse this for formulas, sorting/filtering, and charts.
Download XLSXPerfect for column/line charts and conditional formatting.
Download CSVCome exercises to practice in class and at home.
Data entry, formulae, functions, and sorting.
Download PDFVLOOKUP, data validation, IF statements, and dealing with errors
Download PDFUsing a Mac? No worries. Here is a helpful conversion guide.
Open PDF