Discover Classes. Earn Rewards.

Intermediate Excel for Business

Take your Excel skills to the next level with hands-on projects in this Intermediate Excel course. Master VLOOKUP, Pivot Tables, and advanced functions, and learn techniques to expedite your workflow. Unlock powerful techniques that will help you complete tasks more quickly.

  • Intermediate
  • 18 and older
  • $249
  • 185 Madison Ave, New York, NY & Virtually Online

Start Dates (35)

  • $249
  • NYIM @ 185 Madison Ave 3rd Floor, New York, NY 10016
20 seats left
Book
20 seats left
Book
20 seats left
Book
20 seats left
Book
20 seats left
Book
Show all 2 sessions
  • Thu, Apr 25 at 6:00pm - 9:00pm
  • Tue, Apr 30 at 6:00pm - 9:00pm
Showing 15 of 35

Class Description

Description

What you'll learn in this excel class:

Master VLOOKUP, Pivot Tables, formulas and functions in this hands-on course. Learn the essential Excel skills with real-world projects from the experts.

Go from beginner to experienced professional: summarize data with Pivot Tables, write advanced functions including VLOOKUP and XLOOKUP, and learn techniques to expedite your workflow. Split and join text, create dropdown menus, and sort and filter data. Use statistical formulas like COUNTIFS and SUMIFS to learn more about your data. At the end of this class, you'll unlock powerful techniques that will help you complete tasks more quickly.

Prerequisite:

Attendees must have beginner Excel skills equivalent to our Excel Fundamentals course, including basic functions and formulas, printing, formatting, basic charts, and tables.

What You’ll Learn at a Glance

  • Navigation tricks & shortcuts
  • Summarize data with Pivot Tables
  • VLOOKUP & XLOOKUP functions
  • Join and split text
  • Create drop-down menus
  • Sort & filter data
  • Tricks to speed up workflow
  • Logical functions: IF, AND, OR

Course Syllabus

  • Worksheet Management
    • Navigation
    • Formula Review
  • Working with Text
    • Splitting Text
    • Joining Text
  • Cell Ranges
    • Paste Special
    • Paste Special Values
    • Named Ranges
  • Database Functions
    • VLOOKUP & XLOOKUP
    • Sort & Filter
  • Pivot Tables
    • Pivot Tables
    • Pivot Tables & Grouping
    • Multiple Pivot Tables
  • Logical Functions
    • IF statements
    • AND, OR
  • Math Functions
    • SUBTOTAL
  • Statistical Functions
    • SUMIFS
    • COUNTIFS
  • Improve Data Quality
    • Data Validation
    • Remove Duplicates
  • Advanced Charts
    • Combo Charts
  • End of Class Project
    • Project

Learn more about Intermediate Excel for Business at NYIM Training

Refund Policy

  • Students may cancel up to 11 business days before the class/program start date and receive a refund, less the registration fee (10% of the undiscounted course price).
  • Cancellations within 11 business days are not permitted, but students may reschedule up to 4 business days before the class start date.

For cancellations and reschedules, please email us at [email protected]

Reviews of Classes at NYIM Training (742)

