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.

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

Course Lessons

Average Lesson Rating:

"Extraordinarily Helpful"

(65 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 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. 10 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