Discover Classes. Earn Rewards.

Intermediate Excel for Business

at NYIM Training - Murray Hill

(661)
Course Details
Price:
$209 8 seats left
Start Date:

Sun, Dec 16, 10:00am - 5:00pm

Next start dates (32)

Location:
Murray Hill, Manhattan
185 Madison Ave 11th Fl
At 34th St
New York, New York 10016
(Map)
Share:
Purchase Options
No Booking Fees Book Now Save to WishList

207 people saved this class

Give as a Gift
Description
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.

Refund Policy
Rescheduling & Cancellation

Registration fee: Each class or program includes a non-refundable registration fee (10% of the price, but no more than $100 per class).

Class Rescheduling/Cancellations:

Students may cancel up to 7 business days before the start of a class or program and receive all monies paid, less the non-refundable registration fee.

Cancellations made within 24 hours of registration receive a full refund, including the registration fee, provided the registration is not the business day before the class.

Students may log into their profile and reschedule their class themselves. There are no cancellations or reschedules allowed within 7 business days. However, a student may reschedule the class per the retake policy guidelines.

For exigent circumstances, students may submit a special request by email which will be considered on a case-by-case basis.  

Please make sure that ALL rescheduling requests from students should go to [email protected]

Please DO NOT reach out to NYIM Training about any cancellation and refund policy exemptions. Instead, have them reach out directly to  NYIM Training  to schedule a free retake if within six months. 

Student should contact [email protected] to schedule a “retake.” and/or directly contact the school at 212.658.1918.

Bundles & Bootcamp Packages: 
Packages of classes and certification bundles can be completed within two years of the purchase date.

There are no cancellations allowed within 7 days of the start of a program, which is the start date of the first class.

Individual classes in the program may be rescheduled up to 7 business days before the start date of the class.


Retake Policy

Students are allowed to retake a course once within six months of the course date if the class is running with an available seat.

To be eligible for a retake, students must complete the evaluation form provided at the end of the class.

To submit a retake request, please email the school directly. You will be notified three business days before the class whether a seat is available.

Map

Google Map

NYIM Training

All classes at this location

Start Dates (33)
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.
Tue, Dec 18 6:00pm - 9:00pm TBD
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
6:00pm - 9:00pm TBD 2 $209
This course consists of multiple sessions, view schedule for sessions.
Thu, Jan 17 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, Jan 29 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
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, Feb 14 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
6:00pm - 9:00pm TBD 2 $209
This course consists of multiple sessions, view schedule for sessions.
Tue, Feb 26 6:00pm - 9:00pm TBD
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
6:00pm - 9:00pm TBD 2 $209
This course consists of multiple sessions, view schedule for sessions.
Thu, Mar 14 6:00pm - 9:00pm TBD
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
6:00pm - 9:00pm TBD 2 $209
This course consists of multiple sessions, view schedule for sessions.
Tue, Mar 26 6:00pm - 9:00pm TBD
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 (3)

Get quick answers from CourseHorse and past students.

Question from Anonymous
Do we need to bring laptops or the course provides?
Answer from Brenda L. CourseHorse StaffCourseHorse Staff
HI there! Yes, computers are provided.
Answer
Cancel
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 StaffCourseHorse 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 StaffCourseHorse Staff
Hi there, the school automatically email students their Certificate of Training after the class.
Answer
Cancel

Reviews of Classes at NYIM Training (652)

(652 Reviews)
Intermediate Excel for Business
Reviewed by Melissa L. on 10/15/2018
The class was amazing and the instructor was superb!
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.
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...