Advanced Excel for Business - Level 3

at NYIM Training - Midtown

(747)

Course Details

Price:

$219 10 seats left

Need more seats?

Start Date:

Mon, Jul 20, 10:00am - 5:00pm Eastern Time

Next start dates (4)

Location:

IMPORTANT: This class is being offered remotely and not in person. Click for details.

Midtown, Manhattan
185 Madison Ave 3rd Floor
At 34th St
New York, New York 10016 (Map)

Other Booking Options:

Purchase Options

No Booking Fees Book Now Save to WishList

186 people saved this class

Give as a Gift

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

IMPORTANT: This class is being offered remotely and not in person. Click for details.

NYIM Training
Midtown, Manhattan
185 Madison Ave 3rd Floor
At 34th St
New York, New York 10016 Midtown, Manhattan
185 Madison Ave 3rd Floor
At 34th St
New York, New York 10016

All classes at this location

Start Date	Time	Teacher	# Sessions	Price

Mon, Jul 20	10:00am - 5:00pm Eastern Time	TBD	1	$219

Thu, Jul 30	10:00am - 5:00pm Eastern Time	TBD	1	$219

Thu, Aug 13	10:00am - 5:00pm Eastern Time	TBD	1	$219

Fri, Aug 21	10:00am - 5:00pm Eastern Time	TBD	1	$219

Wed, Sep 02	10:00am - 5:00pm Eastern Time	TBD	1	$219

Book Now Give as a Gift

Booking for more than 6+?
See more dates and classes for private groups

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 Staff

Hi Janice! Yes. Each student who completes a course will receive a certificate of completion. Hope this helps!

Answer

Reviews of Classes at NYIM Training (738)

(738 Reviews)

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.

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.

Reviewed by Oksana B. on 11/1/2018

Garfield is the best instructor. Took him twice for different Exel classes.

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

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.

See 13 More Course Reviews

See reviews for other classes at NYIM Training

Hide Reviews

Similar Classes

School: 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...