×
Microsoft

Microsoft Excel 2016 Advanced Training

Course Overview

This 1-day, instructor-led course provides advanced tools for solving real-world problems in MS Excel 2016. You will learn:

  • Logical and lookup functions
  • Advanced formulas
  • Special functions
  • Importing and exporting
  • Analysis
  • Macros and forms

Schedule

Microsoft Excel 2016 Advanced Training

date
location
3/31/21 - 3/31/21 (1 days)

8:30AM - 4:30PM EST

Online
Sold Out
5/05/21 - 5/05/21 (1 days)

8:30AM - 4:30PM EST

Online
Sold Out
5/07/21 - 5/07/21 (1 days)

8:30AM - 4:30PM EST

Online
Open
5/07/21 - 5/07/21 (1 days)

8:30AM - 4:30PM EST

Tysons Corner, VA
Open
5/07/21 - 5/07/21 (1 days)

8:30AM - 4:30PM EST

Columbia, MD
Open
5/27/21 - 5/27/21 (1 days)

8:30AM - 4:00PM GMT+1

Stuttgart, Germany
Sold Out
7/09/21 - 7/09/21 (1 days)

8:30AM - 4:30PM EST

Online
Open
7/09/21 - 7/09/21 (1 days)

8:30AM - 4:30PM EST

Tysons Corner, VA
Open
7/09/21 - 7/09/21 (1 days)

8:30AM - 4:30PM EST

Columbia, MD
Open
8/18/21 - 8/18/21 (1 days)

8:30AM - 4:30PM EST

Online
Sold Out
9/10/21 - 9/10/21 (1 days)

8:30AM - 4:30PM EST

Online
Open
9/10/21 - 9/10/21 (1 days)

8:30AM - 4:30PM EST

Tysons Corner, VA
Open
9/10/21 - 9/10/21 (1 days)

8:30AM - 4:30PM EST

Columbia, MD
Open
11/24/21 - 11/24/21 (1 days)

8:30AM - 4:30PM EST

Online
Open
11/24/21 - 11/24/21 (1 days)

8:30AM - 4:30PM EST

Tysons Corner, VA
Open
11/24/21 - 11/24/21 (1 days)

8:30AM - 4:30PM EST

Columbia, MD
Open
[image]

Not seeing a good fit?

Let us know. Our team of instructional designers, curriculum developers, and subject matter experts can create a custom course for you.

Contact Us

Learn more about custom training

Course Outline

Logical and Lookup Functions

  • Decision-making functions
  •    Lookup and reference functions

Advanced Formulas

  • Auditing and error-trapping
  • Formula options
  • Arrays

Special functions

  • Date and time functions
  • Text functions
  • Other functions

Importing and Exporting

  • The Power Pivot Data Model
  • Exporting data

Analysis

  • What-if analysis
  • The Analysis Toolpak

Macros and Forms

  • Recording macros
  • Running macros
  • Forms
Subscribe now

Get new class alerts, promotions, and blog posts