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
1 Union Square West, Suite 805, NY, NY 212.658.1918

Excel for Business Level II - Intermediate

$209

SessionPriceSeatsInstructorLocation
Feb 24: 10:00am–5:00pm$2095Garfield S.1 Union Square W, NYC
Feb 26: 10:00am–5:00pm$2095Garfield S.185 Madison Avenue, NYC
Feb 27, Feb 28: 6:00pm–9:00pm$20910Garfield S.1 Union Square W, NYC
Mar 6: 10:00am–5:00pm$2095Michael M.185 Madison Avenue, NYC
Mar 11: 10:30am–5:30pm$2099Garfield S.185 Madison Avenue, NYC
Mar 14: 10:00am–5:00pm$2099Garfield S.185 Madison Avenue, NYC
Mar 14, Mar 15: 6:00pm–9:00pm$20910Garfield S.185 Madison Avenue, NYC
Mar 19: 10:00am–5:00pm$2098Garfield S.185 Madison Avenue, NYC
Mar 23: 10:00am–5:00pm$20910TBD185 Madison Avenue, NYC
Mar 24: 10:00am–5:00pm$20910Michael M.185 Madison Avenue, NYC
Mar 26, Mar 27: 6:00pm–9:00pm$20910Michael M.185 Madison Avenue, NYC
Mar 30: 10:00am–5:00pm$20910TBD185 Madison Avenue, NYC
Apr 5: 10:00am–5:00pm$20910TBD185 Madison Avenue, NYC
Apr 8: 10:30am–5:30pm$20910TBD185 Madison Avenue, NYC
Apr 10, Apr 11: 6:00pm–9:00pm$20910TBD185 Madison Avenue, NYC
Apr 12: 10:00am–5:00pm$20910TBD185 Madison Avenue, NYC
Apr 17: 10:00am–5:00pm$20910TBD185 Madison Avenue, NYC
Apr 21: 10:00am–5:00pm$2099TBD185 Madison Avenue, NYC
Apr 23: 10:00am–5:00pm$20910TBD185 Madison Avenue, NYC
Apr 25, Apr 26: 6:00pm–9:00pm$20910TBD185 Madison Avenue, NYC
Show more

CALL 212.658.1918 OR EMAIL US

Excel for Business Level II - Intermediate

Excel 2010 Training Class Logo

Excel for Business Level II - Intermediate is the second of a three part series that aims to tackle the most common and practical uses of Excel in business. This course is perfect for those who have either taken Level I or already have a basic working knowledge of Excel and would like to improve efficiency and expand into more complex functions and data management features. By the end of this course, you will know how to dynamically extract data from large databases, quickly organize and summarize tables with Pivot Tables, and manage large amounts of data. You'll also learn some handy tricks and shortcuts to cut down hours of unnecessary work each day.

Call 212.658.1918 or Email us

Class Perks

 
  • Practical and hands-on training classes
  • Proprietary curriculum refined by industry experts
  • Interactive courses taught by engaging instructors
  • Revolutionary video suite with premium content
  • Personalized attention in small class sizes

Materials

  • Custom Printed Manual
  • Multiple XLS and XLT examples for in class and after class
  • Shortcut sheets
  • After class resources

Course 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
Text
3) Splitting Text Use Text to Columns to split text into multiple cells
4) Joining Text Join text from separate cells
Database Management
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) True, False, Not Tests to see whether criteria is true/false, or not true/false
13) And, Or Tests to see whether multiple conditions are true
14) IF statements Use IF statements to return output based on the contents of another cell
Statistical Functions
15) Rank.eq function Use Rank.eq function to determine a cell's position within a larger array
16) Countifs function Use Countifs function to count cells based on one or more conditions
17) Sumifs function Use Sumifs function to sum cells based on one or more conditions
Pivot Tables
18) Table review Review benefits of formatting data as a table
19) Pivot Table Create Pivot Tables to quickly summarize large databases
20) Pivot Tables & Grouping Group within Pivot Tables
21) Multiple Pivot Tables Create multiple Pivot Tables on a single worksheet
End of Class Project
22) Project End of class project to review key concepts from the class

© 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 Excel for Business Level II - Intermediate
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 Excel for Business Level II - Intermediate
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 Excel for Business Level II - Intermediate
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 Excel for Business Level II - Intermediate
The instructor Garfield was patient, informative and precise! 11/28- Lisa N. attended Excel for Business Level II - Intermediate
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 Excel for Business Level II - Intermediate
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 Excel for Business Level II - Intermediate
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 Excel for Business Level II - Intermediate
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 Excel for Business Level II - Intermediate
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 Excel for Business Level II - Intermediate