Advanced Excel for Business is unfortunately unavailable

Thankfully we have 76 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

(748)
Course Details
Price:
$219
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.

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

194 people saved this class

Book Private Class
Description
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
  • VLOOKUP-MATCH
  • INDEX-MATCH
  • INDEX-Double MATCH
Introduction to Macros
  • Recording Macros
  • Relative Macros
End of Class Project
  • Project


Remote Learning

This course is available for "remote" learning and will be available to anyone with access to an internet device with a microphone (this includes most models of computers, tablets). Classes will take place with a "Live" instructor at the date/times listed below.

Upon registration, the instructor will send along additional information about how to log-on and participate in the class.

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]

Map

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

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.
loading...
loading...

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

76 Top Choices

Excel Bootcamp

This class is temporarily being offered remotely.

at General Assembly - Online Online Class
Livestream, New York, New York 00000

The bootcamp is designed to provide students with a general overview of Excel topics and specifically more knowledge of several different functions. It combines most of the material from the two workshops into an intense one-day session. Given the short timeframe and large amount of topics covered, students are expected to be able to learn quickly....

Friday Mar 12th, 11am - 5pm Eastern Time

Excel at Excel: Getting Down the Basics

This class is temporarily being offered remotely.

at General Assembly - Online Online Class
Livestream, New York, New York 00000

The Excel at Excel workshop is designed for students who are relatively familiar with other office productivity software, for example, Microsoft Word. (The students who succeed the most are comfortable using a computer and navigating around desktop programs on their own). It introduces a range of Excel topics giving students a taste of the potential...

Sunday Mar 28th, 12pm - 3pm Eastern Time

Excel at Excel: Getting Down to the Basics

This class is temporarily being offered remotely.

at General Assembly - Online Online Classroom, Los Angeles, California 00000

The Excel at Excel workshop is designed for students who are relatively familiar with other office productivity software, for example Microsoft Word. (The students who succeed the most are comfortable using a computer and navigating around desktop programs on their own). It introduces a range of Excel topics giving students a taste of the potential...

Sunday Mar 28th, 9am - 12pm Pacific Time

Excel Bootcamp

This class is temporarily being offered remotely.

at General Assembly - Online Online Class Livestream, Online, Massachusetts 00000

If you know the basics of Microsoft Excel and want to take your knowledge to the next level, then this hands-on bootcamp is for you. Whether you are in business, management, or simply interested in getting more organized, this Excel bootcamp will cover the tools and functions you need to automate or enhance the way you analyze and restructure your...

Saturday Mar 6th, 1pm - 7pm Eastern Time

Introduction to Excel - Learn Basics

This class is temporarily being offered remotely.

at Chicago Computer Classes - Online Online, Chicago, Illinois 00000

Learn how to build basics spreadsheets & get comfortable using Microsoft Excel in working environment. This workshop is best suited for those who have very little or no experience with Microsoft Excel. Workshop Includes: Overview Of Microsoft Excel User Interface Working with Workbook Working with Worksheets Working With Worksheet Tabs ...

Tuesday Mar 2nd, 8:30am - 12:15pm Central Time

$164.98

Advanced Excel Training

This class is temporarily being offered remotely.

at General Assembly - Online Online Class, Houston, Texas 00000

Virtually everyone who works with data could benefit by gaining a better understanding of Microsoft Excel. This class will extend beyond the simple addition of data and will put participants in a position where Excel is no longer a chore, but a powerful tool to assist in manipulating data efficiently. You’ll learn various functions to help you organize...

Sunday Feb 28th, 8pm - 11pm Central Time

Advanced Excel Training

This class is temporarily being offered remotely.

at General Assembly - Online Online Class Livestream, Atlanta, Georgia 00000

Virtually everyone who works with data could benefit by gaining a better understanding of Microsoft Excel. This class will extend beyond the simple addition of data and will put participants in a position where Excel is no longer a chore, but a powerful tool to assist in manipulating data efficiently. You’ll learn various functions to help you organize...

Sunday Feb 28th, 9pm - 11:55pm Eastern Time

Mastering Excel – Advanced

This class is temporarily being offered remotely.

at Chicago Computer Classes - Online Online, Chicago, Illinois 00000

WorkShop Includes:  Logical Test  IF, AND, OR Functions  SUMIFS Function  INDEX & MATCH Merge Data with INDEX, MATCH Functions Text Manipulation and Cleaning Data  Date Function Table Objects

Wednesday Mar 3rd, 8:30am - 12:15pm Central Time

$219.99

Excel VBA Macros: Write Custom Excel Macros in VBA

This class is temporarily being offered remotely.

at Accelerate Computer Training - Long Beach 200 Pine Ave Ste 280, Long Beach, California 90802

Learn to create automated custom Excel applications using VBA. This two-day VBA Programming course helps advanced Excel users (Windows only) develop new skills writing and debugging powerful VBA code to automate workbook operations, create interactive forms, insert calculations and handle run-time errors. Prerequisites: This class is ideally suited...

Thursday Mar 4th, 9am - 4pm Pacific Time

  (2 sessions)
$895

2 sessions

Mastering Excel - Intermediate

This class is temporarily being offered remotely.

at Chicago Computer Classes - Online Online, Chicago, Illinois 00000

WorkShop Includes: Filters, SUBTOTAL VLOOKUP Merge Data with Lookup Functions Error Handling Tables Pivot Tables Must-Know Keyboard Shortcuts Workshop is led by an Excel Power User/Excel VBA Developer/Data Driven Application Developer. We recommend having a USB flash drive if you want to keep your work files after class. They serve as a great...

Tuesday Mar 2nd, 1pm - 4:30pm Central Time

$164.99

Excel Advanced 1: Automating Tasks

This class is temporarily being offered remotely.

at Accelerate Computer Training - Long Beach 200 Pine Ave Ste 280, Long Beach, California 90802

In this three-hour session for Windows and Mac users, you will learn how to work on multiple worksheets simultaneously, how to set up what-if analyses models using Goal Seek, Scenario Manager and one- and two-input data tables. You will also learn how to record and edit simple macros. Prerequisites This class is ideally suited for people who have taken...

Wednesday Mar 3rd, 9am - 12pm Pacific Time

Excel Advanced 2: Advanced Formulas

This class is temporarily being offered remotely.

at Accelerate Computer Training - Long Beach 200 Pine Ave Ste 280, Long Beach, California 90802

In this three-hour session for Windows and Mac users, you will learn to write complex formulas using Excel's built-in functions and array formulas. You will expand your library of functions to include financial, text parsing, logical, lookup and database functions. You will also learn to write array formulas, which are capable of performing multiple...

Wednesday Mar 3rd, 1pm - 4pm Pacific Time

Excel PivotTables: Data Summarization and Analysis

This class is temporarily being offered remotely.

at Accelerate Computer Training - Long Beach 200 Pine Ave Ste 280, Long Beach, California 90802

A PivotTable is Excel's most powerful data summarization tool. In this three-hour session for Windows and Mac users, you will learn what kinds of data works best for PivotTables and how to prepare your data. You will create PivotTables based on various data sources, summarize data by multiple categories using sum, average and count, format the PivotTable,...

Saturday Mar 6th, 9am - 12pm Pacific Time

Excel 2016: Intermediate

This class is temporarily being offered remotely.

at Baruch College - CAPS - Online 00000

This course builds on the fundamentals in the Excel 2016 Basic course. In this class, you will create financial outlines and subtotals, create and manage cell range names, as well as create and modify column and pie charts. Sorting, filtering and calculations using calendar date functions will be covered as well as Pivot tables and charts. You'll also...

Wednesday Mar 3rd, 6:15pm - 8:35pm Eastern Time

  (3 sessions)
$265

3 sessions

Advanced Excel Training

This class is temporarily being offered remotely.

at General Assembly - Online Online Class
Livestream, New York, New York 00000

Virtually everyone who works with data could benefit by gaining a better understanding of Microsoft Excel. This class will extend beyond the simple addition of data and will put participants in a position where Excel is no longer a chore, but a powerful tool to assist in manipulating data efficiently. You’ll learn various functions to help you organize...

Saturday Mar 20th, 12pm - 3pm Eastern Time

Excel Workbooks, Formulas and Functions

This class is temporarily being offered remotely.

at ONLC Training Centers - Online Virtual Classroom, New York, New York 00000

Learn the essentials managing large worksheets, creating models, and working financial, date, and logical functions. Target Student The course is for individuals who are responsible for managing and creating large worksheets and models in Excel. Prerequisites Excel Introduction or equivalent skills. Course Outline Working with Workbooks Viewing,...

Thursday Mar 4th, 10am - 4:45pm Eastern Time

Microsoft BI Tools: Power BI for Excel Users

This class is temporarily being offered remotely.

at ONLC Training Centers - Online Virtual Classroom, New York, New York 00000

The main purpose of the course is to review the essential skills needed to take data from Excel into Power BI then transform and shape the data, model the data, create reports, then publish the reports on the Power BI cloud service. Audience profile: The course is individuals who are not IT professionals but need to easily create and publish...

Thursday Mar 4th, 10am - 4:45pm Eastern Time

  (2 sessions)
$875

2 sessions

Excel Bootcamp

This class is temporarily being offered remotely.

at General Assembly - Online Remote Online , Denver, Colorado 00000

If you know the basics of Microsoft Excel and want to take your knowledge to the next level, then this hands-on bootcamp is for you. Whether you are in business, management, or simply interested in getting more organized, this Excel bootcamp will cover the tools and functions you need to automate or enhance the way you analyze and restructure your...

Saturday Mar 6th, 11am - 5pm Mountain Time

Excel Bootcamp

This class is temporarily being offered remotely.

at General Assembly - Online Online Class, Houston, Texas 00000

If you know the basics of Microsoft Excel and want to take your knowledge to the next level, then this hands-on bootcamp is for you. Whether you are in business, management, or simply interested in getting more organized, this Excel bootcamp will cover the tools and functions you need to automate or enhance the way you analyze and restructure your...

Saturday Mar 6th, 12pm - 6pm Central Time

Excel Bootcamp

This class is temporarily being offered remotely.

at General Assembly - Online Online Class Livestream, Atlanta, Georgia 00000

If you know the basics of Microsoft Excel and want to take your knowledge to the next level, then this hands-on bootcamp is for you. Whether you are in business, management, or simply interested in getting more organized, this Excel bootcamp will cover the tools and functions you need to automate or enhance the way you analyze and restructure your...

Saturday Mar 6th, 1pm - 7pm Eastern Time