Advanced Excel Classes NYC: Advanced Functions, Sensitivity Analysis, Macros & 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.

This course is part of our Excel Bootcamp. Enroll in our three-course package and save 15%.

Class Note: A PC or Mac will be provided for use during class. The instructor will present on a PC but will explain the differences for Mac students.

Bonus Video Training Included

In addition to 7 Hours of live training (in-person or remote), you'll receive lifetime access to self-paced training videos, a $95 value.

This course has a prerequisite

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

Learn the Skills Guarantee™

Hands-on training in small groups

Work on projects proven to boost retention
Time-tested curriculum and supporting materials

Refined over many cohorts for an optimal learning experience
Learn from industry experts with teaching experience

Experienced educators who are driven to help you succeed
Retake the course for free within one year

Refresh the materials and gain additional practice

Learn the concepts and skills covered in this course or your tuition is on us. See details and terms & conditions.

Great class! The content was well organized and the instructor was excellent.
— Rebecca H.

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

Course Syllabus

Download Syllabus PDF

Cell Management

Advanced Cell Locking

Create powerful formulas by locking either the column or the row

Hot Keys

Transform the ribbon into a visual listing of pre-assigned shortcuts

Windows

Techniques and keyboard shortcuts to allow editing of active windows

Cell Auditing

Observe the relationship between formulas and cells

Special Formatting

Date functions

Calculate dates with a variety of functions

Conditional Formatting-Formulas

Create custom rules for Conditional Formatting with formulas

Advanced Functions

Nested IF statements

Nested "IF" statements allow for more than just two possibilities in a single cell

IF statements with AND/OR

Expand the functionality of the IF function by adding an AND / OR criteria

What If Analysis

Goal Seek

Find the desired result by adjusting an input value

Data Tables

Data Tables show the range of effects of one or two different variables on a formula

Advanced Analytical Tools

Data Consolidation

Summarize data from separate ranges and consolidate into a specified output range

Conditional SumProduct

Use SumProduct with conditions to exclude data that does not meet certain criteria

Pivot Table-Calculations

Create calculated rows or columns in a Pivot Table that go beyond the source data

Pivot Charts

Create dynamic, graphical representations of Pivot Table data

Advanced Database Functions

MATCH function

Return the relative position (column or row number) of a lookup value

VLOOKUP-MATCH

Create a more accurate VLOOKUP by enhancing the determination of the Column Index number

INDEX-MATCH

Efficiently return a value or reference from a cell at the intersection of the row and column

INDEX-Double MATCH

Use a second Match function to create a powerful, two-way lookup tool

Introduction to Macros

Recording Macros

Record Macros that involve formatting and calculations

Relative Macros

Record relative reference macros for ad-hoc reporting

End of Class Project

Project

End of class project to review key concepts from the class

Schedule & Enrollment: Advanced Excel for Business

$229
7 Hours
NYC or Live Online
Free retake
Setup assistance
Expert instructors
Small classes

Policies

Course times are listed in Eastern Time.

Filter

September 26

Sunday 10–5pm

Registration closing soon
Enroll
October 1

Friday 10–5pm

Registration closing soon
Enroll
October 13

Wednesday 10–5pm

Enroll
October 20–21

Wednesday to Thursday 6–9pm

Enroll
October 25

Monday 10–5pm

Enroll
November 4

Thursday 10–5pm

Enroll
November 13

Saturday 10–5pm

Enroll
November 16

Tuesday 10–5pm

Enroll
December 2

Thursday 10–5pm

Enroll
December 13–14

Monday to Tuesday 6–9pm

Enroll
December 14

Tuesday 10–5pm

Enroll
December 19

Sunday 10–5pm

Enroll
December 23

Thursday 10–5pm

Enroll
January 7

Friday 10–5pm

Enroll

Show more dates

This Course is Available in NYC or Live Online

On Campus in NYC

185 Madison Ave, NYC

Get face-to-face interaction with an instructor and other students when you learn at our NYC campus. Courses are hands-on with a computer and software provided.

Live, interactive class
Experienced instructor in the room with you
Computer and software provided
Free retake within one year

Instructor writing on markerboard in a classroom, while displaying code sample on screen

Students seated in computer classroom with workbooks, paying attention to instructor

Live Online

Remote, from anywhere

