close
You are not logged in
close
This Month Specials
 

Special Promotion

$209 Excel or $199 PowerPoint for Business Blowout! (Normally $299/ea)

PowerPivot Fundamentals $199 (Normally $299)

$199 QuickBooks Level 1 or Level 2 for PC, Mac, or Online Classes (Normally $299/ea)

Now $545-Excel Power Programming with VBA (Normally $659)

Now $649-Photoshop Essentials 2 Day Course (Normally $749)

GIFT CERTIFICATES AVAILABLE

Current Sales Packages

close
185 Madison Ave, 11th Floor, New York, NY 10016 212.658.1918

Intermediate Excel for Business

$209

SessionPriceSeatsLocation
Apr 25, Apr 26: 6:00pm–9:00pm$20910185 Madison Avenue, NYC
Apr 27: 10:00am–5:00pm$2098185 Madison Avenue, NYC
May 3: 10:00am–5:00pm$2099185 Madison Avenue, NYC
May 6: 10:30am–5:30pm$20910185 Madison Avenue, NYC
May 7, May 8: 6:00pm–9:00pm$20910185 Madison Avenue, NYC
May 8: 10:00am–5:00pm$20910185 Madison Avenue, NYC
May 15: 10:00am–5:00pm$20910185 Madison Avenue, NYC
May 19: 10:00am–5:00pm$20910185 Madison Avenue, NYC
May 21: 10:00am–5:00pm$2099185 Madison Avenue, NYC
May 22, May 23: 6:00pm–9:00pm$20910185 Madison Avenue, NYC
May 25: 10:00am–5:00pm$20910185 Madison Avenue, NYC
Jun 1: 10:00am–5:00pm$20910185 Madison Avenue, NYC
Jun 3: 10:00am–5:00pm$20910185 Madison Avenue, NYC
Jun 6, Jun 7: 6:00pm–9:00pm$20910185 Madison Avenue, NYC
Jun 7: 10:00am–5:00pm$20910185 Madison Avenue, NYC
Jun 13: 10:00am–5:00pm$20910185 Madison Avenue, NYC
Jun 16: 10:00am–5:00pm$20910185 Madison Avenue, NYC
Jun 18, Jun 19: 6:00pm–9:00pm$20910185 Madison Avenue, NYC
Jun 21: 10:00am–5:00pm$20910185 Madison Avenue, NYC
Jun 25: 10:00am–5:00pm$20910185 Madison Avenue, NYC
Show more

Call 212.658.1918 or email us

Intermediate Excel Class New York City

Intermediate Excel for Business: In-Person Class with Free Retake & Premium Video Suite

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.

This class is part of our Excel for Business Bootcamp. Take our three Excel for Business classes and get a 15% package discount. Sign up for the Excel Bootcamp

Revolutionary Excel Video Suite with Premium Content

Review the course materials with high-quality video with lifetime access on desktop, tablet or mobile, a $95 value, included at no additional charge.

Intermediate Excel Class

Rated the Best Excel Courses in New York City

  • Practical and hands-on training focused on real-world applications of Excel
  • Engaging and interactive instructors
  • Revolutionary video suite with several hours of premium content
  • Proprietary course manual and shortcut sheets
  • Small class sizes for personalized attention

Intermediate Course Outline

Intermediate Course PDF Outline

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
   

See More Excel Classes at NYIM

All Excel Classes Beginner Advanced Fast as Hell VBA Certification

© NYIM Training 2018

Client Testimonials
I had a great experience in my level 2 Excel for business course. The instructor, Garfield, was very knowledgeable and patient with questions. He taught all the sections effectively and I really feel like I learned a lot from that one day session. NYIM has a really nice facility with modern computers (Macs too). The fact that they give you the chance to re-take a class free of charge within a year after the first one is amazing. I highly recommend their courses and will definitely be taking another class, or two! 12/16/2017- Tessa P. attended Intermediate Excel for Business
Garfield was very knowledgeable and took his time working with my group. Whenever one of us didn't understand he was more than happy to slow down and figure out where we were confused. Definitely recommend this place! 01/05 - Sanura D. attended Intermediate Excel for Business
Had an amazing experience taking Excel for Business Level 2 at NYIM. The excel class helped me get back up to speed on a ton of fundamental techniques and short cuts, and the instructor was awesome. They even gave us videos to look at after we finished the class for some extra help on our own time. The actual location was convenient and comfortable, they gave us coffee tea and chcocolate- an overall great experience. Will definitely be going back for level 3. 12/10- Eddie H. attended Intermediate Excel for Business
Overall great experience in taking the Intermediate Excel Class today! Content was well organized and had appropriate progression from easy to more complex examples. Garfield, our instructor, was very knowledgabe, patient, and thorough. He also had a great sense of humor and kept the class interesting, time really flew by! I will be back to take the Advanced class and also the VBA. 12/16- Patrick M. attended Intermediate Excel for Business
The instructor Garfield was patient, informative and precise! 11/28- Lisa N. attended Intermediate Excel for Business
I do not remember the instructors name - he was good but he went pretty fast with some of the subjects. I was a little lost with 3 of the items but it was going so fast that I didn't want to disrupt the rest of the class who seemed to have picked it up pretty quickly. I am grateful that there is a video and handouts available so that I can reference back to where I got lost and try to figure it out. This was my second class and I'm still pretty glad that my job has paid for them. 11/20- Bobbi M. attended Intermediate Excel for Business
Just finished excel level 2 class. Went to review my excel skills before starting new job but ended up learning new tricks and functions also. The lecturer (Garfield) was very calm,kind, and informative. Thank you, Garfield! 11/04/2017- Bokyong A. attended Intermediate Excel for Business
I retook this course. Garfield did not teach my first course but he taught my second course. He is a fantastic teacher. He is so clear and methodological. I highly recommend this class. 9/28- Dominika J. attended Intermediate Excel for Business
Great Excel Training! Garfield does a great job at instilling actionable tips and shortcuts that can really be used ASAP! Would recommend to anyone looking enhance their skillset! 9/7/17- Aston F attended Intermediate Excel for Business
Thank you Michael for teaching this course!! Your knowledge of the material really help me to feel confident in taking what I've learned in the classroom and applying it to my newly assigned work projects. I would recommend this class to anyone wanting a better understanding of Excel. 08/06/2017- Tracy A attended Intermediate Excel for Business