Advanced Excel for Business - Level 3

at NYIM Training - Midtown

(747)
Course Details
Price:
$219 10 seats left
Start Date:

Tue, Jun 09, 10:00am - 5:00pm ET

Next start dates (7)

Location:
Midtown, Manhattan
185 Madison Ave 3rd Floor
At 34th St
New York, New York 10016
(Map)
Purchase Options
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 (8)
Start Date Time Teacher # Sessions Price
10:00am - 5:00pm Eastern Time TBD 1 $219
10:00am - 5:00pm Eastern Time TBD 1 $219
10:00am - 5:00pm Eastern Time TBD 1 $219
10:00am - 5:00pm Eastern Time TBD 1 $219
10:00am - 5:00pm Eastern Time TBD 1 $219
Start Date Time Teacher # Sessions Price
10:00am - 5:00pm Eastern Time TBD 1 $219
10:00am - 5:00pm Eastern Time TBD 1 $219
10:00am - 5:00pm Eastern Time TBD 1 $219

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 (738)

(738 Reviews)
Advanced Excel for Business - Level 3
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 - Level 3
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 - Level 3
Reviewed by Oksana B. on 11/1/2018
Garfield is the best instructor. Took him twice for different Exel classes.
Advanced Excel for Business - Level 3
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 - Level 3
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...
Similar Classes

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.

Ready to take this class?
BOOK NOW
Booking this class for a group? Find great private group events here