Excel from Zero

1. 01

   The Grid

   Cells, rows, columns, the Name Box, moving around, entering and clearing data

   6 lessons
2. 02

   Editing and Selection

   Fill handle, copy, cut and paste, undo and redo, Ctrl+arrow, Shift+arrow, Ctrl+A

   7 lessons
3. 03

   First Formulas

   The equals sign, arithmetic, order of operations, cell references, relative vs absolute $

   7 lessons
4. 04

   Core Functions

   SUM, AVERAGE, MIN, MAX, COUNT, COUNTA, AutoSum

   6 lessons
5. 05

   Formatting Basics

   Number, currency, percent and date formats, decimals, bold, fill, borders, column width, wrap, merge

   7 lessons
6. 06

   Sort, Filter, Freeze

   Single and multi-key sort, AutoFilter, freeze panes, find and replace

   5 lessons

Every module is published.