Skip to main content

Excel 2016 Intermediate - Online

ID : 24518   
« back to classes page
Learn how to create informative, eye-catching charts and graphs and harness the power of Excel's data analysis tools and AutoFilter commands. Find out how easy it is to create macros that let you manipulate data with the push of a button. Discover how to use Goal Seek and Solver and apply them to real-world problems. Master PivotTables, Slicers, Sparklines, and other features of Microsoft Excel 2016. Take your knowledge of Excel even farther by adding VLOOKUP, INDEX & MATCH, and other time-saving functions to your skill set.


Prerequisite: Excel 2016 Introduction (or equivalent experience)

Learning Objectives:

  • Learn how to use the enhanced Excel 2016 chart features.
  • Learn how to manage data using filters, formulas, goal seeking, and more.
  • Discover how to use pivot tables in detail.
  • Learn the tools needed to speculate outcomes and solve problems using your data.
  • Learn how to create and format sparklines.
  • Learn how to create and use macros and functions.

View a course demo

For our online course refund policy, click here.

Requirements: Microsoft Office or Excel 2016 or Microsoft Office 365 Home Premium, Windows 7, 8, or 10 operating system, Internet access, e-mail, the Microsoft Internet Explorer (9.0 or higher), Google Chrome, Safari, or Mozilla Firefox Web browser, and the Adobe PDF plug-in (a free and simple download you obtain at ). Note: This course is not suitable for Mac users, users of older versions of Excel, or users of OpenOffice. Starter or Web App versions of Excel are not compatible with this course.

You will need to create a login for your online classroom. Go to Find your course by browsing the catalog or using the search bar. Click the 'Add to Cart' button. Select your start date and then create a Username and Password. You must make an 80 or higher on the final exam (online) to successfully complete the course. You may only take the exam once.

If you have questions about this course, please contact the online coordinator at 470-578-6693 or

Class Details

12 Sessions
Online 24/7


Online Instructor 

CEUs : 2.4



Schedule Information

Date(s) Class Days Times Location Instructor(s)
6/12/2019 - 8/2/2019 Online 24/7 12:00 AM - 12:00 AM N/A - Online Online Instructor 

Other Class Offerings

ID: 25877

07/17/19 - 09/06/19
Online 24/7

ID: 25878

08/14/19 - 10/04/19
Online 24/7