Discover Classes. Earn Rewards.

Advanced Excel for Business

Enhance your Excel skills with hands-on training in advanced techniques like What-If Analysis, INDEX-MATCH, and macros. Take your career to the next level with this essential course for professionals who use Excel daily. Save time and increase efficiency with custom shortcuts and advanced features.

  • Advanced
  • 18 and older
  • $249
  • 185 Madison Ave, New York, NY & Virtually Online

Start Dates (22)

  • $249
  • NYIM @ 185 Madison Ave 3rd Floor, New York, NY 10016
20 seats left
Book
20 seats left
Book
20 seats left
Book
Show all 2 sessions
  • Thu, May 02 at 6:00pm - 9:00pm
  • Tue, May 07 at 6:00pm - 9:00pm
20 seats left
Book
20 seats left
Book
Showing 15 of 22

Class Description

Description

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.

Prerequisite:

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

What You’ll Learn at a Glance

  • 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

  • Advanced Navigation
    • Advanced Navigation
    • Fill Review
  • Cell Management
    • Advanced Cell Locking
    • Hot Keys
    • Cell Auditing
    • Go To Special
  • Special Formatting
    • Conditional Formatting-Formulas
    • Date Functions
    • Custom Number Formats
  • Advanced Functions
    • Nested IF statements
    • IF statements with AND/OR
  • What If Analysis
    • Goal Seek
    • Data Tables
  • Advanced Analytical Tools
    • Calculation Options
    • Conditional SumProduct
    • Pivot Table-Base Fields & Sets
    • Pivot Table-Calculations
    • Pivot Charts
  • Advanced Database Functions
    • XMATCH function
    • INDEX-MATCH
    • INDEX-Double MATCH
  • Introduction to Macros
    • Recording Macros
  • Dynamic Arrays
    • Dynamic Arrays
  • End of Class Projects
    • Projects

Learn more about Advanced Excel for Business at NYIM Training

Refund Policy

  • Students may cancel up to 11 business days before the class/program start date and receive a refund, less the registration fee (10% of the undiscounted course price).
  • Cancellations within 11 business days are not permitted, but students may reschedule up to 4 business days before the class start date.

For cancellations and reschedules, please email us at [email protected]

Reviews of Classes at NYIM Training (742)

(4.5-star rating across 742 reviews)
  • Advanced Excel for Business

    Anonymous review 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

    Anonymous review 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.
  • Advanced Excel for Business

    Anonymous review on 1/31/2018
    great class. pace at times can be a little too fast. (a few more pauses would help)
  • Advanced Excel for Business

    Reviewed by Tracy T. on 3/16/2016
    I attended the one day Advanced Excel Power Users Level 3 course taught by Karen M. and it was amazing! I have used Excel for over 10 years while working in financial services, yet was never formally taught the application. So while I have used vlookups, hlookups, pivot tables and various functions to analyze large sets of data I was still hesitant to attend this class fearing it would be too advanced. So glad I decided to sign up - the pace of the course was perfect. Karen explained things in a way that made it easy to understand and follow along. I liked how she would continue to repeat the "quick tips" so they would stick in your head and by end of day you were using them to work thru the application. This is a great course for someone who is very familiar with Excel but wants to learn how to use Excel more effectively & efficiently to analyze large sets of data (e.g, nesting of functions, indexing, recording & editing macros, functions other than the typical SUMIF, etc.). Great course and would definitely recommend.
  • Advanced Excel for Business

    Reviewed by Amanda K. on 11/20/2015
    Karen was great. She was very patient and knowledgable. I really learned a lot
  • Advanced Excel for Business

    Anonymous review on 8/4/2015
    Very knowledgeable instructor.To give you a better idea the following was covered in this class: min, max, sum, offset, count, absolute, conditional formatting, importing data from website, text to column, find, iferror, consolidate, left, right, concatenate, mid, replace, dates match index, indirect, pmt, arrays, overview of macros,
  • Advanced Excel for Business

    Reviewed by Amanda Toland on 3/20/2014
    I thought this class was a wonderful overview of ways to improve your efficiency in using excel and touched upon some Macros and match index examples at the end. The teacher was good and it was only me and one other person so we were able to ask a lot of questions.
  • Advanced Excel for Business

    Reviewed by Catherine C. on 5/18/2020
  • Advanced Excel for Business

    Anonymous review on 6/26/2019
  • Advanced Excel for Business

    Anonymous review on 2/3/2019
  • Advanced Excel for Business

    Reviewed by Tsering D. on 10/1/2018
  • Advanced Excel for Business

    Anonymous review on 5/12/2018
See 3 More Course Reviews
loading...
See reviews for other classes at NYIM Training
loading...
Hide Reviews

Review Summary by CourseHorse

Students who took classes at Advanced Excel for Business praised the professors for keeping the classes on track and being helpful. Overall, students felt that they learned valuable skills that applied to a business setting. In terms of specific skills, students mentioned learning functions such as min, max, sum, offset, count, absolute, and conditional formatting. They also learned about importing data from websites, text-to-column conversion, use of IFERROR, consolidating data, and using various date functions. Some students were pleasantly surprised by the pace of the course and found it helpful for improving their efficiency in using Excel. Direct quotes from reviews: 1. "I have used Excel for over 10 years while working in financial services, yet was never formally taught the application. So glad I decided to sign up - the pace of the course was perfect." 2. "Karen explained things in a way that made it easy to understand and follow along. This is a great course for someone who is very familiar with Excel but wants to learn how to use Excel more effectively & efficiently to analyze large sets of data." 3. "The teacher was good and it was only me and one other person so we were able to ask a lot of questions."

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!
Answer Show answer
Cancel

Similar Classes

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 instructor-led...

Read more about NYIM Training

CourseHorse Approved

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

NYIM Training

NYIM Training

All classes at this location

We are located in New York City on 34th street and Madison Avenue, a few blocks from Penn Station, Port Authority and Times Square. You may also attend this class live online (virtual training) via Zoom. We will reach out with additional information, including the Zoom info and class files.

Also available virtually online

Google Map

Give This Course as a Gift Card

  • Thousands of classes
  • No expiration
  • Unique and memorable gifts for any occasion
  • Personalized
  • Explore a passion, gain a new skill, discover a new hobby, engage in a memorable experience
  • Instant delivery
  • Lock in a price with the Inflation Buster Gift Card Price Adjuster™

Buy a Gift Card

Book this Class as a Group Event

Booking this class for a group? Find great private group events

Or see all Excel Group Events

Explore group events and team building activities ranging from cooking, art, escape rooms, trivia, and more.

CourseHorse Gift Cards

  • Creative & unique gift for any occasion
  • Thousands of classes & experiences
  • No expiration date
  • Instant e-delivery (or choose a date)
  • Add a personalized message
  • Lock in a price with the Inflation Buster Gift Card Price Adjuster™
Buy a Gift Card
gift card with the CourseHorse logo gift card with the CourseHorse logo
Loading...