Advanced Excel for Business is unfortunately unavailable

Thankfully we have 2 other Excel Classes for you to choose from. Check our top choices below or see all classes for more options.

Advanced Excel for Business

at NYIM Training - Midtown

Course Details
Start Date:

This class isn't on the schedule at the moment, but save it to your Wish List to find out when it comes back!
If you're enrolled in an upcoming date, this simply means that date has now sold out.

Midtown, Manhattan
185 Madison Ave 3rd Floor
At 34th St
New York, New York 10016
Purchase Options
Save to WishList

197 people saved this class

Book Private Class
Class Level: Advanced
Age Requirements: 18 and older
Average Class Size: 10

Flexible Reschedule Policy: This provider has flexible, free rescheduling for any-in person workshop. Please see the cancellation policy for more details

What you'll learn in this excel class:

Master advanced Excel techniques in this hands-on training. Learn how to use the more advanced tools in Excel like What-If Analysis, INDEX-MATCH, macros, and more.

Advance your career with this essential course for professionals that use Excel daily. You'll make functions more flexible, take Pivot Tables to the next level, and automate tasks with macros. Utilize Excel's most important tools with training in core database functions. If you have strong working knowledge in Excel and want to save even more time with custom shortcuts and advanced features, this is the perfect course for you.

Attendees must have Excel proficiency equivalent to our Intermediate Excel course, including VLOOKUP, Pivot Tables, and IF statements.

What You'll Learn

  • What-if Analysis: Goal Seek & Data Tables
  • Advanced cell locking
  • Create more flexible lookup functions with INDEX-MATCH
  • Advanced Pivot Table techniques
  • Record relative and absolute macros
  • Advanced nested functions
  • Work without a mouse using Hot Keys

Full Course Syllabus

Cell Management
  • Advanced Cell Locking
  • Hot Keys
  • Windows
  • Cell Auditing
Special Formatting
  • Date functions
  • Conditional Formatting-Formulas
Advanced Functions
  • Nested IF statements
  • IF statements with AND/OR
What If Analysis
  • Goal Seek
  • Data Tables
Advanced Analytical Tools
  • Data Consolidation
  • Conditional SumProduct
  • Pivot Table-Calculations
  • Pivot Charts
Advanced Database Functions
  • MATCH function
  • INDEX-Double MATCH
Introduction to Macros
  • Recording Macros
  • Relative Macros
End of Class Project
  • Project

Still have questions? Ask the community.

Refund Policy

Note: This provider has a temporary cancellation policy for COVID-19 related cancellations which is as follows: 

We are allowing attendees to reschedule at no charge or keep class credit for up to two years. Email us at [email protected] 


Original cancellation policy (non-COVID-19):

  • Registration Fee: All courses include a non-refundable registration fee of 10%.
  • Cancellations: Students may cancel up to seven business days prior to the course and receive all monies paid, less the non-refundable registration fee. Cancellation requests within the policy should be made directly to CourseHorse.
  • Rescheduling: Students may reschedule once up to three business days prior to the start date of the course at no charge. Reschedules within three business days incur a $20 rescheduling fee. Reschedule requests should be emailed to [email protected]


Google Map

NYIM Training

All classes at this location

Start Dates (0)

This class isn't on the schedule at the moment, but save it to your Wish List to find out when it comes back!

Similar Classes

Benefits of Booking Through CourseHorse

Booking is safe. When you book with us your details are protected by a secure connection.
Lowest price guaranteed. Classes on CourseHorse are never marked up.
This class will earn you 2190 points. Points give you money off your next class!
Questions about this class?
Get help now from a knowledge expert!
Questions & Answers (1)

Get quick answers from CourseHorse and past students.

Question from Janice D.
Do you get a certificate after completing this course?
Answer from Brenda L. CourseHorse StaffCourseHorse Staff
Hi Janice! Yes. Each student who completes a course will receive a certificate of completion. Hope this helps!

Reviews of Classes at NYIM Training (739)

(739 Reviews)
Advanced Excel for Business
Reviewed by Anonymous on 4/3/2019
Michael was a great professor. Kept us on track to go through every subject on the agenda and allowed space for questions along the way.
Advanced Excel for Business
Reviewed by Ariel O. on 11/29/2018
Great teacher! She was really helpful and moved at a solid pace. Answered all questions super well. She made the class.
Advanced Excel for Business
Reviewed by Oksana B. on 11/1/2018
Garfield is the best instructor. Took him twice for different Exel classes.
Advanced Excel for Business
Reviewed by Anonymous on 4/9/2018
The course was structured well and the content was very applicable to a business setting, however, I don't think it should be labelled as 'advanced', but rather Intermediate pt.2. Additionally the instructor didn't seem entirely confident teaching the content, and we moved extremely slowly through each segment due to mistakes she made (which participants taking the class had to correct her on regularly). Because of this, we were not even able to complete the final project exercise, which I was looking forward to...
Advanced Excel for Business
Reviewed by alex l. on 2/14/2018
Michael followed the syllabus well and class was knowledgeable, which helped with the fast pace we set throughout the day. Thanks Michael for a job well done.

School: NYIM Training

NYIM Training

For nearly two decades, NYIM has trained thousands of business professionals in the latest computer software programs, including Excel, Financial Modeling, Microsoft Office, Adobe, SQL, AutoCAD, QuickBooks, and many more.  

The company is known for its practical and hands-on approach to its...

Read more about NYIM Training

CourseHorse Approved

This school has been carefully vetted by CourseHorse and is a verified NYC educator.

Want to take this class?

Save to Wish List
Booking this class for a group? Find great private group events here

2 Top Choices

Microsoft Excel Essentials

at Technical Institute of America - Hell's Kitchen 545 8th Ave 4th Fl, New York, New York 10018

This live instructor-led hands-on course will cover basic to intermediate topics in Excel. All students will be given a computer to follow along and a custom training manual with all the steps and description of Excel functions. The topics covered in this course can be applied to Excel 2007, 2010, 2013, 2016 & 2019. This course is great for someone...

Sunday Aug 21st, 10am - 6pm Eastern Time

Excel Data Analysis Training

at Learning Tree International - Midtown 1601 Broadway 9th Fl, New York, New York 10019

This hands-on Excel data analysis training course will expand your ability to analyze large amounts of data and professionally present your results. Gain the knowledge and skills to build more sophisticated spreadsheets, perform What-If analyses, apply functions, manipulate PivotTables, and use the advanced features of Excel to make and present better...

Monday Oct 3rd, 9am - 4:30pm Eastern Time

  (2 sessions)

2 sessions