Course Outline

Spreadsheets


This outline covers the essential concepts and skill relating to understanding the concept of spreadsheets and demonstrating an ability to use a spreadsheet to produce accurate work outputs.

The course is split up into 5-10 minute lessons so you can follow the outline in sequence or jump to the topic you want to learn about. Typically, a course outline will contain on average 35 lessons. Remember to practice your new found skills. This will help to reinforce the learning and retain your skills.
Using the Application
Lesson not Started  MS Excel Environment
Lesson not Started  Backstage View
Lesson not Started  Opening and Closing Workbooks
Lesson not Started  Create New Spreadsheets
Lesson not Started  Saving and Updating Workbooks
Lesson not Started  Saving as Templates
Lesson not Started  File Formats
Lesson not Started  Switching Between Workbooks
Lesson not Started  Available Help Function

Cells
Lesson not Started  Entering Text and Values
Lesson not Started  Selecting Ranges
Lesson not Started  Using Undo and Redo
Lesson not Started  Searching and Replacing Content
Lesson not Started  Sorting a Cell Range
Lesson not Started  Copy and Move Cell Contents

Managing Worksheets
Lesson not Started  Inserting Rows and Columns
Lesson not Started  Deleting Rows and Columns
Lesson not Started  Modifying Columns and Rows
Lesson not Started  Freezing and Unfreezing
Lesson not Started  Copying,Moving and Renaming Worksheets

Formulas and Functions
Lesson not Started  Order of Calculation
Lesson not Started  Creating Formulas
Lesson not Started  Relative and Absolute Cell Referencing
Lesson not Started  Autosum
Lesson not Started  SUM Function
Lesson not Started  AVERAGE Function
Lesson not Started  MIN and MAX Function
Lesson not Started  Count Function
Lesson not Started  IF Function

Formatting
Lesson not Started  Formatting Numbers
Lesson not Started  Formatting Font Size and Type
Lesson not Started  Cell Contents Formatting
Lesson not Started  Format Painter
Lesson not Started  Text Wrapping
Lesson not Started  Aligning Cell Contents
Lesson not Started  Cell Content Orientation
Lesson not Started  Merge Cells

Charts
Lesson not Started  Creating a Column Chart
Lesson not Started  Creating a Bar Chart
Lesson not Started  Creating a Line Chart
Lesson not Started  Creating a Pie Chart
Lesson not Started  Editing Charts
Lesson not Started  Formatting Charts

Preparing Outputs
Lesson not Started  Page Setup
Lesson not Started  Headers and Footers
Lesson not Started  Print Set Up
Lesson not Started  Previewing and Printing
Lesson not Started  Print Selected Ranges
Lesson not Started  Printing Workbooks