Spreadsheets Course

This Spreadsheet course covers the essential topics relating to using a spreadsheet application for everyday use. It's suitable for complete beginners. 

By the end of this course you will be able to work with spreadsheets and save them in different file formats. Use the Help facility. Enter data into cells and use good practice in creating lists. Select, copy, sort and move and delete data. Copy, move, delete and rename worksheets. Create mathematical and logical formulas. Format numbers. Choose create and format charts. Lastly you will learn how to adjust page settings before committing to printing. 

Includes updates as of September 2021 affecting 14 lessons.

Estimated Course duration is 2 - 3 hours. Each lesson take on average 3-5 minutes to complete.

Course Content

Using the Application

MS Excel Environment
Backstage View
Creating New Workbooks - UPDATED
Navigating within Workbooks - NEW
Opening and Closing Workbooks
Saving and Updating - UPDATED
Saving Workbooks as Templates
File Formats - UPDATED
Switching between Workbooks
Available Help Functions - UPDATED


Entering Text and Values - UPDATED
Selecting Ranges
Using Undo/Redo
Searching and Replacing Content
Copying and Moving Contents - UPDATED
Sorting Cell Ranges

Managing Worksheets

Inserting Columns and Rows
Deleting Columns and Rows
Modifying Worksheets - UPDATED
Modifying Worksheets
Freezing Panes

Formulas and Functions

Order of Calculation
Creating Formulas - UPDATED
Relative and Absolute Cell Referencing
Sum Function
Average Function
Min and Max Functions
Count Function
Round Function
IF Function


Formatting Numbers
Formatting Font Size and Type
Cell Contents Formatting - UPDATED
Format Painter
Text Wrapping - UPDATED
Aligning Cell Contents
Cell Content Orientation - UPDATED
Merging Cells - UPDATED


Creating Column Charts
Creating Bar Charts
Creating Line Charts
Creating Pie Charts
Editing Charts - UPDATED
Formatting Charts

Prepare Outputs

Page Setup
Headers and Footers
Print Set-Up
Previewing and Printing
Printing Workbooks
Printing Selected Ranges