Spreadsheets Course (new August 2022)

This updated 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. Enhance your productivity and 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 and dates. Create, edit and format Value and Category comparison charts and work with Time Related charts too. Lastly you will learn how to adjust page settings before committing to printing. 

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



Course Content

Working with Spreadsheets

Opening and Closing Workbooks
Creating and Saving Workbooks
File Formats
Switching between open Workbooks

Enhance Productivity

Backstage View
Getting Help
Excel Environment
The Ribbon
Mini Toolbar
Quick Access Toolbar
Navigating Worksheets

Insert and Select

Entering Data
Selecting Data

Edit and Sort

Editing Cells
Using Undo & Redo
Find and Select
Sorting by Value

Copy, Move and Delete

Moving and Copying Data
Moving and Copying Formulas
Creating Custom Lists
Clearing vs Deleting Data

Rows and Columns

Inserting Columns and Rows
Deleting Columns and Rows
Managing Columns and Rows

Worksheets

Inserting and Deleting Worksheets
Managing Worksheets
Moving and Copying Worksheets

Arithmetic Formulas

Understanding Formulas
Order of Calculation
Entering and Editing Formulas
Relative and Absolute Cell References
Formula Errors

Functions

SUM Function
MIN and MAX Functions
AVERAGE Function
COUNT Function
ROUND Function
IF Function

Numbers and Dates

Formatting Numbers and Dates

Contents

Text Formatting
Cell Styles
Format Painter

Alignment and Border Effects

Text Wrapping
Text Alignment
Text Orientation
Merge and Centre
Cell Borders

Create Charts

Chart Basics
Value Comparison Charts (Column, Bar)
Category Comparison Charts (Pie, Doughnut)
Time Related Charts (Line, Area)

Edit Charts

Advanced Chart Editing
Formatting Charts
Advanced Chart Formatting

Setup

Page Setup Options
Headers and Footers

Check and Print

Spell Check
Advanced Printing Settings
Print Preview
Printing Worksheets