×
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
+View More
[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
+ View More

Starting at $299

ATTENTION

For GSA pricing or Contractor quotes call 240.667.7757

[GSA LOGO]

Get More Information!

Fill out the form below to get more info and pricing for Microsoft Excel 2016 Advanced Training!

  • Price Match Guarantee

    We’ll match any competitor’s price quote. Call us at 240-667-7757.

  • Included in this Microsoft Excel 2016 Advanced Training

    • 1 days instructor-led training
    • Microsoft Excel 2016 Advanced Training training book
    • Notepad, pen and highlighter
    • Variety of bagels, fruits, doughnuts and cereal available at the start of class*
    • Tea, coffee and soda available throughout the day*
    • Freshly baked cookies every afternoon*
Subscribe now

Get new class alerts, promotions, and blog posts