(212) 684-5151

Advanced Microsoft Excel 2016
Advanced Microsoft Excel 2016

Price: $209.00

Course Code: 6H | Hours: 7

Excel Training Classes | Advanced Course Overview

Our advanced Excel training will delve into data tables, goal seek, advanced database functions (including INDEX-MATCH), recording macros, and advanced analytical tools. Throughout the course you'll be building speed with our revolutionary time-saving tricks.

Advanced Excel Course Outline

Hands-on Advanced Excel Training

Our Advanced Excel class is hands-on and uses real-world examples throughout the training. The instructor will first explain the concept along with a example, and then you'll perform an exercise on your own. Our step-by-step training manual is the perfect reference guide for during and after the class.

Revolutionary Excel Video Suite & Free Retake

You'll also receive access to our premium Advanced Excel video suite, which has the lessons on high-quality video that can be viewed on desktop, mobile and tablet.

And just in case you need a refresher, you can retake the class anytime within 6 months of the course (provided there is an available seat in the class).

With all these revolutionary resources, you're virtually guaranteed to walk away with impressive skills in Excel.

What You'll Learn in this Class:

  • Create Powerful Formulas
  • Customize Text and Number formats
  • Use Advanced Functions
  • Perform What if Analysis
  • Use Advanced Analytical Tools and Database Functions
  • Record a Macro

Prerequisites:

Students are recommended to take the following course or possess equivalent knowledge:

Next Classes:

Related Classes:

See Also:

Prerequisites:

Students are recommended to take the following course or possess equivalent knowledge:

Next Classes:

Related Classes:

See Also:

Advanced Excel Course Outline

Lesson 1: Cell Management

• Advanced Cell Locking
• Cell Auditing

Lesson 2: Special Formatting

• Custom Number Formats
• Text function
• Date functions
• Conditional Formatting-Formulas

Lesson 3: Advanced Functions

• Nested If statements
• If statements with And/Or
• Small & Large functions

Lesson 4: What If Analysis

• Goal Seek
• Data Tables

Lesson 5: Advanced Analytical Tools

• Data Consolidation
• Conditional SumProduct
• Pivot Table-Calculations
• Pivot Charts

Lesson 6: Advanced Database Functions

• Match function
• Vlookup-Match
• Index-Match
• Index-Double Match

Lesson 7: Introduction to Macros

• Recording Macros
• Relative Macros

End of Class Project

• Project