Get the same interactivity and access to the instructor as in-person students. There are no extra fees and we’ll work with you to ensure your remote setup is perfect.

Live, interactive class
Experienced instructor teaching over Zoom
Remote setup assistance provided
Free retake within one year

Online Training Demo

1-Minute Overview

Testimonials for Live Online Training

“Overall experience on Zoom was maybe even better than in IRL classroom because the instruction takes place right on your own screen, with less distraction. Great overall experience.”
“Given the fact that we had to do this entire class remotely due to Covid-19, I didn’t have very high expectations it would run so smoothly. However, I don’t think it could’ve gone any better. Not only do I feel very comfortable with the program now, but I’m actually excited to use it!”
“This was the first online class I’ve taken with ND and it was a great experience. Looking forward to the other classes I’ve signed up for!”

More about live online training

Frequently Asked Questions

What’s included with my tuition?
- A hands-on learning experience working on projects and exercises, which is proven to boost comprehension, retention, and engagement
- Expert instructors who are industry professionals and experienced educators that are driven to help you succeed
- Top-notch curricula that have been tried and tested over many cohorts and are consistently improved for an optimal learning experience
- Supplemental materials to assist both during and after the course - please refer to specific course pages to see what supplemental materials are offered
- A 1-year free retake policy which allows students to retake any part of the course or program for free to refresh the materials and gain additional practice
- A certificate of completion to verify your accomplishment
Does this course require any prior knowledge or experience?

Attendees must have Excel proficiency equivalent to our Intermediate Excel course, including VLOOKUP, Pivot Tables, and IF statements.
Do you offer any discounts for this course?
Discounts

We don’t currently offer discounts as we do our best to affordably prices our courses.

Take this course as part of a certificate program and save:
- Excel for Business Bootcamp
  
  Price: $549 | Hours: 21 Hours
- Excel Specialist Certification Program
  
  Price: $899 | Hours: 24 Hours
- Microsoft Master Certification Program with Access
  
  Price: $2,699 | Hours: 73 Hours
- Business Analyst Certificate
  
  Price: $1,995 | Hours: 65 Hours
- Microsoft Master Certification Program with Outlook
  
  Price: $2,499 | Hours: 66 Hours
- Excel Expert Certification Program
  
  Price: $1,099 | Hours: 26 Hours
- Data Analytics Bootcamp
  
  Price: $1,949 | Hours: 60 Hours
- Complete Microsoft Office Bootcamp
  
  Price: $1,725 | Hours: 54 Hours
- Microsoft Office Intermediate Bootcamp
  
  Price: $949 | Hours: 35 Hours
Are there any additional fees or expenses?

There are no extra fees or taxes for our courses. The price you see on this page is the maximum you’ll pay us.

However, if you plan to take the course live online, you may need to obtain required software. We’ll help you get set up with a free trial of paid software prior to the class. Most of our coding classes utilize freely-available open-source software. For most of our design and motion graphics courses, we will help you get set up with a free trial of Adobe Creative Cloud. If you attend the course in-person, we will have a computer already set up for you with all of the required software for no additional cost.
Do you offer payment plans or student financing for this course?

This course does not qualify for payments plans or student financing. See our Payment Plan FAQ to find related programs that qualify.
Can I take this course online (remote learning)?
You may attend this training virtually (online) at the scheduled time the course is offered (New York, Eastern Time).

How does attending “live online” work?
- Students can attend this training remotely through screen sharing software (we use Zoom).
- Participants can hear the instruction, ask questions, and even share their screen with the instructor.
- For audio you can use your computer’s microphone/speakers or call a phone number that we’ll provide.
- Classes are activity-based and taught by a live instructor, so we strongly encourage students who are local to the area to attend in person!
- You will need your own computer and copy of any required software. If you don’t have the software, you can usually do a free trial or purchase your own license. If you need assistance, contact us at contact@nyimtraining.com

Corporate & Onsite Training

Purchase group class vouchers at a discount for our regularly-scheduled group classes in NYC, or create a custom training program at your offices.

Private Training

Available onsite at your location
Modern computer labs available at our offices
Customize or choose from our existing courses
Free instructor consultations to finalize content

Group Class Vouchers

Send employees to our group classes
Extensive offerings and flexible scheduling
Simple billing and logistics
Computers and training resources provided

