Online Class: Excel 2019

Name: Excel 2019
Price: 95.00 USD

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.

$95.00
no certificate

- OR -

$120.00
with CEU Certificate*

Start Right Now!

$120.00 (with CEU Certificate)

Taking multiple courses? Save with our platinum program.

15

Lessons
17

Exams &
Assignments
13,777

Students
have taken this course
12

Hours
average time
1.2

CEUs

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.

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.

Courses Frequently Bought Together:

Microsoft Word Level 1

Microsoft PowerPoint Level 1

Google Sheets

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:

"Extraordinarily Helpful"

(8,174 votes)

Lesson 1 - Introduction to Microsoft Excel 2019

11 Points

This first lesson will provide an introduction to this program and review the course structure.

Lesson 1 Video
Lesson discussions: Reasons for Taking this Course
Complete Assignment: Motives for Taking this Course
Assessment: Lesson 1 Quiz

Lesson 2 - Worksheets, Workbooks and Entering Data in Excel 2019

9 Points

In this lesson we will begin the process of working with worksheets and workbooks as well as entering and editing data.

Lesson 2 Video A
Lesson 2 Video B : Entering Data
Assessment: Lesson 2 Quiz

Lesson 3 - Formatting Cells and Data

10 Points

This lesson will explore and provide detailed examples of the process of Formatting Cell Data.

Lesson 3 Video
Assessment: Lesson 3 Quiz

Lesson 4 - Editing Worksheets and Cells

10 Points

This lesson will demonstrate how to alter and adjust data in cells.

Lesson 4 Video
Assessment: Lesson 4 Quiz

Lesson 5 - Formulas and Calculations

10 Points

This lesson provides comprehensive instruction on using Excel formulas, functions, and performing calculations.

Lesson 5 Video A
Lesson 5 Video B : Formulas and Calculations
Assessment: Lesson 5 Quiz

Lesson 6 - Creating a What-If Analysis

10 Points

This lesson will show you how to use a What-If Analysis

Lesson 6 Video
Assessment: Lesson 6 Quiz

Lesson 7 - Adding Images and Graphics

10 Points

This lesson will demonstrate how to add images and other graphics to your excel project.

Lesson 7 Video A
Lesson 7 Video B : Working with Graphics
Assessment: Lesson 7 Quiz

Lesson 8 - Charts and Diagrams

10 Points

How to make use of charts and diagrams will be examined in this lesson.

Lesson 8 Video A
Lesson 8 Video B : Working with Charts and Diagrams
Assessment: Lesson 8 Quiz

Lesson 9 - Creating Data Lists and Managing Data

10 Points

This lesson will demonstrate the process of creating data lists

Lesson 9 Video A
Lesson 9 Video B : Managing Data
Assessment: Lesson 9 Quiz

Lesson 10 - Pivot Tables and Charts

10 Points

This lesson will review Pivot Tables and Carts used in this version of Excel.

Lesson 10 Video
Assessment: Lesson 10 Quiz

Lesson 11 - Templates and Macros

10 Points

This lesson covers some of the useful templates and the application of Macros available in Microsoft Excel 2019.

Lesson 11 Video
Assessment: Lesson 11 Quiz

Lesson 12 - Retrieving External Data

9 Points

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.

Lesson 12 Video
Assessment: Lesson 12 Quiz

Lesson 13 - Sorting and Filtering

10 Points

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.

Lesson 13 Video
Assessment: Lesson 13 Quiz

Lesson 14 - Common Useful Functions

10 Points

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.

Lesson 14 Video
Assessment: Lesson 14 Quiz

Lesson 15 - Introduction to VBA

79 Points

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.

Lesson 15 Video
Lesson discussions: End of Course Poll; Course Comments
Assessment: Lesson 15 Quiz
Assessment: The Final Exam

218

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.
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

Course Title: Excel 2019

Course Number: 9770516

Lessons Rating: 4.3 / 5 Stars (8,174 votes)

Languages: English - United States, Canada and other English speaking countries

Category:

UniversalClass.com > Computers & Technology > Microsoft Office Certification Courses

Availability: This course is available online in all U.S. states, including California, Texas, Florida, New York, Pennsylvania, Illinois, Ohio, and Georgia. It’s also offered in English-speaking countries, including the UK, Canada, Australia, and New Zealand.

Last Updated: April 2024

Course Type: 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

Instructor: UniversalClass Instructional Team

Syllabus: View Syllabus

Course Fee: $120.00 U.S. dollars

Choose Your Subscription Plan

Course Only

One Course
No Certificate / No CEUs

$95

for 6 months

Add to Cart

Billed once
This course only

Includes certificate	X
Includes CEUs	X
Self-paced
Instructor support
Time to complete	6 months
No. of courses	1 course

Certificate Course

One Course
Certificate & CEUs

$120

for 6 months

Add to Cart

Billed once
This course only

Includes certificate
Includes CEUs
Self-paced
Instructor support
Time to complete	6 months
No. of courses	1 course

Platinum Yearly

ALL COURSES
Certificates & CEUs

$189

per year

Start Now

Billed once
Includes all 600+ courses

Includes certificate
Includes CEUs
Self-paced
Instructor support
Time to complete	12 Months
No. of courses	600+

Platinum 2 Years

ALL COURSES
Certificates & CEUs

$299

for 2 years

You save $79.00!

Start Now

Billed once
Includes all 600+ courses

Includes certificate
Includes CEUs
Self-paced
Instructor support
Time to complete	24 Months
No. of courses	600+

Student Testimonials

"This course was very informative and I learned so much and I am lot more comfortable using Microsoft Excel." -- Rachel S.
"I thought I knew a lot about Excel until taking this course. I learned so many fun and new things. I can't wait to get creating!" -- Erica J.
"I felt this course was very helpful for me. Not knowing anything about excel before starting the course, I feel I have a much better understanding of its functions and capabilities now. I also feel a much greater confidence in applying knowledge of this program within my skills and experience." -- Tess H.
"I thought this course was beneficial. I never used Excel for much more than adding and subtracting. However, I have a great new understanding of the possibilities of this program now. I have done a cool project using Excel since starting this class and am interested in going further. Thank you." -- Daryl S.
"Taking the Microsoft Excel course was something that was long overdue, and this course in particular met my needs and expectations. It was helpful in learning basic actions more thoroughly, as well as more newfound advanced features I was eager to comprehend. The theme of each lessons were explained well and I am looking forward to putting my knowledge of Excel to good use." -- Jadah N.
"This course was very helpful and easy to follow. I hope that I can use these skills to help me get some freelance work in Data Entry." -- Carrima H.
"Thoroughly enjoyed the course, feel like I gained a lot of knowledge and that I am better prepared to use Excel in my work." -- Claire S.
"This was more than I needed for what I do but I loved learning all the added features. Nice to put on your resume that you are familiar with the concepts." -- Crystle S.
"This course was very helpful and informative; so much so that I will be taking the Advanced Excel court in the near future." -- Antoinette M.
"It was very helpful. Some lessons were just a refresher and some were on topics I knew nothing about." -- Lindsey S.