Weekly Excel Course Checklist

Week 1 ▶

What to expect

Review Excel features:

Cell Formatting

Basic Cell/worksheet shifting (insert/delete)

Basic fill-series + wizard

Basic sorting / filtering

Basic functions: SUM, AVERAGE, ...

Function "wizard"

Basic Themes, Page Setup, Grid

Week 2 ▶

Reference types:

Absolute references

Relative references

Mixed references

Using Inter-sheet referencing

Named items:

Named cells

Named ranges

Importing / Exporting data (Excel, CSV, ODS, Access)

Week 3 ▶

More Importing / Exporting data (Excel, CSV, ODS, Access)

Conditional Formatting

Protecting worksheets:

Protecting cells

Protecting (hiding) formulas

Setting Options (default sheets, file format, auto-save, recalculate, etc.)

Customizing the Ribbon Bar and Quick Access Toolbar

Week 4 ▶

Conditional Formatting review

Working with Templates

Cell comments

The IF function

Some advanced functions:

The OR and AND functions

ISERR / ISERROR / IFERROR

RAND / RANDBETWEEN

Week 5 ▶

Text functions:

LEFT, RIGHT, MID

LEN, FIND / SEARCH

TRIM, UPPER, LOWER, PROPER

CONCAT, CONCATENATE, &

SUBSTITUTE, REPLACE

Lookup functions

VLOOKUP ( / XLOOKUP)

MATCH

INDEX

ISNA, IFNA

Week 6 ▶

Pivot Tables

More functions:

Date functions: NOW, TODAY, DATE, MONTH, DAY, YEAR, HOUR, MINUTE, SECOND

ISNUMBER

INDIRECT

Using tables

More VLOOKUP, plus MATCH, INDEX, ISNA, IFNA

Data validation

Integers

Decimals

Lists

Text length

Multiple panes:

Freeze Panes

Sheet splitting

Week 7 ▶

More Pivot Tables

Using charts

Macros + the Developer tab

Week 8 ▶

Info on Add-ins

More macros:

Saving and loading

Relative referencing

Creating Excel-enabled functions

Week 9 ▶

Excel form controls

Using spin controls to help with VLOOKUP

Visual Basic form controls

Recreating the Fill-Series Wizard

Excel (Advanced) Course

Checklist of Topics By Week (approximate)