Close
You are not logged in
Close
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)

GIFT CERTIFICATES AVAILABLE

Current Sales Packages

Close
185 Madison Ave, 11th Floor, New York, NY 10016 212.658.1918

Advanced Excel for Business

$209

SessionPriceSeatsLocation
May 24: 10:00am–5:00pm$2099185 Madison Avenue, NYC
Jun 8: 10:00am–5:00pm$20910185 Madison Avenue, NYC
Jun 10: 10:00am–5:00pm$2099185 Madison Avenue, NYC
Jun 13, Jun 14: 6:00pm–9:00pm$20910185 Madison Avenue, NYC
Jun 22: 10:00am–5:00pm$2098185 Madison Avenue, NYC
Jul 2: 10:00am–5:00pm$20910185 Madison Avenue, NYC
Jul 7: 10:00am–5:00pm$20910185 Madison Avenue, NYC
Jul 9, Jul 10: 6:00pm–9:00pm$20910185 Madison Avenue, NYC
Jul 13: 10:00am–5:00pm$20910185 Madison Avenue, NYC
Jul 25: 10:00am–5:00pm$20910185 Madison Avenue, NYC
Aug 5: 10:00am–5:00pm$20910185 Madison Avenue, NYC
Aug 6: 10:00am–5:00pm$20910185 Madison Avenue, NYC
Aug 7, Aug 8: 6:00pm–9:00pm$20910185 Madison Avenue, NYC
Aug 16: 10:00am–5:00pm$20910185 Madison Avenue, NYC
Aug 29: 10:00am–5:00pm$20910185 Madison Avenue, NYC
Sep 5, Sep 6: 6:00pm–9:00pm$20910185 Madison Avenue, NYC
Sep 14: 10:00am–5:00pm$20910185 Madison Avenue, NYC
Sep 15: 10:00am–5:00pm$20910185 Madison Avenue, NYC
Sep 28: 10:00am–5:00pm$20910185 Madison Avenue, NYC
Oct 3, Oct 4: 6:00pm–9:00pm$20910185 Madison Avenue, NYC
Show more

Call 212.658.1918 or email us

Advanced Excel Classes New York City

Hands-on Advanced Excel Training Courses

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.

Why Learn Advanced Excel at NYIM?

  • 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 Advanced Excel video suite, with lifetime access to several hours of premium content, a $95 value, included free. 
  • 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
  • This advanced Excel class comes with a Free Retake within six months of the class.

Advanced Excel Class

Rated the Best Advanced 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 Excel Course Outline

Advanced Excel 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 criteria
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 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. 9/27- Alexandria A. attended Advanced Excel for Business