Intermediate Excel for Business

at NYIM Training - Murray Hill

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

Mon, Sep 23, 10:00am - 5:00pm

Next start dates (18)

Location:
Murray Hill, Manhattan
185 Madison Ave 11th Fl
At 34th St
New York, New York 10016
(Map)
Share:
Purchase Options
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
  • 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 (19)
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
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
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 (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 (721)

(721 Reviews)
Intermediate Excel for Business
Reviewed by Anonymous on 9/13/2019
I liked the substance of this class. The teacher was very informative and knowledgeable. The school location was great and easy to get to. The waiting room could have used some cleaning. Also the breakfast provided could have been a little nicer. When I got there it was just a bunch of bagles on a tray.
Intermediate Excel for Business
Reviewed by Anonymous on 8/12/2019
The skills and tips learned in this class can be used immediately! A strong foundation in Excel is necessary for the intermediate level since the pace is pretty fast and there are a lot of topics covered.
Intermediate Excel for Business
Reviewed by Christine F. on 3/11/2019
Great explainations, good examples and instructor made sure everyone understood the content.
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.
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