Yelp Facebook YouTube Twitter Instagram

Advanced Excel for Business

Advanced Excel Classes in NYC

In this advanced Excel training, you’ll learn advanced database functions such as INDEX and MATCH; create basic macros; and use What-If Analysis for Goal Seek and Data Tables.

This advanced Excel course is taught by our affiliate, NYIM Training, at 185 Madison Avenue, 11th Floor. 

  • 6 Hours
  • Small classes
  • Mac or PC provided
  • Free retake

Register for a class

$209 Discounts Policies

NYC

Show all dates

What You’ll Learn

  • Cell management including cell locking, auditing, and hot keys
  • Special formatting for calculating dates
  • Use advanced functions such as nested IF statements
  • Learn advanced analytical tools for data consolidation, conditions to exlude data, and pivot charts
  • Use advanced database functions including MATCH, VLOOKUP-MATCH, and INDEX-Double MATCH
  • Record macros and relative reference macros for ad hoc reporting
  • Create a project that applies key concepts from the class
Excel 2016 classes at Noble Desktop

Learn Advanced Applications of Excel for Business Professionals

In this advanced Excel course you will build upon intermediate-level concepts, making your lookup functions more flexible, taking Pivot Tables to the next level, and facilitating workflow with cell management techniques and hot keys. This is the perfect class to learn more complex Excel features to add to your professional skillset.

  • “Great class! The content was well organized and the instructor was excellent. He was engaging, knew the material very well and was able to adjust to the various levels of ability of the students! Would definitely recommend! ”

    Rebecca H.

    Attended Advanced Excel for Business

  • “Had a one on one training with Garfield - he was patient, professional, and incredibly knowledgeable. Would highly recommend for anyone looking to expand their excel capabilities in business.”

    Alexandria A.

    Attended Advanced Excel for Business

Excel Video Suite Included

This class included lifetime access to a high-quality video suite of all the exercises completed during the class. Review the course materials anytime!

Gain Valuable Excel Tips & Tricks

Throughout the class we'll show you tricks and techniques to work more efficiently, including navigational and keyboard shortcuts.

Register for Advanced Excel for Business

$209 Discounts Policies

NYC

Show all dates