Yelp Facebook YouTube Twitter Instagram

Intermediate Excel for Business

Intermediate Excel Courses

In this intermediate Excel class, you’ll learn functions such as VLOOKUP and SUMIFs; summarize data with Pivot Tables; Sort & Filter databases; and split and join text. This course assumes basic knowledge equivalent to our Excel Fundamentals course.

The course comes with our revolutionary Excel video suite, so you can review the materials anytime after the class.

Take this class as part of the Excel Bootcamp and get a 15% discount. The package includes our Fundamentals, Intermediate, and Advanced Excel classes.

This advanced Excel training is located at our affiliate school, NYIM Training, located at 185 Madison Avenue in Midtown Manhattan.

  • 6 Hours
  • Small classes
  • Mac or PC provided
  • Free retake

Register for a class

$209 Discounts Policies

NYC

Show all dates

What You’ll Learn

  • Learn to split and join text, add data validation, and named ranges
  • Use database functions such as VLOOKUP & HLOOKUP
  • Add logical statements, including AND, OR, and IF statements
  • Create Pivot Tables to quickly summarize large databases
  • Use statistcal functions such as Ranking, COUNTIFS, and SUMIFS
  • Create advanced combo charts from multiple charts
  • Review key concepts by creating a final project
View full syllabus

Intermediate Excel for Business Class Syllabus

Excel 2016 classes at Noble Desktop

Gain Professional Excel Skills

Take your Excel skills to the next level with this intermediate class. This class is designed to teach you tips and techniques that are essential for business professionals. Throughout the class you’ll work on real-world examples that will teach you keyboard shortcuts and tricks to increase your effficiency in the workplace.

  • “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!”

    Tessa P.

    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 chocolate- an overall great experience. Will definitely be going back for level 3.”

    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.”

    Patrick M.

    Attended Intermediate Excel for Business

  • “Had a one on one training with Garfield - he was patient, professional, and incredibly knowledgeable. Would highly recommend for anyone looking to expand their excel capabilities in business.”

    Alexandria A.

Excel Video Suite Included

This class comes with access to a video suite that contains individual videos recapping the projects in the course. 

Industry Professional Instructors

All of the Excel Intermediate instructors are industry professionals who draw on their experience to teach real-world applications and time-saving techniques. Learn tips, tricks, and keyboard shortcuts throughout the class.

Real-world Class Examples

Throughout this hands-on Excel course you will work on real-world examples. You’ll gain extensive practice during class exercises, as well as apply the concepts you learned in a project at the end. 

Register for Intermediate Excel for Business

$209 Discounts Policies

NYC

Show all dates