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 micro-credential

  • 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 5-hr micro-credential, learners will learn how to work with intermediate Excel, such as working with formulas and functions, as well as formatting options including tools and using charts. 

Review the curriculum below to see the topics covered.  

Learners who successfully complete the micro-credential 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 micro-credential for 90 days to work through the content.

Curriculum

    1. Before we begin...

    2. Welcome and Micro-credential Information

    3. Navigation

    4. Learning Outcomes

    5. Modes of Learning

    1. Lesson 1 Introduction

    2. Working with Formulas and Functions

    3. Entering a Formula

    4. Video- Entering a Formula

    5. Calculating in Excel

      FREE PREVIEW

    6. Formulas

    7. Entering Complex Formulas (Part 1)

    8. Brackets

    9. Learning Activity

    10. Entering Complex Formulas (Part 2)

    11. Practice

    12. Functions

    13. Parts of a Function

    14. Understanding Arguments

    15. Function Tips

    16. Common Functions

      FREE PREVIEW

    17. Learning Activity

    18. Lesson Summary

    19. Discussion: Using Formulas and Functions

    20. Lesson 1 Quiz

    1. Lesson 2 Introduction

    2. Ways to Enter Functions

    3. Using the AutoSum Command to Quickly Access Commonly Used Functions

    4. Video- Functions

    5. Manually Entering Functions

    6. Functions Library

    7. Learning Activity

    8. Video- Manually Entering a Function

    9. Inserting a Function from the Function Library

    10. The Insert Command

    11. Practice

    12. Relative and Absolute Cell References

    13. Using Absolute References

    14. Learning Activity

    15. Tips

    16. Video- Cell References

    17. Using the Show Formulas Feature

    18. Practice

    19. Working with Formulas and Functions- Final Review Exercise

    20. Lesson 2: Summary

    21. Lesson 2 Quiz

    1. Lesson 3 Introduction

    2. Formatting Cells

    3. Number Formats

    4. Applying Number Formats

    5. Accounting Format

    6. Video- Applying the Accounting Format

    7. Learning Activity

    8. Percentage Formats

    9. Using Percentage Formats

    10. Increase Decimal and Decrease Decimal Commands

    11. Video- Decimal Options

    12. Practice

    13. Date Formats

    14. Video- Excel: Understanding Number Formats

    15. Practice

    16. Lesson 3: Summary

    17. Discussion: Formatting Options

    18. Lesson 3 Quiz

    1. Lesson 4 Introduction

    2. Working with Other Formatting Tools

    3. Changing Font Size

    4. Changing Font

    5. Changing Font Colour

    6. Using Bold, Italics, and Underline

    7. Video- Font Style

    8. Learning Activity

    9. Practice

    10. Cell Borders and Fill Colour

    11. Cell Styles

    12. Adding Cell Borders

    13. Text Alignment

    14. Vertical Cell Alignment

    15. Horizontal Cell Alignment

    16. Merging Cells

    17. Video- Merge Cell Feature

    18. Learning Activity

    19. Format Painter

    20. Format Painter Options

    21. Video- Format Painter

    22. Formatting Worksheet Options- Final Review Exercise

    23. Lesson 4: Summary

    24. Lesson 4 Quiz

    1. Lesson 5 Introduction

    2. Understanding Charts

    3. Types of Charts

    4. Parts of a Chart

    5. Insert a Chart

    6. Video- Inserting a Chart

    7. Learning Activity

    8. Recommended Charts

    9. Chart and Layout Style

    10. Edit Chart Title

    11. Quick Layout

    12. Chart Styles

    13. Chart Format Shortcut Buttons

    14. Switching Rows and Columns

    15. Change Chart Type

    16. Video- Changing the Chart Type

    17. Learning Activity

    18. Move a Chart

    19. Video- Moving a Chart

    20. Keeping Charts up to Date

    21. Video- Keeping Charts Updated

    22. Video- Excel: Charts

    23. Using Charts- Final Review Exercise

    24. Lesson 5: Summary

    25. Discussion: Charts

    26. Lesson 5 Quiz

About this course

  • $149.99
  • 117 lessons
  • 0 hours of video content

Reviews

5 star rating

Best course ever seen.

Rajkaran Singh

The way of teaching is perfect

The way of teaching is perfect

Read Less
5 star rating

Review

waylon richards

Very interesting learn soooo much

Very interesting learn soooo much

Read Less

Feedback & Testimonials

Formats and Functions

Janet Baynton

I liked the formats and functions as well as chart information.

Easy to Understand

Teresa Evers

I liked the examples and easy to understand the information.

Confidence

Amy Dawson

It helped me to feel confident that I can use the functions more efficiently.

Trying the Activities

Lianne Crowe

I liked trying the activities on downloaded spreadsheets.