The Advanced Microsoft Excel 2016 training is a one-day class that is designed for students to equip themselves with the necessary skill-set of using pivot tables, auditing and analyzing worksheet data, utilizing data tools, collaborating with others, and creating and managing macros.
Completion of the course equips the participants with the following skill set:
Module 1: Using Pivot Tables
In this module, participants will learn how to use Pivot Tables.
Lessons
Module 2: Auditing Worksheets
In this module, participants will learn how to audit worksheets.
Lessons
Module 3: Data Tools
In this module, participants will learn how to work with data tools.
Lessons
Module 4: Working with Others
In this module, participants will learn how to do various tasks associated with working with others in Excel.
Lessons
Module 5: Recording and Using Macros
In this module, participants will learn how to record and use macros.
Lessons
Module 6: Random Useful Items
In this module, participants will learn how to do some random useful tasks in Excel.
Lessons
Module 7: Microsoft Excel Features that Were New in 2013
In this module, participants will learn how to use some new features that were new in 2013.
Lessons
Module 8: Features New in 2016
In this module, participants will learn how to some new features new in 2016.
Lessons
This course is beneficial for students who have intermediate-level knowledge of Microsoft Excel 2013 or more experienced Excel users who are interested in learning the topics covered in this course on the 2013 interface.
Before attending the course, a candidate must have the intermediate level of Excel experience.
Name | Code | Fee |
---|
OR