Training · Free

Free Excel videos and practice files

All 13 Beginner videos in my Excel tutorial series are free to watch below, and each one has a practice workbook that matches it. No sign-up.

  • 13 videos, 13 workbooks
  • Free, no sign-up
  • Answer key in every file

How the files work

  1. Open the Start tabIt tells you what the file covers and which tab goes with which chapter.
  2. Do one tab per chapterEach chapter has its own tab with the data already in it. Try it yourself first.
  3. Check the Answer Key tabStuck or done? Compare your work with the answer key at the end.
Google Sheets: the files also open in Google Sheets. Upload the file to Google Drive, then open it with Google Sheets. Some tabs only partly work in Sheets. Each file has a tag so you know before you start: Works in Google Sheets Partly works in Google Sheets
All data in these files is made up. Names and numbers are fake. Nothing comes from a real company or person.

Beginner

13 videos · Start here if you are new to Excel or never had anyone show you the basics.

Part 1 · About 5 min

Beginner, part 1: Basic Formulas

Works in Google Sheets

Download .xlsx Beginner-01-Basic-Formulas.xlsx · 20 KB

7 chapters in this file
  • Excel cells, rows, and columns explained Tab: Cells and ranges Sheets: yes
  • How to add in Excel Tab: Add Sheets: yes
  • Excel SUM formula Tab: SUM Sheets: yes
  • Excel subtraction formula Tab: Subtract Sheets: yes
  • Multiply and divide in Excel Tab: Multiply and divide Sheets: yes
  • AVERAGE formula in Excel Tab: AVERAGE Sheets: yes
  • COUNT formula in Excel Tab: COUNT Sheets: yes

Part 2 · About 7 min

Beginner, part 2: Min, Max, and Formula Errors

Works in Google Sheets

Download .xlsx Beginner-02-Min-Max-and-Formula-Errors.xlsx · 18 KB

6 chapters in this file
  • MIN and MAX formulas in Excel Tab: MIN and MAX Sheets: yes
  • Order of operations in Excel Tab: Order of operations Sheets: yes
  • How to show formulas in Excel Tab: Show formulas Sheets: yes
  • Excel formula showing as text Tab: Formula showing as text Sheets: yes
  • Common Excel errors explained Tab: Common errors Sheets: yes
  • Quick sum in the status bar Tab: Status bar quick sum Sheets: yes

Part 3 · About 8 min

Beginner, part 3: Copy a Formula

Works in Google Sheets

Download .xlsx Beginner-03-Copy-a-Formula.xlsx · 21 KB

7 chapters in this file
  • How to autofill in Excel Tab: Autofill Sheets: yes
  • Fill down a formula Tab: Fill down Sheets: yes
  • Autofill a series Tab: Fill a series Sheets: yes
  • Absolute vs relative cell reference Tab: Absolute vs relative Sheets: yes
  • What the dollar sign does in Excel Tab: Dollar sign Sheets: yes
  • How to lock a cell in a formula Tab: Lock a cell Sheets: yes
  • Mixed cell reference Tab: Mixed reference Sheets: yes

Part 4 · About 7 min

Beginner, part 4: IF Formula

Works in Google Sheets

Download .xlsx Beginner-04-IF-Formula.xlsx · 17 KB

6 chapters in this file
  • Excel IF formula for beginners Tab: IF basics Sheets: yes
  • If greater than in Excel Tab: IF greater than Sheets: yes
  • Over budget formula Tab: Over budget formula Sheets: yes
  • How to show yes or no in Excel Tab: Show yes or no Sheets: yes
  • IF with a calculation Tab: IF with a calculation Sheets: yes
  • IF a cell equals text Tab: IF a cell equals text Sheets: yes

Part 5 · About 7 min

Beginner, part 5: Sort, Filter, and Freeze

Partly works in Google Sheets

Download .xlsx Beginner-05-Sort-Filter-and-Freeze.xlsx · 26 KB

7 chapters in this file
  • How to sort in Excel Tab: Sort Sheets: yes
  • Sort by more than one column Tab: Sort by two columns Sheets: partly
  • How to filter in Excel Tab: Filter Sheets: yes
  • Number and date filters Tab: Number and date filters Sheets: yes
  • Clear a filter in Excel Tab: Clear a filter Sheets: yes
  • Freeze top row in Excel Tab: Freeze top row Sheets: yes
  • Freeze first column and unfreeze panes Tab: Freeze first column Sheets: yes

Part 6 · About 6 min

Beginner, part 6: Rows and Columns

Partly works in Google Sheets

Download .xlsx Beginner-06-Rows-and-Columns.xlsx · 17 KB

6 chapters in this file
  • How to insert a row in Excel Tab: Insert a row Sheets: yes
  • Delete rows and columns Tab: Delete rows and columns Sheets: yes
  • Autofit column width Tab: Autofit column width Sheets: yes
  • Hide and unhide columns Tab: Hide and unhide columns Sheets: yes
  • Move a column in Excel Tab: Move a column Sheets: partly
  • Jump to the end of your data Tab: Jump to the end Sheets: yes

