You are not logged in
This Month Specials

Special Promotion

$209 Excel or $199 PowerPoint for Business Blowout! (Normally $299/ea)

PowerPivot Fundamentals $199 (Normally $299)

$199 QuickBooks Level 1 or Level 2 for PC, Mac, or Online Classes (Normally $299/ea)

Now $545-Excel Power Programming with VBA (Normally $659)

Now $649-Photoshop Essentials 2 Day Course (Normally $749)


Current Sales Packages

1 Union Square West, Suite 805, NY, NY 212.658.1918

Excel for Business Level III - Advanced


Mar 21, Mar 22: 6:00pm–9:00pm$20910Garfield S.185 Madison Avenue, NYC
Mar 28: 10:00am–5:00pm$2099Garfield S.185 Madison Avenue, NYC
Apr 6: 10:00am–5:00pm$2098TBD185 Madison Avenue, NYC
Apr 7: 10:00am–5:00pm$2098TBD185 Madison Avenue, NYC
Apr 16, Apr 17: 6:00pm–9:00pm$20910TBD185 Madison Avenue, NYC
Apr 18: 10:00am–5:00pm$2098TBD185 Madison Avenue, NYC
May 1: 10:00am–5:00pm$20910TBD185 Madison Avenue, NYC
May 5: 10:00am–5:00pm$20910TBD185 Madison Avenue, NYC
May 14: 10:00am–5:00pm$20910TBD185 Madison Avenue, NYC
May 14, May 15: 6:00pm–9:00pm$20910TBD185 Madison Avenue, NYC
May 24: 10:00am–5:00pm$20910TBD185 Madison Avenue, NYC
Jun 8: 10:00am–5:00pm$20910TBD185 Madison Avenue, NYC
Jun 10: 10:30am–5:30pm$20910TBD185 Madison Avenue, NYC
Jun 13, Jun 14: 6:00pm–9:00pm$20910TBD185 Madison Avenue, NYC
Jun 20: 10:00am–5:00pm$20910TBD185 Madison Avenue, NYC
Jul 2: 10:00am–5:00pm$20910TBD185 Madison Avenue, NYC
Jul 7: 10:00am–5:00pm$20910TBD185 Madison Avenue, NYC
Jul 9, Jul 10: 6:00pm–9:00pm$20910TBD185 Madison Avenue, NYC
Jul 13: 10:00am–5:00pm$20910TBD185 Madison Avenue, NYC
Jul 25: 10:00am–5:00pm$20910TBD185 Madison Avenue, NYC
Show more

Call 212.658.1918 or email us

Advanced Excel Class New York City

Advanced Excel for Business: In-Person Class with Free Retake & Premium Video Suite

Advanced Excel for Business covers the advanced applications of Excel used frequently by business professionals. This course is perfect for those with strong working knowledge and practice in Excel looking to apply more complex Excel features. In this advanced Excel course, you will learn Goal Seek, Data Tables, advanced functions, and basic macros. 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.

In this hands-on course you will work on real-world examples, reinforcing the concepts with practice throughout the class, as well as a cumulative project at the end. Each attendee will receive access to our revolutionary Excel Fundamentals video suite, with lifetime access to several hours of premium content.

This class is part of our Excel for Business Bootcamp. Take our three Excel for Business classes and get a 15% package discount. Sign up for the Excel Bootcamp

Revolutionary Excel Video Suite with Premium Content

Review the course materials with high-quality video with lifetime access on desktop, tablet or mobile, a $95 value, included at no additional charge.

Advanced Excel Class

Rated the Best Excel Courses in New York City

  • Practical and hands-on training focused on real-world applications of Excel
  • Engaging and interactive instructors
  • Revolutionary video suite with several hours of premium content
  • Proprietary course manual and shortcut sheets
  • Small class sizes for personalized attention

Advanced Course Outline

Advanced Course PDF Outline

Cell Management  
1) Advanced Cell Locking Create powerful formulas by locking either the column or the row
2) Hot Keys Transform the ribbon into a visual listing of pre-assigned shortcuts
3) Windows Techniques and keyboard shortcuts to allow editing of active windows
4) Cell Auditing Observe the relationship between formulas and cells
Special Formatting  
5) Date functions Calculate dates with a variety of functions
6) Conditional Formatting-Formulas Create custom rules for Conditional Formatting with formulas
Advanced Functions  
7) Nested If statements Nested "IF" statements allow for more than just two possibilities in a single cell
8) If statements with And/Or Expand the functionality of the IF function by adding an AND / OR criteri
What If Analysis  
9) Goal Seek Find the desired result by adjusting an input value
10) Data Tables Data Tables show the range of effects of one or two different variables on a formula
Advanced Analytical Tools  
11) Data Consolidation Summarize data from separate ranges and consolidate into a specified output range
12) Conditional SumProduct Use SumProduct with conditions to exclude data that does not meet certain criteria
13) Pivot Table-Calculations Create calculated rows or columns in a Pivot Table that go beyond the source data
14) Pivot Charts Create dynamic, graphical representations of Pivot Table data
Advanced Database Functions  
15) MATCH function Return the relative position (column or row number) of a lookup value
16) VLOOKUP-MATCH Create a more accurate VLookUp by enhancing the determination of the Column Index number
17) INDEX-MATCH Efficiently return a value or reference from a cell at the intersecton of the row and column
18) INDEX-Double MATCH Use a second Match function to create a powerful, two-way lookup tool
Introduction to Macros  
19) Recording Macros Record Macros that involve formatting and calculations
20) Relative Macros Record relative reference macros for ad hoc reporting
End of Class Project  
21) Project End of class project to review key concepts from the class

See More Excel Classes at NYIM

All Excel Classes Beginner Intermediate Fast as Hell VBA Certification

© NYIM Training 2018

Client Testimonials
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! 11/26- Rebecca H. attended Excel for Business Level III - Advanced
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. 9/27- Alexandria A. attended Excel for Business Level III - Advanced