Course 55167A: Advanced Microsoft Excel 2016

Learn in a classroom

Classroom training

Learn more

Find a Microsoft Learning PartnerFind a classroom training partner
Anytime accessNo
Anywhere access to recorded instructorNo
Microsoft official training contentYes
In-depth trainingYes
Hands-on labs No
SATV redemption No
Ask instructor questions in personYes
Attend live class in personYes
Attend live class remotelyYes
Time commitment
About this course
Type: Course
Audience(s):Information Workers
Technology:Excel
Level:Advanced
This Revision:A
Delivery method:
Classroom
Length:1 day
Language(s):English

First published:

15 January 2016
Overview
About this course

This Advanced Microsoft Excel 2016 training class is designed for students to gain the skills necessary to use pivot tables, audit and analyze worksheet data, utilize data tools, collaborate with others, and create and manage macros.

Audience profile
Students who have intermediate skills with Microsoft Excel 2016 who want to learn more advanced skills or students who want to learn the topics covered in this course in the 2016 interface.
At course completion

After completing this course, students will be able to: Insert the course objectives in a bulleted list with periods. For example:

  • Create pivot tables and charts.
  • Learn to trace precedents and dependents.
  • Convert text and validate and consolidate data.
  • Collaborate with others by protecting worksheets and workbooks.
  • Create, use, edit, and manage macros.
  • Import and export data.
Course details
Course Outline
Prerequisites
Intermediate level of Excel.
Community

Looking for training resources, events and advice from peers? Join the Microsoft Training and Certification Community.

Preparing for an exam now? Find your Microsoft Certification Study Group.

Talk to us on these social networks: