Universal Class: Over 500 Online Certificate Courses
 

Ultimate Excel 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
 
  • 69
    Lessons
  • 102
    Exams &
    Assignments
  • 46
    Hours
    average time
  • 4.6
    CEUs
 
 
 

Course Description

This course bundle includes the following courses:
  1. Excel 2016
  2. Advanced Excel 2016
  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.

Learn Excel 2016

Microsoft Excel is a spreadsheet program that comes packaged with the Microsoft Office family of software products.  Just like the other programs by Microsoft, Excel can be used for a wide variety of purposes such as creating an address book, grocery lists, tracking expenses, creating invoices and bills, accounting, balance checkbooks and other financial accounts, as well as any other purpose that requires a spreadsheet or table. 

This course will cover the many features of Excel 2016 and will teach you how to use them, starting with the simple and working to the most complicated.  The good news is that Excel 2016 makes everything easy.  By learning how to navigate the program and where to find each feature, operating Excel can become a breeze.

This course will teach you how to:

·    Create a spreadsheet

·    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.  For example, sales goals

·    And much more
 
This course was designed to teach you skills you'll need to successfully use Excel 2016.   Each lesson contains instructions and illustrations to show you how to use the features, then walks you through step-by-step so you can see how everything is done.  You don't need previous experience with Excel to be able to complete this course.  This course will start with basic skills, then move forward to more advanced features and techniques.  Although you do not need access to Excel 2016 for this course; it is highly recommended.

Excel 2016 Advanced Skills Course

With most software programs on the market today, you can thrive with just a basic knowledge of the tools and options built into the individual program.  However, that is not necessarily true when it comes to Excel 2016.  

Excel is a complex, yet easy-to-use spreadsheet program that contains a multitude of much-needed tools with very advanced options.   While it's true that you can create an attractive spreadsheet and use simple formulas in Excel with very little experience, that is just the tip of the iceberg when it comes to what Excel can truly do.  In order to be able to successfully use the program to create spreadsheets, enter data, and maintain that data, you must have more than basic knowledge.   This course gives you the advanced skills you need to be able to fully use the program.

This course is for the intermediate student who has already mastered the basic skills needed to use Excel 2016 and wants to gain more advanced skills to put to work in a business environment or for personal use.  This course goes in-depth, using step-by-step instructions to teach advanced techniques to broaden all students' knowledge and use of the program.

In this course, you will learn how to:

·    Create outlines in Excel

·    Create your own templates

·    Work with Sparklines

·    Create and manage scenarios

·    Use Goal Seek and Solver

·    Create, manage, and format pivot tables and pivot charts

·    Use the Excel mathematical functions

·    Create and write complex formulas

·    Perform data lookups

·    Create and use IF statements

·    Use Excel's data functions

·    Create and use data validation rules

·    Apply custom and prebuilt conditional formatting

·    Work with functions to manipulate strings of text and data

·    Create and use macros

·    Troubleshoot and audit formulas

·    Create pivot tables and pivot charts

·    Use queries to import external data

·    Import and clean data

·    Link and consolidate worksheets and workbooks

·    Troubleshoot errors

·    And more

Visual Basic for Excel:

Developer tools in Microsoft Office give you the functionality to create custom applications in Excel. These tools require Visual Basic for Applications (VBA). The developer can create custom spreadsheets, workbooks, controls, and even toolbar add-ins for users.

Visual Basic is a specific Microsoft language, so it integrates into any Microsoft productivity tool. This course focuses on Excel customizations and applications. To create these customizations, you first need to learn macros and what they can do for your projects. We then go into modules and custom coded macros. Visual Basic is an object-oriented language, so we show you how to create custom classes that plug into your Excel modules.

This course not only focuses on Visual Basic syntax, but we also focus on working with classes, properties and methods specific to the Visual Basic version for Excel. We show you how to data mine from external source, connect to databases, and even scrape Internet content to include in a local spreadsheet.

We also work with pivot tables, charts and graphs that you can automatically draw and render within an Excel spreadsheet. Later chapters include instructions and tutorials on Sparklines and working with external files. We help you develop skills in error handling to provide better ways to work with errors in your code.

