Online Class: Excel 2019

no certificate
with CEU Certificate*
-
15Lessons
-
27Exams &
Assignments -
10,266Students
have taken this course -
12Hours
average time -
1.2CEUs
Course Description
Excel 2019 is the latest iteration of the popular spreadsheet software developed by Microsoft. Excel allows users to create rich, stylized spreadsheets used for storing, organizing, sorting, calculating, and charting data. With Excel, you can create visually appealing content that represents your data. 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.
- Create spreadsheets
- Format cells, rows, columns, and entire worksheets so they fit and match your data
- Enter data into a spreadsheet
- Use formulas and functions for math, accounting, and totaling
- Create formulas and functions
- Calculate data
- Create charts and diagrams for your data
- Create data lists and forms
- Create and use pivot tables and pivot charts
- Work with Excel templates
- Share and protect your worksheets and workbooks
- Use What-If Analysis to determine possible outcomes
- And much more!
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 2019
Lesson 1 Video
Review 2 Articles: What's new in Excel 2019 for Windows; Excel Easy: #1 Excel tutorial on the net
Take Survey: Reasons for Taking this Course
Complete Assignment: My Excel Experience
Complete: Lesson 1 Quiz
Lesson 2 - Worksheets, Workbooks and Entering Data in Excel 2019
Lesson 2 Video A
Lesson 2 Video B : Entering Data
Review 2 Articles: Create a new workbook; Quick Guide To The Excel 2019 Worksheet Window
Review Video: Microsoft Excel 2019: Multiple Worksheet and Workbook Views
Complete: Lesson 2 Quiz
Lesson 3 - Formatting Cells and Data
Lesson 3 Video
Review 2 Articles: Excel 2019 Formatting: Numbers And Labels; Conditional Formatting In Excel 2019
Review Video: Microsoft Excel 2019: Create and Manage Cell Styles
Complete: Lesson 3 Activity Assignment
Complete: Lesson 3 Quiz
Lesson 4 - Editing Worksheets and Cells
Lesson 4 Video
Review 2 Articles: Edit cell contents; Lock cells to protect them
Review 2 Videos: Microsoft Excel 2019: Editing Columns, Rows and Cells; Excel 2019 How to add edit or delete comments
Complete: Lesson 4 Activity Assignment
Complete: Lesson 4 Quiz
Lesson 5 - Formulas and Calculations
Lesson 5 Video A
Lesson 5 Video B : Formulas and Calculations
Review 2 Videos: Microsoft Excel 2019: How to Enter Basic Formulas; Microsoft Excel 2019: Introduction to Functions Beginning with SUM and AVERAGE
Complete: Lesson 5 Activity Assignment
Complete: Lesson 5 Quiz
Lesson 6 - Creating a What-If Analysis
Lesson 6 Video
Review 3 Articles: Introduction to What-If Analysis; Excel Scenarios Create and Show; Creating Scenarios
Complete: Lesson 6 Activity Assignment
Complete: Lesson 6 Quiz
Lesson 7 - Adding Images and Graphics
Lesson 7 Video A
Lesson 7 Video B : Working with Graphics
Review Article: How To Insert Online Images Into Your Excel 2019 Sheet
Review Video: Excel 2019 Cut Copy and Paste
Complete: Lesson 7 Activity Assignment
Complete: Lesson 7 Quiz
Lesson 8 - Charts and Diagrams
Lesson 8 Video A
Lesson 8 Video B : Working with Charts and Diagrams
Review Article: Create a chart with recommended charts
Review Video: Excel 2019 Tutorial Basic Chart Creation
Complete: Lesson 8 Activity Assignment
Complete: Lesson 8 Quiz
Lesson 9 - Creating Data Lists and Managing Data
Lesson 9 Video A
Lesson 9 Video B : Managing Data
Review Article: Create and format tables
Review 2 Videos: How to Create Drop Down Lists in Cells - The Complete Excel Guide; Data Validation in Excel - should you include these in your files?
Complete: Lesson 9 Activity Assignment
Complete: Lesson 9 Quiz
Lesson 10 - Pivot Tables and Charts
Lesson 10 Video
Review 2 Articles: Create a PivotTable to analyze worksheet data; Creating Pivot Charts In Excel 2019
Complete: Lesson 10 Activity Assignment
Complete: Lesson 10 Quiz
Lesson 11 - Templates and Macros
Lesson 11 Video
Review 4 Articles: Free Excel Templates; 50 Free Excel Templates to Make Your Life Easier; Run a macro; Macros Training Video
Complete: Lesson 11 Activity Assignment
Complete: Lesson 11 Quiz
Lesson 12 - Retrieving External Data
Lesson 12 Video
Review Article: Export data to Excel
Review 2 Videos: Importing DOM Data to Excel in Real Time; How to export an Excel 2019 workbook to PDF
Complete: Lesson 12 Quiz
Lesson 13 - Sorting and Filtering
Lesson 13 Video
Review 2 Articles: Filtering And Sorting Pivot Table Data In Excel 2019; Sort data in a table Video Training
Review Video: Microsoft Excel 2019: Conditional Formatting
Complete: Lesson 13 Activity Assignment
Complete: Lesson 13 Quiz
Lesson 14 - Common Useful Functions
Lesson 14 Video
Review 2 Articles: Using IF with AND, OR and NOT functions; IF function ? nested formulas and avoiding pitfalls
Complete: Lesson 14 Quiz
Lesson 15 - Introduction to VBA
Lesson 15 Video
Take Poll: End of Course Poll
Take Survey: Course Comments
Take Survey: Program Evaluation Follow-up Survey (End of Course)
Complete: Lesson 15 Quiz
Complete: The Final Exam
Learning Outcomes
- Describe what a spreadsheet is and what Excel's capabilities are.
- Demonstrate working with worksheets, workbooks and entering data in Excel.
- Demonstrate formatting cells and data.
- Demonstrate using formulas and calculations in Excel.
- Demonstrate creating and using What-If Analysis tool.
- Demonstrate adding images and graphics.
- Demonstrate creating charts and diagrams.
- Demonstrate creating data lists and managing data.
- Demonstrate creating and using Pivot Tables and Charts.
- Describe techniques for sorting and filtering data, and
- Demonstrate mastery of lesson content at levels of 70% or higher.
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 500+ courses
Includes certificate |
![]() |
Includes CEUs |
![]() |
Self-paced |
![]() |
Instructor support |
![]() |
Time to complete | 12 Months |
No. of courses | 500+ |
Certificates & CEUs
Includes all 500+ courses
Includes certificate |
![]() |
Includes CEUs |
![]() |
Self-paced |
![]() |
Instructor support |
![]() |
Time to complete | Monthly |
No. of courses | 500+ |