Why Learn at NYIM

Highly Reviewed by Our Alumni

From our hands-on training style to world-class instructors and proprietary curriculum, we deliver a learning experience our alumni can be proud of.

20 Students Rated Our Advanced Excel for Business 5 Stars

Great teacher! She was really helpful and moved at a solid pace. Answered all questions super well. She made the class.

Ariel O.

A class was very helpful and the instructor made it worthwhile. Took the two-night excel class and will be back for powerpoint.

Tommy M.

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.

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.

The overall experience was great. I feel the instructor was well educated on the tools I needed in order to succeed in my current role. I would rate the preparation, use of time, knowledge of material and general kindness as one of the best training classes/sessions that I have ever attended. I have and will continue to recommend the folks at NYIM to others.

K. Burton of Microsoft

Patrick was extremely detailed and gave students time to keep up with understanding the work.

Quinn B., NYC DDC

If you need a refresher course or if you need to brush up or learn, this is the place to learn.

Eugene P., Columbia University

Great way to learn more advanced functions of working with data in spreadsheets, easy to follow and a ton of information. You even get a workbook to follow along, enhancing the experience and creating a paper trail/reference sheet.

Mark V., Neuberger Berman

I highly recommend this class - the instructor managed to teach for 6 hours on zoom while perfectly explaining every single element at a perfect pace for everyone and was very attentive and had full expertise on all of Excel's functions.

Lyubitsa G., Lukoil

This was an extremely helpful course and I'll be able to use so much of what we reviewed in my day to day at work. I'm excited to be able to re watch parts of the lessons through the recording as well! Once I master this, I'm definitely interested in the Macros class.

Kaitie O., Natixis

I learned a number of functions and procedures in Excel that will allow me to be more productive and more efficient with my daily tasks.

Bruce T., Dabur Limited

Great for business people looking to use advanced Excel features to improve productivity at work.

Melissa G., Industrial Communications

If you need to use Excel at work, this class will make your life easier and efficient.

Stella A.

An engaging, informative perfect way to learn or refresh your skills!

Ellen F., AgeWell New York

Never in a million years would've thought that an Excel training workshop would actually be enjoyable!

Aaron B., Kipp NYC

Love this class. Can use what I've learned at work.

Maricruz M., UJCHASC

Very good class. Trainer was very good, very patient.

Pierre M., Agewell New York

This was a great class, even if you know excel there are formulas/functions that can give you faster results then what you are doing now.

Stephy V., Agewell

I definitely recommend this course for professional development in any field where MS Excel is used.

Touhidul C., Mayor's Office of Immigrant Affairs

In this course, I learned a lot about Excel that I didn't know previously. I would certainly recommend it to those looking to learn more about the software.

Ryan Z.

Advanced Excel Classes NYC

Hands-on Advanced Excel Training Courses in NYC

Are you an Excel power user with knowledge of Pivot Tables and VLOOKUP? Do you use Excel daily for work and professional needs? If so, NYIM’s Advanced Excel Course will help you take your skills to the next level. In the advanced Microsoft Excel course, you will learn how to:

Apply pre-assigned shortcuts to accelerate your workflow
Build upon your knowledge of Pivot Tables with Pivot Charts
Implement the MATCH function with VLOOKUP and INDEX
Automate formatting and calculations tasks with macros

In Advanced Excel for Business, you’ll learn automation and shortcut techniques to apply to Excel’s most advanced features like Pivot Tables. The course includes training on recording macros to perform repetitive Excel tasks in a single click. At the end of the course, you’ll complete a course project that you can demo to current and prospective employers to demonstrate your new skill set.

More Advanced Excel Classes at NYIM

Our advanced classes are perfect for those with knowledge of basic techniques including formatting, charts, basic formulas and functions, and absolute cell references, as well as intermediate-level concepts, including VLOOKUP, Pivot Tables, and intermediated functions such as SUMIFS and IF. For more information on the required prerequisite knowledge, see our Excel Fundamentals and Intermediate Excel course pages.

Don’t quite meet the prerequisites but want to become an advanced Excel user? Did you forget how to use core Excel functions like Pivot Tables and VLOOKUP? Get a refresher on Microsoft Excel functions and gain master Advanced Excel in our Excel bootcamp. The Advanced MS Excel 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!

