Price:
$209 10 seats left
Start Date:

Sun, Aug 26, 10:00am - 5:00pm

Next start dates (37)

Location:
Midtown, Manhattan
185 Madison Avenue, 11th Floor
34th Street
New York, New York 10016
(Map)
Share:
No Booking Fees Book Now Save to WishList

182 people saved this class

Give as a Gift
Class Level: Intermediate
Age Requirements: 18 and older
Average Class Size: 8

What you'll learn in this excel class:

Intermediate Excel for Business

Intermediate Excel for Business covers the essential applications of Excel used frequently by business professionals. This course is perfect for those with familiarity with basic formulas and functions, charts, and workbook management techniques. In this intermediate-level course, you will learn Pivot Tables, database functions including VLOOKUP and SUMIFS, and logical and statistical functions. We will show you crucial database management tools including Named Ranges, Sort & Filter, and Data Validation. Throughout the class we'll show you tricks and techniques to work more efficiently, including navigational and keyboard shortcuts. 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:

Worksheet Management
1) Navigation Keyboard shortcuts that facilitate quick and easy navigation around the worksheet
2) Paste Special Use Paste Special to apply formats, as well as perform calculations on selected cells
Working with Text
3) Splitting Text Use Text to Columns to split text into multiple cells
4) Joining Text Join text from separate cells
5) Named Ranges Assign a name to a range of cells to make it easier to reference those ranges in calculations
6) Data Validation Create a dropdown menu to make data entry quicker and more efficient
7) Sort & Filter Use Sort & Filter to find and organize data in large databases
8) Remove Duplicates Use Remove Duplicates to eliminate duplicate data
Database Functions
9) VLOOKUP Use Vlookup to find information in one column and return information from another column
10) HLOOKUP Use Hlookup to find information in one row and return information from a second row
11) VLOOKUP - Closet Match If an "Exact Match" cannot be found, Vlookup can still be used to find the closest match
Logical Functions
12) AND, OR Tests to see whether multiple conditions are true
13) IF statements Use IF statements to return output based on the contents of another cell
Pivot Tables
14) Pivot Tables Create Pivot Tables to quickly summarize large databases
15) Pivot Tables & Grouping Group within Pivot Tables
16) Multiple Pivot Tables Create multiple Pivot Tables on a single worksheet
Statistical Functions
17) Ranking Use Rank.eq and Rank.avg functions to determine a cell's position within a larger array
18) COUNTIFS Use COUNTIFS function to count cells based on one or more conditions
19) SUMIFS Use SUMIFS function to sum cells based on one or more conditions
Advanced Charts
20) Combo Charts Combine two or more charts into a single chart, with the option of adding a secondary axis
End of Class Project
22) Project End of class project to review key concepts from the class


You can save 15% when you combine this class with 2 other Excel Classes!

Still have questions? Ask the community.

No charge for substituting students at any time. No charge to reschedule or cancel before 7 business days of class.


There is a $25 rescheduling or cancellation fee (including retakes rescheduling) 3-7 business days from the start of class.


No refund or rescheduling permitted within 2 business days of start of class.


No refund or retakes given for cancellations within 2 business days from the start of class or "no-shows" the day of class.

If a retake is cancelled within 2 business days from the start of class, another retake may not be scheduled. We cannot guarantee that any class offered will not be cancelled or students rescheduled due to scheduling conflict. Retake seats are subject to availability. Students will be notified if class is cancelled or rescheduled.

Map

Google Map
NYIM Training


All classes at this location
Start Dates (38)
Start Date Time Teacher # Sessions Price
10:00am - 5:00pm TBD 1 $209
10:00am - 5:00pm TBD 1 $209
6:00pm - 9:00pm TBD 2 $209
This course consists of multiple sessions, view schedule for sessions.
Thu, Aug 30 6:00pm - 9:00pm TBD
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
6:00pm - 9:00pm TBD 2 $209
This course consists of multiple sessions, view schedule for sessions.
Thu, Sep 27 6:00pm - 9:00pm TBD
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
6:00pm - 9:00pm TBD 2 $209
This course consists of multiple sessions, view schedule for sessions.
Tue, Oct 09 6:00pm - 9:00pm TBD
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
6:00pm - 9:00pm TBD 2 $209
This course consists of multiple sessions, view schedule for sessions.
Tue, Oct 23 6:00pm - 9:00pm TBD
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
6:00pm - 9:00pm TBD 2 $209
This course consists of multiple sessions, view schedule for sessions.
Thu, Nov 08 6:00pm - 9:00pm TBD
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
6:00pm - 9:00pm TBD 2 $209
This course consists of multiple sessions, view schedule for sessions.
Tue, Nov 20 6:00pm - 9:00pm TBD
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
6:00pm - 9:00pm TBD 2 $209
This course consists of multiple sessions, view schedule for sessions.
Thu, Dec 06 6:00pm - 9:00pm TBD
10:00am - 5:00pm TBD 1 $209
10:00am - 5:00pm TBD 1 $209
6:00pm - 9:00pm TBD 2 $209
This course consists of multiple sessions, view schedule for sessions.
Tue, Dec 18 6:00pm - 9:00pm TBD
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

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

Get quick answers from CourseHorse and past students.

Question from Anonymous
What is the second date and how many hours each day? It is very unclear. Is the cost 209 each day?
Answer from Brenda L. CourseHorse Staff
Hi there! This is a one day class for $209 and the class is for 7 hours, 10 am - 5 pm.
Answer
Cancel
Question from Anonymous
Do you receive a creditable certificate for this course
Answer from Georgia C. CourseHorse Staff
Hi there, the school automatically email students their Certificate of Training after the class.
Answer
Cancel

Reviews of Classes at NYIM Training

(614 Reviews)
Intermediate Excel for Business
Reviewed by Anonymous on 7/12/2018
Fast pace, too much information to cover.
Intermediate Excel for Business
Reviewed by Anonymous on 6/14/2018
Great instructor who was passionate about the topic.
Intermediate Excel for Business
Reviewed by Jordan C. on 4/13/2018
Garfield was a great instructor and the curriculum/lesson was great!
Intermediate Excel for Business
Reviewed by Anonymous on 3/16/2018
Garfield is a great teacher. We covered a lot in the class. I love that you can retake it again and that there is a video to refer to.
Intermediate Excel for Business
Reviewed by Anonymous on 2/27/2018
I thought the instructor was very knowledgeable. The class was a bit slow paced for me and we spent a lot of time reviewing things I thought should have been in a beginners corse.
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.

Ready to take this class?
BOOK NOW
Taking this class for work? Get exclusive perks & discounts for free.