Discover Classes. Earn 10% Rewards.
Tech
/
All Software
/
Microsoft
/
Microsoft Office
/
Excel
/
Intermediate Excel for Business

Intermediate Excel for Business

NYIM Training
4.5 742 reviews

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
  • Earn 10% Rewards
  • Price Lock
  • 185 Madison Ave, New York, NY & Virtually Online
NYIM-excel.jpg
35-accounting-in-person-class.jpg
2019-12-26 12-16-15.jpg
NYIM-BUSINESS.jpg
Book at School

Express Checkout – $249

Proceed to Checkout

No Booking Fees. Lowest Price Guaranteed. Earn 10% Rewards.

Give as a Gift

Start Dates (23)

  • $249/person
Mon, Sep 23rd, 10am–5pm EDT
20 left
Book
Fri, Sep 27th, 10am–5pm EDT
20 left
Book
Tue, Oct 8th, 10am–5pm EDT
20 left
Book
Mon, Oct 14th, 6–9pm EDT
20 left
Book
Show all 2 sessions
  • Mon, Oct 14 at 6:00pm - 9:00pm
  • Mon, Oct 21 at 6:00pm - 9:00pm
Wed, Oct 16th, 10am–5pm EDT
20 left
Book
Showing 1 – 5 of 23
Save to WishList Give as a Gift

Class Description

Description Syllabus Cancellation Policy

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.

Syllabus

Worksheet Management

Navigation

  • Keyboard shortcuts that facilitate quick and easy navigation within cells

Formula Review

  • Review various methods for completing calculations

Working with Text

Splitting Text

  • Use Text to Columns to split text into multiple cells

Joining Text

  • Join text from separate cells

Cell Ranges

Paste Special

  • Apply formats and perform calculations on selected cells

Paste Special Values

  • Hardcode the answer to a formula or function

Named Ranges

  • Assign a name to a range of cells to make it easier to reference those ranges in calculations

Database Functions

VLOOKUP & XLOOKUP

  • Use VLOOKUP and XLOOKUP to find information in cell range and return information from another cell range

Sort & Filter

  • Use Sort & Filter to find and organize data in large databases

Pivot Tables

Pivot Tables

  • Create Pivot Tables to quickly summarize large databases

Pivot Tables & Grouping

  • Group within Pivot Tables

Multiple Pivot Tables

  • Create multiple Pivot Tables on a single worksheet

Logical Functions

IF statements

  • Use IF statements to return output based on the contents of another cell

AND, OR

  • Tests to see whether multiple conditions are true

Math Functions

SUBTOTAL

  • Use SUBTOTAL function to sum/average/count values based on what is not filtered

Statistical Functions

SUMIFS

  • Use SUMIFS function to sum cells based on one or more conditions

COUNTIFS

  • Use COUNTIFS function to count cells based on one or more conditions

Improve Data Quality

Data Validation

  • Restrict the type of data that can be allowed in a cell

Remove Duplicates

  • Eliminate duplicate row data

Advanced Charts

Combo Charts

  • Combine two or more charts into a single chart, with the option of adding a secondary axis

End of Class Project

Project

  • End of class project to review key concepts from the class

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

People who viewed this class also viewed the following classes

CourseHorse Gift Card CourseHorse Gift Card
Pick your value!
Excel Level I: Fundamentals Excel Level I: Fundamentals
$249 for 1 session
Excel Level III: Advanced Excel Level III: Advanced
$249 for 1 session
Excel Level II: Intermediate Excel Level II: Intermediate
$249 for 1 session
View all excel 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
Midtown, Manhattan
185 Madison Ave 3rd Floor
At 34th St
New York, New York 10016

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.

  • Price Lock Guarantee

    Secure your booking now and we'll match any price drop within 48 hours across all booking platforms, ensuring you never miss out on savings!

  • Earn 10% Reward Points

    Maximize your savings with every purchase. Unlock rewards on every transaction, ensuring you get the most value out of your experience!

  • No Added Fees

    Enjoy hassle-free transactions without worrying about additional charges. With us, what you see is what you pay - no surprises!

  • Curated Courses

    Discover a curated selection of courses handpicked by experts in the field. Dive into quality content that suits your learning needs and interests!

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