Ultimate Excel Training Bundle


$100.00
no certificate
- OR -
$125.00
with CEU Certificate*
Start Right Now!
Taking multiple courses? Save with our platinum program.
 
3 Course Bundle - One Low Price
Only $125.00* - Save $150.00
(normally $275.00)
* Includes Online CEU Certificates for Each Course
 
  • 62
    Lessons
  • 91
    Exams &
    Assignments
  • 45
    Hours
    average time
  • 4.5
    CEUs
 
 
 

Course Description

This course bundle includes the following courses:
  1. Excel 2019
  2. Advanced Excel 2019
  3. Visual Basic for Excel
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
     
     

    List of Included Courses

    Excel 2019
     
    1.2
    CEUs
    15
    Lessons
       
    $75.00
    Course Value
     
    Advanced Excel 2019
     
    1.6
    CEUs
    20
    Lessons
       
    $85.00
    Course Value
     
    Visual Basic for Excel
     
    1.7
    CEUs
    27
    Lessons
       
    $115.00
    Course Value
     

    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: Ultimate Excel Training Bundle
    Languages: English - United States, Canada and other English speaking countries
    Course Type: Technical Skill (Intermediate) (Self-Paced, Online Class)
    CEU Certification: 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
    Duration: 6 Month Subscription
    Course Fee: $100.00

    Choose Your Subscription Plan

    Course Only
    One Course
    No Certificate / No CEUs
    $100
    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
    $125
    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
    ALL COURSES
    Certificates & CEUs
    $189
    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 2 Years
    ALL COURSES
    Certificates & CEUs
    $299
    for 2 years
    You save $79.00!
    Billed once
    Includes all 500+ courses
    Includes certificate Yes
    Includes CEUs Yes
    Self-paced Yes
    Instructor support Yes
    Time to complete 24 Months
    No. of courses 500+
     

    Student Testimonials

    • "Pretty much the whole course was helpful. I learned a lot of valuable knowledge. Everything I know or thought I knew was by teaching myself. Now I feel that I have accomplished something new. Thank You for offering these courses." -- Mark B.
    • "I learned so much in this course." -- Debra B.
    • "All the parts of the course were helpful to be honest. It was a new experience to me." -- Kiara S.
    • "Great class." -- Edmund G.
    • "All of it was helpful since I did not know it." -- Thomas M.
    • "All was very well organized." -- Alicia R.
    • "I found the content of this course to be excellent. For me, the most helpful aspects to understanding and retaining the information were the assignments and exams, but I also found the videos helped clarify the concepts presented in the lesson." -- Bonnie F.
    • View More Testimonials...

    Related Courses