(4.5-star rating across 742 reviews)
  • Intermediate Excel for Business

    Reviewed by Ray R. on 7/30/2020
    I liked the class and planning to take more courses in the future.
  • Intermediate Excel for Business

    Reviewed by Harim J. on 4/17/2020
    Excellent and relevant especially for business professional in finance.
  • Intermediate Excel for Business

    Anonymous review on 2/21/2020
    The course was expertly addressed. The teacher took time but not too long to make sure everyone in the class was up to speed. The students varied in excel skill level but with an Intermediate class nothing took too long for everyone to fully grasp. I think the teacher thoroughly went through exercises and practice problems. Sometimes even called on students to complete exercises in front of the classroom. Everyone was called on about once and if you really do not know you do not need to go up. It's more of a way of making you feel proud of figuring it out. I will definitely be back for a higher level course! Thanks again!
  • Intermediate Excel for Business

    Anonymous review 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

    Anonymous review 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

    Anonymous review on 7/12/2018
    Fast pace, too much information to cover.
  • Intermediate Excel for Business

    Anonymous review on 6/14/2018
    Great instructor who was passionate about the topic.
  • Intermediate Excel for Business

    Reviewed by Jordan C. on 4/13/2018
    Garfield was a great instructor and the curriculum/lesson was great!
  • Intermediate Excel for Business

    Anonymous review on 3/16/2018
    Garfield is a great teacher. We covered a lot in the class. I love that you can retake it again and that there is a video to refer to.
  • Intermediate Excel for Business

    Anonymous review on 2/27/2018
    I thought the instructor was very knowledgeable. The class was a bit slow paced for me and we spent a lot of time reviewing things I thought should have been in a beginners corse.
  • Intermediate Excel for Business

    Anonymous review on 2/26/2018
    Garfield is a great teacher, in that he makes an effort to answer any and all questions that the students may have. He's knowledgeable, engaging, and injects humor into the lessons, and the material he works with is realistic in a business setting. The exercises also do a good job of testing comprehension. The only complaint I have is that the harder parts of the class come too far into the second half of the class, which means that we rushed through some important aspects of Excel (pivot tables, Countifs, etc.). If you use Excel regularly and this is simply a brush up, then you'll have no problem with this pace. If you're looking to expand your skills or you're returning to the application after not having used it in awhile, then you might struggle during the second half. Luckily, NYIM allows for a free repeat of the class within a year, something I plan to take advantage of. Other than that, I'm happy that I took the course, and I'll probably try for the advanced class once I feel completely comfortable with what I've learned up to that point.
  • Intermediate Excel for Business

    Reviewed by Allen C. on 1/28/2018
    Garfield is a great teacher, definitely recommend.
  • Intermediate Excel for Business

    Anonymous review on 1/27/2018
    Fantastic class!
See 120 More Course Reviews
loading...
See reviews for other classes at NYIM Training
loading...
Hide Reviews

Review Summary by CourseHorse

Students found the Intermediate Excel for Business class very useful, praising it for its relevant and practical content, especially for those pursuing careers in finance and business. Many noted the course's fast pace and extensive coverage of topics, suggesting a good foundational knowledge of Excel is beneficial. The instructors were highly praised for their knowledge, patience, and ability to explain complex concepts clearly. Participants also appreciated that instructors catered to varying skill levels, allowing all students to keep up and fully grasp the key concepts. The skills and tips learned in class were immediately applicable, with many students feeling confident in applying their new knowledge in real work settings. Some students felt the class could have allocated more time for complex topics and allowed more opportunities for hands-on practice. 1. "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." 2. "Garfield is a great teacher, in that he makes an effort to answer any and all questions that the students may have. He's knowledgeable, engaging, and injects humor into the lessons, and the material he works with is realistic in a business setting." 3. "Having pretty much taught myself on how to use v lookups and pivot tables it was great to have a formalized training. I learned so much more. The class is well worth the time and money."

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 Show 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 Show 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 Show answer
Cancel

Similar Classes

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

Read more about NYIM Training

CourseHorse Approved

This school has been carefully vetted by CourseHorse and is a verified NYC educator.

NYIM Training

NYIM Training

All classes at this location

We are located in New York City on 34th street and Madison Avenue, a few blocks from Penn Station, Port Authority and Times Square. You may also attend this class live online (virtual training) via Zoom. We will reach out with additional information, including the Zoom info and class files.

Also available virtually online

Google Map

Give This Course as a Gift Card

  • Thousands of classes
  • No expiration
  • Unique and memorable gifts for any occasion
  • Personalized
  • Explore a passion, gain a new skill, discover a new hobby, engage in a memorable experience
  • Instant delivery
  • Lock in a price with the Inflation Buster Gift Card Price Adjuster™

Buy a Gift Card

Book this Class as a Group Event

Booking this class for a group? Find great private group events

Or see all Excel Group Events

Explore group events and team building activities ranging from cooking, art, escape rooms, trivia, and more.

CourseHorse Gift Cards

  • Creative & unique gift for any occasion
  • Thousands of classes & experiences
  • No expiration date
  • Instant e-delivery (or choose a date)
  • Add a personalized message
  • Lock in a price with the Inflation Buster Gift Card Price Adjuster™
Buy a Gift Card
gift card with the CourseHorse logo gift card with the CourseHorse logo
Loading...