Skip to Main Content

Excel

Excel

Excel is a program that uses spreadsheets to organize information. A spreadsheet is a table with rows and columns of cells, where each cell contains a piece of information. Links between cells allow a group of related calculations to be updated when a single cell is changed. Basic computer skills are needed to use Excel.

Excel 1

Part 1 - Learn about basic spreadsheets, cell formatting, and using the mouse. (26:36)

Part 2 - Build on the basics with labels, formatting text within cells, adding colour, and autofill/autocomplete features. (33:57)

Part 3 - Focus on basic math, data entry, adding, and functions. (34:29)

Part 4 - Learn about MIN, MAX, and AVERAGE functions. (21:27)

Part 5 - Review Level 1 with this summary. (18:57)

Excel 2

Part 1 - Learn the basics of IF statements. (23:34)

Part 2 - Learn about using numbers in IF statements. (6:53)

Part 3 - Learn how to use math in IF statements. (9:46)

Excel 3

Part 1 - Get introduced to VLOOKUP, and relative and absolute cell references. (22:50)

Part 2 - VLOOKUP Example 1 - labels (9:34)

Part 3 - VLOOKUP Example 2 - numbers (10:50)

Part 4 - VLOOKUP Example 3 (5:45)

Part 5 - Additional VLOOKUP settings (4:40)

Part 6 - Final Project (6:32)

×