Part 7 · About 7 min

Beginner, part 7: Format Cells

Partly works in Google Sheets

Download .xlsx Beginner-07-Format-Cells.xlsx · 17 KB

7 chapters in this file
  • Currency and number format Tab: Currency and number Sheets: yes
  • Percentage format Tab: Percentage format Sheets: yes
  • Date format Tab: Date format Sheets: yes
  • Wrap text and alignment Tab: Wrap text and alignment Sheets: partly
  • Borders and fill color Tab: Borders and fill Sheets: yes
  • Format Painter Tab: Format Painter Sheets: yes
  • Clear formats Tab: Clear formats Sheets: yes

Part 8 · About 8 min

Beginner, part 8: Percentages and Rounding

Works in Google Sheets

Download .xlsx Beginner-08-Percentages-and-Rounding.xlsx · 20 KB

7 chapters in this file
  • How to calculate percentage in Excel Tab: Percentage Sheets: yes
  • Percent change formula Tab: Percent change Sheets: yes
  • Add or subtract a percentage Tab: Add or subtract a percent Sheets: yes
  • Percent of total Tab: Percent of total Sheets: yes
  • ROUND formula in Excel Tab: ROUND Sheets: yes
  • ROUNDUP and ROUNDDOWN Tab: ROUNDUP and ROUNDDOWN Sheets: yes
  • Why Excel totals are off by a penny Tab: Totals off by a penny Sheets: yes

Part 9 · About 6 min

Beginner, part 9: Sheets and Saving

Partly works in Google Sheets

Download .xlsx Beginner-09-Sheets-and-Saving.xlsx · 17 KB

6 chapters in this file
  • Add, rename, and color sheet tabs Tab: Add and rename tabs Sheets: yes
  • Copy a sheet in Excel Tab: Copy a sheet Sheets: partly
  • Reference another sheet in a formula Tab: Reference another sheet Sheets: yes
  • Hide and unhide a sheet Tab: Hide and unhide a sheet Sheets: yes
  • Save as xlsx vs csv Tab: Save as xlsx vs csv Sheets: partly
  • AutoSave and version history Tab: AutoSave and history Sheets: partly

Part 10 · About 6 min

Beginner, part 10: Print a Spreadsheet

Partly works in Google Sheets

Download .xlsx Beginner-10-Print-a-Spreadsheet.xlsx · 42 KB

7 chapters in this file
  • Set print area in Excel Tab: Set print area Sheets: partly
  • Fit sheet on one page Tab: Fit on one page wide Sheets: partly
  • Landscape and margins Tab: Landscape and margins Sheets: partly
  • Repeat header row on every page Tab: Repeat header row Sheets: partly
  • Page Break Preview Tab: Page Break Preview Sheets: partly
  • Page numbers in header and footer Tab: Page numbers in footer Sheets: partly
  • Save Excel as PDF Tab: Save as PDF Sheets: partly

Part 11 · About 6 min

Beginner, part 11: Basic Charts

Partly works in Google Sheets

Download .xlsx Beginner-11-Basic-Charts.xlsx · 17 KB

7 chapters in this file
  • How to make a chart in Excel Tab: Make a chart Sheets: partly
  • Line chart in Excel Tab: Line chart Sheets: partly
  • Pie chart in Excel Tab: Pie chart Sheets: partly
  • Bar chart in Excel Tab: Bar chart Sheets: partly
  • Chart title, axis titles, and data labels Tab: Titles and data labels Sheets: partly
  • Change chart colors and style Tab: Chart colors and style Sheets: partly
  • Move or resize a chart Tab: Move or resize a chart Sheets: partly

Part 12 · About 6 min

Beginner, part 12: Copy, Paste, and Find

Partly works in Google Sheets

Download .xlsx Beginner-12-Copy-Paste-and-Find.xlsx · 16 KB

6 chapters in this file
  • Copy, cut, and paste in Excel Tab: Copy, cut and paste Sheets: yes
  • Paste values only Tab: Paste values only Sheets: yes
  • Transpose rows to columns Tab: Transpose Sheets: yes
  • Find and replace in Excel Tab: Find and replace Sheets: yes
  • Undo and redo Tab: Undo and redo Sheets: yes
  • Add a note or comment to a cell Tab: Notes and comments Sheets: partly

Part 13 · About 6 min

Beginner, part 13: Practice with a Monthly Budget

Partly works in Google Sheets

Download .xlsx Beginner-13-Practice-with-a-Monthly-Budget.xlsx · 19 KB

6 chapters in this file
  • Practice file: a monthly budget Tab: Inputs vs formulas Sheets: yes
  • Clear numbers but keep formulas Tab: Clear numbers keep formulas Sheets: partly
  • Enter income and bills Tab: Enter income and bills Sheets: yes
  • Money left over formula Tab: Money left over Sheets: yes
  • Over budget check with IF Tab: Over budget check Sheets: yes
  • Percent of income per category Tab: Percent of income Sheets: yes

Want all of them?

One zip with all 13 Beginner workbooks. The videos are free to watch above.