Online Class: Excel 2021

no certificate
with CEU Certificate*
-
14Lessons
-
26Exams &
Assignments -
5,968Students
have taken this course -
11Hours
average time -
1.1CEUs
Course Description
This online Excel course covers everything you need to know about using Microsoft's famous spreadsheet software. Excel 2021 (also know as Excel for Microsoft 365 in their subscription-based model) is the most recent version of Excel and it allows users to create rich, stylized, and even interactive spreadsheets used for storing, organizing, sorting, calculating, and charting data. With Excel, you can create visually stunning content that represents your data. It has the power to turn your numbers into a visual storybook! But before you start using Excel though, you should first learn what all the features Excel offers are and how to use them, so that your spreadsheets are built correctly the first time.
Nowadays, your Excel spreadsheet should include at least one chart, so we have step-by-step tutorials on charting, graphics, and using images. All these added components help make spreadsheets more visually appealing. We also review ways to use common functions as well as sort and filter data, so you can view large data sets in chronological, alphabetical or numerical order.
- Completely Online
- Self-Paced
- Printable Lessons
- Full HD Video
- 6 Months to Complete
- 24/7 Availability
- Start Anytime
- PC & Mac Compatible
- Android & iOS Friendly
- Accredited CEUs

Course Lessons
Lesson 1: Introduction to Microsoft Excel 2021
Lesson 1 Video
Lesson discussions: Your Excel Course Goals
Complete Assignment: Your Spreadsheet and Computer Experience
Assessment: Lesson 1: Exam
Lesson 2: Understanding Workbooks, Worksheets, and How to Enter Data
Lesson 2 Video A
Lesson 2 Video B : Entering Data
Assessment: Lesson 2: Exam
Lesson 3: How to Format Cells and Enter Data
Lesson 3 Video
Complete: Lesson 3 Activity: Test Your Excel Skills
Assessment: Lesson 3: Exam
Lesson 4: Advance Editing of Excel Worksheets and Cells
Lesson 4 Video
Complete: Lesson 4 Activity: Test Your Excel Skills
Assessment: Lesson 4: Exam
Lesson 5: Formulas, Functions, and Calculations
Lesson 5 Video A
Lesson 5 Video B : Formulas and Calculations
Complete: Lesson 5 Activity: Test Your Excel Skills
Assessment: Lesson 5: Exam
Lesson 6: How to Add Pictures, Illustrations and Graphics to Your Excel Spreadsheet
Lesson 6 Video A
Lesson 6 Video B : Working with Graphics
Complete: Lesson 6 Activity: Test Your Excel Skills
Assessment: Lesson 6: Exam
Lesson 7: How to Create Effective Charts and Diagrams in Excel
Lesson 7 Video A
Lesson 7 Video B : Working with Charts and Diagrams
Complete: Lesson 7 Activity: Test Your Excel Skills
Assessment: Lesson 7: Exam
Lesson 8: What is the What-If Analysis and How to Use it
Lesson 8 Video
Complete: Lesson 8 Activity: Test Your Excel Skills
Assessment: Lesson 8: Exam
Lesson 9: How to Create and use Data Lists and Data Forms
Lesson 9 Video A
Lesson 9 Video B : Managing Data
Complete: Lesson 9 Activity: Test Your Excel Skills
Assessment: Lesson 9: Exam
Lesson 10: How to Create PivotTables and Charts
Lesson 10 Video
Complete: Lesson 10 Activity: Test Your Excel Skills
Assessment: Lesson 10: Exam
Lesson 11: Creating, Recording and Running Macros
Lesson 11 Video
Complete: Lesson 11 Activity: Test Your Excel Skills
Assessment: Lesson 11: Exam
Lesson 12 - How to Use Data from Other (Non-Excel) Sources
Lesson 12 Video
Assessment: Lesson 12: Exam
Lesson 13: Filtering, Sorting, and Conditional Formatting Your Data
Lesson 13 Video
Complete: Lesson 13 Activity: Test Your Excel Skills
Assessment: Lesson 13: Exam
Lesson 14: Using Conditional Functions, IF Statements, Date/Time Functions, and Text Functions
Lesson 14 Video
Lesson discussions: End of Course Poll
Assessment: Lesson 14: Exam
Assessment: The Final Exam
Additional Course Information

- Document Your Lifelong Learning Achievements
- Earn an Official Certificate Documenting Course Hours and CEUs
- Verify Your Certificate with a Unique Serial Number Online
- View and Share Your Certificate Online or Download/Print as PDF
- Display Your Certificate on Your Resume and Promote Your Achievements Using Social Media

Choose Your Subscription Plan
No Certificate / No CEUs
This course only
Includes certificate | X |
Includes CEUs | X |
Self-paced |
![]() |
Instructor support |
![]() |
Time to complete | 6 months |
No. of courses | 1 course |
Certificate & CEUs
This course only
Includes certificate |
![]() |
Includes CEUs |
![]() |
Self-paced |
![]() |
Instructor support |
![]() |
Time to complete | 6 months |
No. of courses | 1 course |

Certificates & CEUs
Includes all 600+ courses
Includes certificate |
![]() |
Includes CEUs |
![]() |
Self-paced |
![]() |
Instructor support |
![]() |
Time to complete | 12 Months |
No. of courses | 600+ |
Certificates & CEUs
Includes all 600+ courses
Includes certificate |
![]() |
Includes CEUs |
![]() |
Self-paced |
![]() |
Instructor support |
![]() |
Time to complete | Monthly |
No. of courses | 600+ |
Student Testimonials
- "Thank you for the course. It was well put together and helpful." -- Robert M.
Related Courses
-
45 hours 4.5 CEUs Ultimate Excel Training Bundle $125.00
-
8 hours 0.8 CEUs Microsoft Access 2019 $95.00
-
6 hours 0.6 CEUs Microsoft Publisher 2021 $95.00
-
8 hours 0.8 CEUs Learn HTML - Create Webpages Using HTML5 $95.00
-
17 hours 1.7 CEUs Introduction to SQL $95.00
-
7 hours 0.7 CEUs Google Slides $95.00
-
5 hours 0.5 CEUs Windows 10 $95.00
-
6 hours 0.6 CEUs Computer Literacy Level 3 - Living and Working Online $95.00
-
14 hours 1.4 CEUs QuickBooks Online $95.00
-
4 hours 0.4 CEUs Slack $95.00
-
8 hours 0.8 CEUs MySQL $95.00
-
6 hours 0.6 CEUs Microsoft Visio 2021 $95.00
-
6 hours 0.6 CEUs Google Docs $95.00
-
7 hours 0.7 CEUs Computer Literacy Level 1 - Computer Basics $95.00
-
16 hours 1.6 CEUs Advanced Excel 2019 $95.00
-
8 hours 0.8 CEUs Quicken Tutorial: All Versions $95.00
-
6 hours 0.6 CEUs Cybersecurity 101 $95.00
-
7 hours 0.7 CEUs Google Sheets $95.00
-
5 hours 0.5 CEUs SalesForce 101 $95.00
-
5 hours 0.5 CEUs Outlook 2021 $95.00
-
6 hours 0.6 CEUs Computer Literacy Level 2 - Internet Basics $95.00
-
9 hours 0.9 CEUs Microsoft Project 2021 $95.00