Whether you're new to Excel or just new to the Visual Basic for Application language, this course will help you develop the skills necessary to build custom applications that work with a variety of industries and users.

Show More
  • 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
 

Related Courses

  • Office 2013: Word, Excel, PowerPoint and Outlook
    Office 2013: Word, Excel, PowerPoint and Outlook
    Word 2013: This course will teach both the new and experienced user alike how to use the many features of MS Word 2013. You'll learn how to create documents, publications and complete tasks that require the use of a word processor. You'll start out...
    $110.00
    4.0 CEUs 40h
  • Visual Basic for Excel
    Visual Basic for Excel
    Developer tools in Microsoft Office give you the functionality to create custom applications in Excel. These tools require Visual Basic for Applications (VBA). The developer can create custom spreadsheets, workbooks, controls, and even toolbar add-i...
    $115.00
    1.7 CEUs 17h
  • Advanced Excel 2016
    Advanced Excel 2016
    Excel 2016 Advanced Skills Course With most software programs on the market today, you can thrive with just a basic knowledge of the tools and options built into the individual program. However, that is not necessarily true when it comes to Excel 20...
    $85.00
    1.7 CEUs 17h
  • Excel 2016
    Excel 2016
    Microsoft Excel is a spreadsheet program that comes packaged with the Microsoft Office family of software products. Just like the other programs by Microsoft, Excel can be used for a wide variety of purposes such as creating an address book, grocery...
    $75.00
    1.2 CEUs 12h
  • Office 2016: Word, Excel, PowerPoint and Outlook
    Office 2016: Word, Excel, PowerPoint and Outlook
    Microsoft Word 2016: Microsoft Word 2016 is the latest version of the popular word processing software offered as part of the Microsoft Office suite. This course will teach you all the skills you'll need to successfully use Word 2016. You'll learn ...
    $110.00
    3.2 CEUs 32h
  • Ultimate Excel Bundle
    Ultimate Excel Bundle
    Learn Excel 2016 Microsoft Excel is a spreadsheet program that comes packaged with the Microsoft Office family of software products. Just like the other programs by Microsoft, Excel can be used for a wide variety of purposes such as creating an addr...
    $125.00
    4.6 CEUs 46h
  • Microsoft Project 2016
    Microsoft Project 2016
    Microsoft Project 2016 is a project management software program created for businesses and freelance professionals to help better manage individual projects that occur within companies. Although no project management software should be used to repla...
    $75.00
    0.8 CEUs 8h
  • PowerPoint 2016
    PowerPoint 2016
    PowerPoint 2016 is a presentation creator that can be used to create stunning slideshows and basic videos. It can also be used to create slide presentations, handouts, transparencies, and much more. While creating presentations using some programs c...
    $75.00
    0.7 CEUs 7h
  • OneNote 2016
    OneNote 2016
    OneNote 2016 is a note-taking program that comes bundled with the Microsoft Office 2016 suite. Whereas MS Word is a word processing program that you can use to create documents, OneNote is simply a note taking program that you can use to take notes ...
    $75.00
    0.5 CEUs 5h
  • Microsoft Access 2016
    Microsoft Access 2016
    Microsoft Access 2016 is an information management tool that allows you to store, report, and analyze information within a relational database. If you're trying to use Excel to manage large amounts of information, then chances are Microsoft Access w...
    $95.00
    1.2 CEUs 12h
  • Social Media Marketing 101
    Social Media Marketing 101
    The importance for modern businesses to understand the need for a strategic social media presence cannot be understated. From creating an outlet to directly connect with consumers, to providing insight into buying behavior, to boosting SEO rankings,...
    $75.00
    1.0 CEUs 10h
  • JQuery Programming
    JQuery Programming
    JQuery is one of the most popular frameworks on the web that deals with client-side scripting for styling web pages and performing asynchronous events. It's built on the JavaScript language, so anyone familiar with the JavaScript language will pick ...
    $85.00
    0.9 CEUs 9h
  • Introduction to JavaScript
    Introduction to JavaScript
    JavaScript is the globally used client-side scripting language for the web. Most browsers support the language by default, so you can get started using JavaScript and HTML with a simple text editor and browser for testing. Client-side, programming l...
    $75.00
    1.0 CEUs 10h
  • Introduction to SQL
    Introduction to SQL
    This comprehensive course teaches and demonstrates all aspects of SQL. While you'll learn everything there is to do with SQL, this course assumes you have no prior SQL experience and is for the complete beginner. Structured Query Language (SQL) is t...
    $75.00
    1.7 CEUs 17h
  • OS X Yosemite
    OS X Yosemite
    OS X Yosemite is the latest version of the OS X operating system released by Apple on June 2, 2014. It can be installed on any Mac device that meets the general specification requirements and can be installed for free by going to the Apple App Store...
    $75.00
    0.7 CEUs 7h
  • MySQL
    MySQL
    If you've decided to build a website or need a database, MySQL is an open-source option that's very cost effective and affordable. Without knowing how to install, configure, design and maintain the database, you risk having a poor performing environ...
    $80.00
    1.0 CEUs 10h
  • Windows 10
    Windows 10
    Windows 10 is the latest version of the Windows operating system released by Microsoft on June 29, 2015. It follows Windows 8 and Windows 8.1, which introduced some of the biggest changes to the operating system since the first release in 1985. Wind...
    $75.00
    0.5 CEUs 5h
  • Learn HTML - Create Webpages Using HTML5
    Learn HTML - Create Webpages Using HTML5
    This course teaches you how to create webpages from scratch using the most current standard in HTML -- HTML5. HTML5 is the latest standard in web page coding. Whether you're a new or seasoned web designer, you need to know the latest in HTML archite...
    $75.00
    1.0 CEUs 10h
  • Microsoft Word 2016
    Microsoft Word 2016
    Microsoft Word 2016 is the latest version of the popular word processing software offered as part of the Microsoft Office suite. This course will teach you all the skills you'll need to successfully use Word 2016. You'll learn everything you need t...
    $75.00
    0.8 CEUs 8h
  • Introduction to CSS
    Introduction to CSS
    Ever wonder how the latest website designs are made? Cascading Style Sheets (CSS) are the main coding files used to lay out a website and its design. CSS3 is the latest in styling standards, and it brings several new properties and declarations you ...
    $75.00
    1.1 CEUs 11h
  • C# Programming
    C# Programming
    C# is a powerful backend coding language used for Microsoft web and desktop applications. C# is a C-style language, so you can take C# and learn other languages such as Java, C and C++. This course will get you started with C# and the language style...
    $120.00
    1.7 CEUs 17h
 
 

