Online Class: Ultimate Excel Training Bundle

This Excel course bundle includes everything you would every want to learn about Excel, from the very beginner to the most advanced programming concepts and procedures.

$100.00
no certificate

- OR -

$125.00
with CEU Certificate*

Start Right Now!

$125.00 (with CEU Certificate)

Taking multiple courses? Save with our platinum program.

3 Course Bundle - One Low Price

Only $125.00* - Save $165.00

(normally $290.00)

* Includes Online CEU Certificates for Each Course

62

Lessons
92

Exams &
Assignments
45

Hours
average time
4.5

CEUs

Course Description

This course bundle includes the following courses:

Visual Basic for Excel

Excel 2019

Advanced Excel 2019

You may take these courses in any order you like. If you purchase the CEU Certificate option, you'll receive a separate CEU Certificate for each course you successfully complete.

Excel 2019:

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.

Advanced Excel 2019:

Excel is one of the most powerful tools in Microsoft Office. You can import, query, analyze and manipulate data to create powerful reports that can be used by individuals and enterprise businesses alike. This course explores some of the more advanced features of Microsoft Excel to give you a more powerful experience when you need the most out of spreadsheet software.

In this Excel 2019 advanced course, you'll learn all about...

Outlines, Custom Views, and Templates
Mathematical Functions
Data Functions and Data Lookups
The IF Function
Manipulating Text
Conditional Formatting
Sparklines
Importing, Cleaning and Validating Data
Pivot Tables and Pivot Charts
The What-If Analysis
Goal Seek and Solver
The Analysis ToolPak
Using Get & Transform to Perform Queries
Macros
And Much More!

The course starts with functions and data lookups, as these components of Excel help the spreadsheet creator with advanced calculations and import functionality. We then cover conditional formatting for highlighting important cells based off of conditions. Sparklines are also covered so that the learner can get a quick data visualization of the information stored in each worksheet.

Pivot tables are one of the most beneficial tools in Excel, and this course covers pivot tables both basic and advanced features. It then moves on to pivot charts, which are graphs that can be used with pivot table data.

Analysis tools in Excel 2019 are some of the most advanced and useful to users that want to run complex reports. Excel has three What-If analysis tools that can be run on your data and provide reports on goals that give answers to your problems. The Solver and Analysis Toolpak are two add-ins that expand on these tools, and they are also covered in this course.

The final lessons cover data validation, troubleshooting, querying data and macros. These lessons provide ways to work with data and clean up unstructured information. This course fully covers advanced features in Excel so that you can create complex spreadsheets for business or individual use.

Completely Online
Self-Paced
6 Months to Complete
24/7 Availability
Start Anytime
PC & Mac Compatible
Android & iOS Friendly
Accredited CEUs

Universal Class is an IACET Accredited Provider

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: Ultimate Excel Training Bundle

Course Number: 9770477

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

Category:

UniversalClass.com > Computers & Technology > Microsoft Office Courses

Availability: This course is online and available in all 50 states including: California, Florida, Georgia, Illinois, New York, Pennsylvania, Ohio, and Texas.

Last Updated: January 2023

Course Type: Self-Paced, Online Class

CEU Value: 4.5 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

Course Fee: $125.00 U.S. dollars

Choose Your Subscription Plan

Course Only

One Course
No Certificate / No CEUs

$100

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

$125

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!