Yelp Facebook LinkedIn 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.

Read more
  • Small Classes
  • Computer Provided
  • Top Instructors
  • Free Retake

Register for a Class

  • $209
  • 6 Hours
  • Mac or PC
  • 185 Madison Ave, NYC

Corporate training available

Email

This course is offered at our business training school, NYIM Training, in Midtown Manhattan. Register for this course directly on NYIM’s website.

Register at training-nyc.com

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

See our 2,582 testimonials
5
4.9
4.9

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. 

Related Classes & Certificates

Excel for Business Fundamentals

6 Hours

$209

More details

Advanced Excel for Business

6 Hours

$209

More details

Excel for Business Bootcamp

18 Hours

$535

More details
See all related classes & certificates