List of Included Courses

Excel 2016
 
1.2
CEUs
20
Lessons
   
$75.00
Course Value
 
Advanced Excel 2016
 
1.7
CEUs
22
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 Bundle
Languages: English - United States, Canada and other English speaking countries
Category:
Course Type: Technical Skill (Intermediate) (Self-Paced, Online Class)
CEU Certification: 4.6 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
You save 50%!
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 $427.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

  • "Excellent instructor. I did not ask any questions." -- Ken M.
  • "Overall, this course was extremely helpful. I am amazed at all the things that can be done with Excel. I also delighted in having the links that added additional information to improve a students skills, as well as having access to purchasing options which were advertised on some links. The videos were very helpful, for people like me, who need visual examples too. I strongly believe that if I had a job working with Excel, this course would indeed make my a pro and improve my skills and knowledge a lot." -- Florentina R.
  • "The course instructor was very efficient in marking my exams and providing me with feedback." -- Gemma T.
  • "This was a great introduction to Excel 2016. I feel that I learned enough to get myself started." -- Monica F.
  • "No comments the instructor was great." -- Deborah T.
  • "Great instructor. Logical progression of lessons. All aspects were explained well." -- Richard A. P.
  • "I enjoyed listening to the instructor's videos. Every single lesson had good instruction." -- David L.
  • View More Testimonials...
Follow Us Online
  • Follow us on Google Plus Follow us on FaceBook Follow us on Twitter Follow us on YouTube
© Copyright 1999-2018 Universal Class™ All rights reserved.