Introduction to Microsoft Excel

Introduction to Microsoft Excel

Find out what’s new at Ampere, and within our extensive partner network, as we work with rural, remote and Indigenous communities to ensure that everyone has the power to embrace the power that STEAM creates.

microsoft icons

In this course, the basics of Microsoft Excel will be introduced to provide learners with the foundational skills required to begin using Microsoft Excel.

Course Content

Lesson 1: Overview of Microsoft (MS) Excel; Mouse and Keyboard Basics
3 Tasks
Section 1: Understanding MS Excel
Section 2: Mouse Basics
Section 3: Keyboard Basics
Lesson 2: Parts of an Excel Workbook
10 Tasks
Section 1: Overview of all Parts of a Workbook
Section 2: Working with the Ribbon
Section 3: Using the Quick Access Toolbar
Section 4: Name Box and Formula Bar
Section 5: The File Tab
Section 6: The Title Bar
Section 7: Column and Row Headings
Section 8: Sheet Tabs
Section 9: The Status Bar
Section 10: Cell Address
Lesson 3: Entering and Editing Labels/Text, Values and Formulas
5 Tasks
Section 1: Understanding Labels/Text, Values and Formulas
Section 2: Entering Data
Section 3: Editing Cell Contents
Section 4: Selecting Cells
Section 5: Erasing Cell Contents and Clearing Formatting
Lesson 4: Saving, Closing and Opening a Workbook
4 Tasks
Section 1: Saving your Workbook and File Management
Section 2: Closing a Workbook
Section 3: Opening an Existing File
Section 4: Closing Excel
Lesson 5: Basic Formulas
3 Tasks
Section 1: Creating Basic Formulas
Section 2: Using AutoSum =Sum Functions and other Functions
Section 3: Importance of Cell Addresses
Lesson 6: Cut, Copy and Paste
1 Task
Section 1: Using Cut, Copy and Paste Commands
Lesson 7: Basic Formatting
5 Tasks
Section 1: Formatting with the Font Group
Section 2: Formatting with the Alignment Group
Section 3: Basic Number Formatting
Section 4: Format Cells Dialog Box
Section 5: Undo and Redo
Lesson 8: Page Layout
3 Tasks
Section 1: Themes Group
Section 2: Page Setup Group
Section 3: Page Setup Dialog Box
Lesson 9: Printing
1 Task
Section 1: Using the File, Print Feature
Lesson 10: Help Tab
1 Task
Section 1: Using the Help Tab
Lesson 11: Working with Columns and Rows
2 Tasks
Section 1: Inserting/Deleting Columns/Rows
Section 2: Column Width/Row Height
Lesson 12: Spelling
1 Task
Section 1: Using the Spell Checker
Lesson 13: Worksheets
1 Task
Section 1: Working with Multiple Worksheets
Scroll to Top