Excel 2016 Advanced - Online

ID : 13213   
« back to classes page

Master advanced features and functions of Microsoft Excel 2016, including analysis tools, data tables and databases, PivotTables, custom controls, importing external data, and conditional formatting. Learn to use validation to protect the integrity of your worksheets and solve common worksheet problems.

Prerequisite: Excel 2016 Intermediate

Learning Objectives:

  • Learn data analysis tools to improve decision making and streamline processes.
  • Create data forms that replace applying filters and formats separately.
  • Use conditional formatting to hide errors, highlight records based on multiple criteria, and more.
  • Use functions and create nested functions.
  • Learn one and two-variable data tables for analyzing potential outcomes.
  • Learn the functions available in the Analysis ToolPak.

View a course demo

For our online course refund policy, click here.

Requirements: Internet access, e-mail, Firefox, Internet Explorer (9.0 or above), Google Chrome, or Safari web browser, and Microsoft Excel 2016. Software is not included in course fee. This course is not suitable for Macintosh users, users of older versions of Microsoft Excel, or "Starter Version" and "Web App" versions of Excel 2016.

You will need to create a login for your online classroom. Visit www.ed2go.com/ksuconed. Find your course by browsing the catalog or using the search bar. Click the 'Add to Cart' button (this site does not accept payments - you will not be charged here). 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-3355 or online@kennesaw.edu.

Class Details

38 Sessions
Weekly - Wed, Thu, Fri, Sat, Sun, Mon, Tue

Location
ccpe.kennesaw.edu

Instructor
Online Instructor 

CEUs : 2.4

Fee: 

$179.00


Schedule Information

Date(s) Class Days Times Location Instructor(s)
4/12/2017 - 5/19/2017 Weekly -Sun, Mon, Tue, Wed, Thu, Fri, Sat 12:00 AM - 11:59 PM TBD Online Instructor 

Other Class Offerings

Excel 2016 Advanced - Online
ID: 13214

05/17/17 - 06/23/17
Weekly - Wed, Thu, Fri, Sat, Sun, Mon, Tue

Location
ccpe.kennesaw.edu

Instructor
Online Instructor

Excel 2016 Advanced - Online
ID: 13215

06/14/17 - 07/21/17
Weekly - Wed, Thu, Fri, Sat, Sun, Mon, Tue

Location
ccpe.kennesaw.edu

Instructor
Online Instructor