Highlights

Here are some of the highlights for this micro-credential..

  • No admission requirements, no application process, no pre-requisites, open to anyone

  • Learn at your own pace using a computer, tablet or smartphone

  • Take up to 90 days to complete the course

  • Receive a certificate of course completion and digital badge for successfully completing the course which can be shared on social media (e.g. LinkedIn, Facebook, Twitter), downloaded as a PDF, or even embedded in an email signature

Micro-credential Overview

In this introductory-level 5-hour online micro-credential, learners will navigate the Excel interface and become familiar with the basic features of this application to help you develop professional and functional spreadsheets.

Review the curriculum below to see the topics covered.  

Learners who successfully complete the course will earn a digital badge and certificate of course completion that can be downloaded and shared via social media. 

You will have access to the course for 90 days to work through the content.

Curriculum

    1. Before we begin...

    2. Welcome and Course Information

    3. Introduction

    4. Course Navigation

    5. Learning Objectives

    1. Lesson 1: Learning Objectives

    2. Interface Overview

    3. Opening a New Workbook

    4. MS Excel Interface

      FREE PREVIEW

    5. Learning Activity

      FREE PREVIEW

    6. Video- Getting Started with Excel

      FREE PREVIEW

    7. Showing and Hiding the Ribbon

    8. Display Options for Ribbon (Part 1)

    9. Display Options for Ribbon (Part 2)

    10. Display Options for Ribbon (Part 3)

    11. Learning Activity

      FREE PREVIEW

    12. Display Modes

    13. Normal View

    14. Page Layout View

    15. Page Break Preview

    16. Learning Activity

      FREE PREVIEW

    17. Things to Note About Views

    18. Zoom Control

    19. Video- The Excel Status Bar

    20. Quick Access Toolbar

    21. Tell Me and Help Features

    22. Using Tell Me Feature

    23. Learning Activity

    24. Understanding the Workbook and Worksheet Structure

    25. Video- Structure of a Spreadsheet

    26. Learning Activity

    27. Lesson Summary

    28. Lesson 1 Quiz

    1. Lesson 2: Learning Objectives

    2. Creating and Editing Excel Worksheets

    3. Learning Activity

      FREE PREVIEW

    4. Understanding and Using Cell References (Part 1)

    5. Understanding and Using Cell References (Part 2)

    6. Learning Activity

    7. Selecting a Cell

    8. Selecting a Cell Range

    9. Jumping to a Cell

    10. Cell Content

    11. Inserting and Deleting Content

    12. Clearing Content

    13. Video- Excel: Cell Basics

    14. Deleting Cells

    15. Deleting Rows and Columns

    16. Learning Activity

    17. Copy and Paste Cell Content

    18. Cut and Paste Cell Content

    19. Video- Cut, Copy, and Paste

    20. Learning Activity

    21. Lesson Summary

    22. Lesson 2 Quiz

    1. Lesson 3: Learning Objectives

    2. Resizing Columns

    3. Practice

    4. Removing ### From a Cell

    5. Learning Activity

    6. Auto Fill Feature

    7. Auto Fill Feature to Copy Cells

    8. Auto Fill Feature to Continue a Series

    9. MS Excel AutoFill Feature

    10. Practice

    11. Mouse Pointer Shapes

    12. Additional Information on Mouse Pointer Shapes

    13. Saving a Workbook

    14. How to Save a Workbook

    15. Save As Feature

    16. Saving your Excel Workbook

    17. Save and Save As

    18. Closing your Excel Workbook

    19. Backstage View

    20. Lesson Summary

    21. Lesson 3 Quiz

    1. Lesson 4: Learning Objectives

    2. Creating and Editing Excel Workbook Overview

    3. Spelling Check

    4. Using the Spelling Checker

    5. How to do Spell Check In Excel

    6. Ignoring Spelling Errors

    7. Working with Worksheets

    8. Name a Worksheet

    9. Inserting New Worksheets

    10. Deleting Worksheets

    11. Learning Activity

    12. Copying a Worksheet

    13. Moving a Worksheet

    14. Move Worksheet Tab

    15. Worksheet Tab Colours

    16. Switching Between Worksheets

    17. Switching Between Worksheets

    18. Working with Multiple Worksheets

    19. Lesson Summary

    20. Lesson 4 Quiz

    1. Lesson 5: Learning Objectives

    2. Printing a Worksheet

    3. To Print a Worksheet

    4. Learning Activity

    5. Preview your Worksheet Before you Print

    6. Print Active Sheets Option

    7. Print Active Worksheet

    8. Print Entire Workbook

    9. Print Selected Cells

    10. Adjusting Print Pane

    11. Print Orientation

    12. Changing Print Orientation

    13. Learning Activity

    14. Fit Content Using Scaling

    15. Printing in Excel

    16. Lesson Summary

    17. Lesson 5 Quiz

About this course

  • $129.99

Reviews

Feedback & Testimonials

Very Informative

Ashlie Thompson

The course was very informative and I could move at my own pace.

Easy to Understand

Teresa Evers

It was easy to understand and has a lot of useful information.

Multiple Sheets

Janet Baynton

I learned how to change information in multiple sheets at one time.

Practice Steps

Amy Dawson

The course was well explained with videos to ensure proper procedures and allowed to practice steps.

Hands-On

Lianne Crowe

It was hands-on and informative. The slides helped to explain what to do.