Which Advanced Excel course should I take?

We offer a handful of advanced Excel courses to suit different needs.

Advanced Excel for Business builds off Intermediate Excel and teaches the advanced Excel features most commonly used by business professions today. Make your lookup functions more flexible by adding MATCH to VLOOKUP and using INDEX and MATCH together; expand Pivot Tables with Pivot Charts and other advanced features; create nested functions including nested IFS and IF with AND/OR; utilize advanced analytical tools; and write basic macros with the macro recorder to automate repetitive tasks.
For those looking to further automate tasks and create custom commands, enroll in our Excel Programming with VBA course. This two-day bootcamp covers the essentials of Excel’s programming language.
Working in finance or starting a position as a financial analyst? We offer two advanced Excel courses, Advanced Excel for Finance and our Financial Modeling Bootcamp.

Advanced Excel Classes in NYC + Free Training Videos

Gain real-world value that you can apply on the job
Reinforce learning with practice exercises after each course section
Solidify your new skills with a cumulative project at the end of class
Get free access to our premium Advanced Excel video suite
Retake the course free within six months

Bonus Video Training Included

This course has a prerequisite

Learn the Skills Guarantee™

Hands-on training in small groups

Time-tested curriculum and supporting materials

Learn from industry experts with teaching experience

Retake the course for free within one year

Earn a Certificate of Completion

What You’ll Learn

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

VLOOKUP-MATCH

INDEX-MATCH

INDEX-Double MATCH

Introduction to Macros

Recording Macros

Relative Macros

End of Class Project

Project

Schedule & Enrollment: Advanced Excel for Business

September 26 Sunday 10–5pm Registration closing soon Enroll

October 1 Friday 10–5pm Registration closing soon Enroll

October 13 Wednesday 10–5pm Enroll

October 20–21 Wednesday to Thursday 6–9pm Enroll

October 25 Monday 10–5pm Enroll

November 4 Thursday 10–5pm Enroll

November 13 Saturday 10–5pm Enroll

November 16 Tuesday 10–5pm Enroll

December 2 Thursday 10–5pm Enroll

December 13–14 Monday to Tuesday 6–9pm Enroll

December 14 Tuesday 10–5pm Enroll

December 19 Sunday 10–5pm Enroll

December 23 Thursday 10–5pm Enroll

January 7 Friday 10–5pm Enroll

October 1 Friday 10–5pm Registration closing soon Enroll

October 13 Wednesday 10–5pm Enroll

October 25 Monday 10–5pm Enroll

November 4 Thursday 10–5pm Enroll

November 16 Tuesday 10–5pm Enroll

December 2 Thursday 10–5pm Enroll

December 14 Tuesday 10–5pm Enroll

December 23 Thursday 10–5pm Enroll

January 7 Friday 10–5pm Enroll

October 20–21 Wednesday to Thursday 6–9pm Enroll

December 13–14 Monday to Tuesday 6–9pm Enroll

September 26 Sunday 10–5pm Registration closing soon Enroll

November 13 Saturday 10–5pm Enroll

December 19 Sunday 10–5pm Enroll

This Course is Available in NYC or Live Online

On Campus in NYC

Live Online

Online Training Demo

Testimonials for Live Online Training

Frequently Asked Questions

What’s included with my tuition?

Does this course require any prior knowledge or experience?

Do you offer any discounts for this course?

Discounts

Take this course as part of a certificate program and save:

Are there any additional fees or expenses?

September 26

Sunday 10–5pm

Registration closing soon
Enroll

October 1

Friday 10–5pm

Registration closing soon
Enroll

October 13

Wednesday 10–5pm

Enroll

October 20–21

Wednesday to Thursday 6–9pm

Enroll

October 25

Monday 10–5pm

Enroll

November 4

Thursday 10–5pm

Enroll

November 13

Saturday 10–5pm

Enroll

November 16

Tuesday 10–5pm

Enroll

December 2

Thursday 10–5pm

Enroll

December 13–14

Monday to Tuesday 6–9pm

Enroll

December 14

Tuesday 10–5pm

Enroll

December 19

Sunday 10–5pm

Enroll

December 23

Thursday 10–5pm

Enroll

January 7

Friday 10–5pm

Enroll