Excel Level 1

Module 1: Getting Started

Opening Microsoft Excel

Interacting with Excel

Columns, rows, cells and ranges

The ribbon/toolbar

The quick access toolbar

The file menu

Module 2: Entering and Editing Data

Entering and editing data

Autofill and autocomplete

Using formulas in Excel

Module 3: Formatting Worksheets

The home ribbon

Changing the size of rows or columns

Module 4: Using Functions

What are functions?

Using autosum

Module 5: Modifying a Worksheet

Moving and copying data

Inserting and deleting ranges

Module 6: Printing Workbooks

Working with print preview

Using page setup

Printing options

Bonus modules if time allows -

Module 7: Absolute vs Relative Cell Referencing

Moving and copying formulas

Relative cell references

Absolute cell references

Module 8: Working with Charts

Creating a chart

Manipulating a chart

Formatting a chart

Quick reference: Excel Shortcuts

Ctrl combination shortcut keys

Function keys

Other useful shortcut keys