Discover Classes. Earn Rewards.

Advanced Excel for Business

at NYIM Training - Murray Hill

(709)
Course Details
Price:
$209 9 seats left
Start Date:

Tue, Jun 25, 10:00am - 5:00pm

Next start dates (8)

Location:
Murray Hill, Manhattan
185 Madison Ave 11th Fl
At 34th St
New York, New York 10016
(Map)
Share:
Purchase Options
Description
Class Level: Advanced
Age Requirements: 18 and older
Average Class Size: 10

What you'll learn in this excel class:

Advanced Excel for Business

Advanced Excel for Business covers the advanced applications of Excel used frequently by business professionals. This course is perfect for those with strong working knowledge and practice in Excel looking to apply more complex Excel features. In this advanced course, you will learn Goal Seek, Data Tables, advanced functions, and basic macros. You will build upon intermediate-level concepts, making your lookup functions more flexible, taking Pivot Tables to the next level, and facilitating workflow with cell management techniques and Hot Keys. In this hands-on course you will work on real-world examples, reinforcing the concepts with practice throughout the class, as well as a cumulative project at the end. Each attendee will receive access to our revolutionary Excel Fundamentals video suite, with lifetime access to several hours of premium content.

Additional instructions on how to set up Mac will be sent upon registration.

Syllabus:

Cell Management
1) Advanced Cell Locking Create powerful formulas by locking either the column or the row
2) Hot Keys Transform the ribbon into a visual listing of pre-assigned shortcuts
3) Windows Techniques and keyboard shortcuts to allow editing of active windows
4) Cell Auditing Observe the relationship between formulas and cells
Special Formatting
5) Date functions Calculate dates with a variety of functions
6) Conditional Formatting-Formulas Create custom rules for Conditional Formatting with formulas
Advanced Functions
7) Nested If statements Nested "IF" statements allow for more than just two possibilities in a single cell
8) If statements with And/Or Expand the functionality of the IF function by adding an "AND" or an "OR" criteria into the logical test
What If Analysis
9) Goal Seek Find the desired result by adjusting an input value
10) Data Tables Data Tables show the range of effects of one or two different variables on a formula
Advanced Analytical Tools
11) Data Consolidation Summarize data from separate ranges and consolidate into a specified output range
12) Conditional SumProduct Use SumProduct with conditions to exclude data that does not meet certain criteria
13) Pivot Table-Calculations Create calculated rows or columns in a Pivot Table that go beyond the source data
14) Pivot Charts Pivot Charts are dynamic, graphical representations of Pivot Table data that work in tandem with Pivot Tables
Advanced Database Functions
15) MATCH function Return the relative position (column or row number) of a lookup value
16) VLOOKUP-MATCH Create a more accurate VLookUp by enhancing the determination of the Column Index number
17) INDEX-MATCH Efficiently returns a value or reference from a cell at the intersecton of the row and column
18) INDEX-Double MATCH Use a second Match function to create a powerful, two-way lookup tool
Introduction to Macros
19) Recording Macros Record Macros that involve formatting and calculations
20) Relative Macros Record relative reference macros for ad hoc reporting
End of Class Project
21) Project End of class project to review key concepts from the class



You can save 15% when you sign up for this class along with 2 more Excel business classes

Still have questions? Ask the community.

Refund Policy
  • 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 (9)
Start Date Time Teacher # Sessions Price
10:00am - 5:00pm TBD 1 $209
10:00am - 5:00pm TBD 1 $209
10:00am - 5:00pm TBD 1 $209
10:00am - 5:00pm TBD 1 $209
10:00am - 5:00pm TBD 1 $209
Start Date Time Teacher # Sessions Price
10:00am - 5:00pm TBD 1 $209
10:00am - 5:00pm TBD 1 $209
10:00am - 5:00pm TBD 1 $209
10:00am - 5:00pm TBD 1 $209

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 2090 points. Points give you money off your next class!
Questions about this class?
Get help now from a knowledge expert!
Questions & Answers (0)

Get quick answers from CourseHorse and past students.

Reviews of Classes at NYIM Training (700)

(700 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...
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
Taking this class for work? Get exclusive perks & discounts for free.
Loading...