Excel 2016 Advanced

Course Schedule:

Excel 2016 Advanced is scheduled for the following dates and times:

Start DateEnd DateStart TimeLocation
NOV 20 2024NOV 21 202408:00 AMVirginia Beach
DEC 18 2024DEC 19 202408:00 AMNewport News
JAN 8 2025JAN 9 202508:00 AMVirginia Beach
FEB 5 2025FEB 6 202508:00 AMNewport News
MAR 5 2025MAR 6 202508:00 AMVirginia Beach
APR 9 2025APR 10 202508:00 AMNewport News
MAY 7 2025MAY 8 202508:00 AMVirginia Beach
JUN 4 2025JUN 4 202508:00 AMNewport News
JUL 9 2025JUL 10 202508:00 AMVirginia Beach
Purchase Now

Overview

Excel 2016 Advanced builds on the concepts and skills of our intro course to provide advanced tools for solving real-world problems in Microsoft Excel 2016: lookup and decision-making functions, auditing and error-handling, array functions, date and text functions, importing and exporting, using Power Pivot and the Power Pivot Data Model, what-if-analysis, and macros.

Students will benefit most from this course if they want to use Excel 2016 to perform real-world tasks such as handling and getting information from large amounts of data from sources inside out and outside of Excel, creating output that varies according to conditions, manipulating dates and text, and automating repetitive tasks. If they intend to take a Microsoft Office Specialist or Expert exam for Excel, this course will complete their coverage of all the objectives for both exams.

The course assumes students know how to use a computer, that they're familiar with Microsoft Windows, and that they've taken the intro courses or have equivalent introductory experience with Excel. The exercises are more detailed and complex than those in the previous levels.

Course Content

read more

For More Information

To get started, fill out this simple form!

*Required Field

Find another course:

COURSE LOOKUP