Online Class: Excel 2019

no certificate
- OR -
with CEU Certificate*
Start Right Now!
Taking multiple courses? Save with our platinum program.
  • 15
  • 27
    Exams &
  • 10,266
    have taken this course
  • 12
    average time
  • 1.2

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.

In this course, you're going to learn how to...
  • 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!
The first few lessons explain how to use Excel core features such as formatting rules and techniques. We then move on to formulas. Formulas are the foundation for most basic and complex spreadsheets that store data. Formulas allow you to automatically calculate results based on any number of variables including information stored in your rows, columns and cells. Once we learn how to use formulas, we'll move on to scenarios, pivot tables and what-if charts. These advanced tools allow you to track your reports and create projections for your business.

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.

The final lesson introduces you to Visual Basic for Applications (VBA).  VBA is a powerful language used to make macros. We will show you how to create simple recorded macros as well as how to edit macros for more complex applications. 
With clear and concise step-by-step directions, beautifully illustrated lessons with screenshots, and HD Video tutorials, this Excel 2019 online course will teach you everything you need to know to become an Excel power user.
Note: You do not need access to Excel software in order to successfully complete this course, although it is strongly recommended in order to follow along with the course examples. 
  • 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
  • Universal Class is an IACET Accredited Provider

    Course Lessons

    Average Lesson Rating:
    4.5 / 5 Stars (Average Rating)
    "Extraordinarily Helpful"
    (6,498 votes)

    Lesson 1 - Introduction to Microsoft Excel 2019

    This first lesson will provide an introduction to this program and review the course structure. 10 Total Points
    • 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

    In this lesson we will begin the process of working with worksheets and workbooks as well as entering and editing data. 9 Total Points
    • 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

    This lesson will explore and provide detailed examples of the process of Formatting Cell Data. 11 Total Points
    • 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

    This lesson will demonstrate how to alter and adjust data in cells. 11 Total Points
    • 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

    This lesson provides comprehensive instruction on using Excel formulas, functions, and performing calculations. 11 Total Points
    • 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

    This lesson will show you how to use a What-If Analysis 11 Total Points
    • 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

    This lesson will demonstrate how to add images and other graphics to your excel project. 11 Total Points
    • 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

    How to make use of charts and diagrams will be examined in this lesson. 11 Total Points
    • 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

    This lesson will demonstrate the process of creating data lists 11 Total Points
    • 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

    This lesson will review Pivot Tables and Carts used in this version of Excel. 11 Total Points
    • 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

    This lesson covers some of the useful templates and the application of Macros available in Microsoft Excel 2019. 11 Total Points
    • 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

    This lesson covers some ways that you can transfer data from Microsoft Access and import it to Excel. We also show how to connect to an Access database directly to query data from Excel. 9 Total Points
    • 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

    In this lesson, you'll learn how to sort Excel table data based on a condition and format cells based on conditional statements to make them stand out among other cells. 11 Total Points
    • 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

    This lesson covers some of the other useful functions that you might need should you create your own spreadsheets or work with financial and statistical spreadsheets. 10 Total Points
    • 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

    VBA can get complicated, but knowing how to create basic code and functionality can improve your spreadsheet's usefulness and automate certain activity that would take hours of time. 79 Total Points
    • 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
    Total Course Points

    Learning Outcomes

    By successfully completing this course, students will be able to:
    • 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

    Online CEU Certificate
    • 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
    Document Your CEUs on Your Resume
    Course Title: Excel 2019
    Course Number: 9770516
    Course Requirements: View Course Requirements
    Lessons Rating: 4.5 / 5 Stars (6,498 votes)
    Languages: English - United States, Canada and other English speaking countries
    Course Type: Professional Development (Self-Paced, Online Class)
    CEU Value: 1.2 IACET CEUs (Continuing Education Units)
    CE Accreditation: Universal Class, Inc. has been accredited as an Authorized Provider by the International Association for Continuing Education and Training (IACET).
    Grading Policy: Earn a final grade of 70% or higher to receive an online/downloadable CEU Certification documenting CEUs earned.
    Assessment Method: Lesson assignments and review exams
    Syllabus: View Syllabus
    Duration: Continuous: Enroll anytime!
    Course Fee: $50.00 (no CEU Certification) || with Online CEU Certification: $75.00

    Choose Your Subscription Plan

    Course Only
    One Course
    No Certificate / No CEUs
    for 6 months
    Billed once
    This course only
    Includes certificate X
    Includes CEUs X
    Self-paced Yes
    Instructor support Yes
    Time to complete 6 months
    No. of courses 1 course
    Certificate Course
    One Course
    Certificate & CEUs
    for 6 months
    Billed once
    This course only
    Includes certificate Yes
    Includes CEUs Yes
    Self-paced Yes
    Instructor support Yes
    Time to complete 6 months
    No. of courses 1 course
    Platinum Yearly
    Best Value
    Certificates & CEUs
    per year
    Billed once
    Includes all 500+ courses
    Includes certificate Yes
    Includes CEUs Yes
    Self-paced Yes
    Instructor support Yes
    Time to complete 12 Months
    No. of courses 500+
    Platinum Monthly
    Certificates & CEUs
    $69 first month
    $29.00 / each consecutive month thereafter
    Billed monthly
    Includes all 500+ courses
    Includes certificate Yes
    Includes CEUs Yes
    Self-paced Yes
    Instructor support Yes
    Time to complete Monthly
    No. of courses 500+