Chicago area career training

Microsoft Office 2016 Excel Level 3

Summary

Instructor-led
250
On-site
Call
Duration
8 Hours
* Pricing and Logistics are subject to change without notice.
 

Welcome to the third part of our Microsoft Office Excel 2016 courseware. This version of Excel incorporates some new features and connectivity options in efforts to make collaboration and production as easy as possible.

This course is intended to help all users get up to speed on the different aspects of Excel, including some of its more advanced features. We will cover how to automate worksheet functionality, audit worksheets, analyze data, work with multiple workbooks, export Excel data, as well as import and export XML data. 

About This Course

By the end of this course, users should be comfortable with automating worksheet functionality, auditing worksheets, using a variety of different analysis tools, working effectively with multiple workbooks, exporting Excel data, as well as importing and exporting XML data to and from a workbook. This course is broken up into lessons. Each lesson focuses on several key topics, each of which are broken down into easy-to-follow concepts. At the end of each topic, you will be given an activity to complete. At the end of each lesson, we will summarize what has been covered and provide a few review questions for you to answer. Supplemental learning for selected topics is provided in the form of Lesson Labs at the end of this book.

Outline

Lesson 1: Auditing Worksheets

Lesson 2: Working with Multiple Workbooks

Lesson 3: Automating Worksheet Functionality

Lesson 4: Analyzing and Presenting Data

Lesson 5: Analyzing Data with PivotTables, Slicers, PivotCharts  and Data Models

Lesson 6: Exporting Excel Data

Lesson 7: Importing and Exporting XML Data

Prerequisites

This class assumes the user has completed or has an understanding of the materials covered in the second part of the Microsoft Office Excel 2016 courseware, including:

§  Creating advanced formulas

§  Analyzing data with logical and lookup functions

§  Organizing worksheet data with tables

§  Visualizing data with charts

§  Analyzing data with PivotTables, slicers, and PivotCharts

§  Inserting graphics

§  Enhancing workbooks

Exam Details

Exam 77-727: Microsoft Office 2016 Excel

Course Schedule

Chicago
200 W Adams Suite 410 Chicago, IL 60606
06/28/2019 09:00 am - 05:00 pm
S M T W T F S
08/03/2019 09:00 am - 05:00 pm
S M T W T F S
09/13/2019 09:00 am - 05:00 pm
S M T W T F S
Lombard
720 E Butterfield Rd Suite 100 Lombard, IL 60148
06/28/2019 09:00 am - 05:00 pm
S M T W T F S
08/20/2019 - 08/22/2019 06:00 pm - 10:00 pm
S M T W T F S
09/13/2019 09:00 am - 05:00 pm
S M T W T F S
Deerfield
770 Lake Cook Rd Suite 200 Deerfield, Il 60015
06/28/2019 09:00 am - 05:00 pm
S M T W T F S
09/13/2019 09:00 am - 05:00 pm
S M T W T F S

Exam Pass Guarantee

At Microtrain we are committed to your success!
Let us show you the return you get from great tech training. We will personally guarantee that if you take our class and follow our program you will be successfully certified!

Learn More