Featured Excel Classes: In-Person (Manhattan) or Live Online

Join us live online from Queens for hands-on Excel training. Learn core Excel concepts and put them to use by working on step-by-step exercises with a live instructor.

Excel for Business Bootcamp

Become an advanced Microsoft Excel user in just three days. This Excel Bootcamp includes 21 hours of hands-on training in formulas, functions, Pivot Tables, macros & more.

Read more
- $549
- 21 hours
- Weekdays, weeknights, or weekends
- Open to beginners
Course details See upcoming dates
Excel for Business Fundamentals

Learn all the basics to use Excel as your primary data processing tool. Create charts and tables, get started with formulas and functions, and format and print your output.

Read more
- $249
- 7 hours
- Weekdays, weeknights, or weekends
- Open to beginners
Course details See upcoming dates
Intermediate Excel for Business

Go from beginner to experienced professional: summarize data with Pivot Tables, write advanced functions including VLOOKUP, and learn techniques to expedite your workflow.

Read more
- $229
- 7 hours
- Weekdays, weeknights, or weekends
- Prerequisites required
Course details See upcoming dates
Advanced Excel for Business

Become an Excel guru in this hands-on advanced training. You'll make functions more flexible, take Pivot Tables to the next level, automate tasks with macros, and learn advanced analytical tools.

Read more
- $229
- 7 hours
- Weekdays, weeknights, or weekends
- Prerequisites required
Course details See upcoming dates

Excel Certifications: In-Person (Manhattan) or Live Online

Come into our Midtown Manhattan location, a short commute from Queens, for hands-on, in-person Excel training.

Excel Specialist Certification Program

The Excel Specialist Certification program includes our three Excel courses (Fundamentals, Intermediate, and Advanced), two hours of private training, and the Excel Specialist Exam fee with a free retake.

Read more
- $899
- 24 hours
- Weekdays, weeknights, or weekends
- Open to beginners
Course details See upcoming dates
Excel Expert Certification Program

This certification program will prepare you for the Microsoft Excel exam: Excel 2016 Expert: Interpreting Data for Insights. This program includes three group classes, four hours of private training, and the Excel Expert Exam with a free retake.

Read more
- $1,099
- 26 hours
- Weekdays, weeknights, or weekends
- Open to beginners
Course details See upcoming dates

See All Excel Courses

Learn the Skills Guarantee™

Hands-on training in small groups

Work on projects proven to boost retention
Time-tested curriculum and supporting materials

Refined over many cohorts for an optimal learning experience
Learn from industry experts with teaching experience

Experienced educators who are driven to help you succeed
Retake the course for free within one year

Refresh the materials and gain additional practice

Learn the concepts and skills covered in these courses or your tuition is on us. See details and terms & conditions.

Excellent classes and excellent venue! It has just the right level of personal attention and class participation. I would highly recommend NYIM and look forward to taking future classes there. – Hazel S.

What You'll Learn in Excel

With Excel being such a necessary skill in today's workplace, a new user may find themselves asking "what can Excel do?" and "Why is Excel so much more in demand than any other program?"

The answer lies in the way Excel works and the many different functionalities that it possesses. Here's a brief overview of Excel's robust capabilities.

Calculations

Excel can calculate everything from basic formulas (addition, subtraction, etc.) to complex statistics and everything in-between.

Functions exist (such as Sum, Average) to enable the user to perform advanced calculations with minimal effort. On top of all of this is Excel's extraordinary ability to take a single calculation and to apply it to hundreds or thousands of additional rows of data (Autofill).

Excel contains a very sophisticated library of functions that are brilliantly organized for ease of use. Some of the categories include Financial functions (IRR, NPV, PV), Logical functions (If/Then, And/Or), Text functions (Proper, Concatenate), Date & Time functions (Weeknum, EOMonth), and Lookup & Reference functions (Match, Index).

Get started with calculations and functions in our introductory course, and continue learning in our Excel Bootcamp.

Working with Text

Even though Excel is a spreadsheet program, it possesses a significant number of capabilities for dealing with text. Excel can split text from one cell to multiple cells (Text to Columns), such as with names, or it can combine text from several cells into one cell (Concatenate), such as with addresses.

Excel can also be used to analyze data to remove any duplicate rows/entries (Remove Duplicates). Furthermore, as Excel is increasingly being used internally by companies for forms, it can provide a structure such as drop-down boxes (Data Validation).

Elaborate Charts and Graphs

Ever since its first introduction to the business world, Excel has consistently set the standard regarding charts and graphs—both regarding design and ease of creation. Excel boasts both vivid and detailed depictions of your data all in just a few simple keystrokes. From basic (Line charts, Column charts, Pie charts), to complex (Histograms, Stock charts, Combo charts), Excel provides countless ways to visualize your data for optimal reporting and decision-making purposes. Learn chart essentials in our beginner courses.

Data Analysis with Pivot Tables

Pivot tables are a very cutting-edge approach to analyzing data, by creating visually-appealing tables that provide both consolidation and calculation of results. Excel can create a Pivot table from several different data sources that are both customized and easy to use regarding filtering (Slicers) and data availability (Grouping). Summarize data with Pivot Tables in our intermediate class.

Data Extraction from Tables

While Excel offers a lot of special functionalities for organizing data (Tables), efficiently leveraging that information is another challenge that Excel minimizes. Data can be analyzed and summarized (CountIfs, SumIfs) or simply retrieved (VLOOKUP) from a larger source through specialty functions, making database work much more efficient. Build these formulas in our intermediate Excel course.

Advanced Data Tools

Forecasting data becomes almost second-nature when utilizing Excel's "What If" analysis abilities. You can change the result of an equation and have Excel calculate the necessary variables to make it true (Goal Seek). You can also create single or multi-variable data tables (Data Table) to map out possibilities.

Recording Macros

Do you have reporting responsibilities at work that involve repetitive tasks? Ever dreamed of a magic wand that could instantly compose that report/perform those repetitive tasks for you? With Excel, this is no longer a dream (Macros)! Excel can record your steps/keystrokes and translate these into code (VBA) for future reference. The next time you need to complete that task, simply run the macro and watch the magic!

Learn advanced data analytics tools and macros in our advanced Excel course.

These are just a few of the more useful abilities that Excel possesses. By learning Excel, you do more than add a line item to your resume; you acquire these skills, as well. Imagine going to work with the knowledge that whatever task comes your way, you feel confident that you can handle it. Excel is a powerful tool with lots of uses and functionality. In our classes you'll not only learn in lectures but you'll actually start working in Excel on real projects so you can walk away with real skills and confidence in your Excel abilities.

Join us for Excel in Queens either live online from home or in our NYC facility, a short commute from Queens.

We are also happy to offer custom corporate training for Excel in Queens at no extra charge. Just leave us an email, give us a ring, or chat with us to learn more about corporate training and see why companies all across the country work with us to train their employees.

August 2021
Excel for Business Fundamentals August 3 Tuesday 10–5pm	$249 7 Hours Queens or Live Online	Learn all the basics to use Excel as your primary data processing tool. Create charts and tables, get started with formulas and functions, and format and print your output.	Add to cart
Intermediate Excel for Business August 4 Wednesday 10–5pm	$229 7 Hours Queens or Live Online	Go from beginner to experienced professional: summarize data with Pivot Tables, write advanced functions including VLOOKUP, and learn techniques to expedite your workflow.	Add to cart
Advanced Excel for Business August 4–5 Wednesday to Thursday 6–9pm	$229 7 Hours Queens or Live Online	Become an Excel guru in this hands-on advanced training. You'll make functions more flexible, take Pivot Tables to the next level, automate tasks with macros, and learn advanced analytical tools.	Add to cart
Excel for Business Fundamentals August 9 Monday 10–5pm	$249 7 Hours Queens or Live Online	Learn all the basics to use Excel as your primary data processing tool. Create charts and tables, get started with formulas and functions, and format and print your output.	Add to cart
Excel for Business Bootcamp August 9–23 Weekdays 10–5pm	$549 21 Hours Queens or Live Online	Become an advanced Microsoft Excel user in just three days. This Excel Bootcamp includes 21 hours of hands-on training in formulas, functions, Pivot Tables, macros & more.	Add to cart
Excel for Business Bootcamp August 9–11 Weekdays 10–5pm	$549 21 Hours Queens or Live Online	Become an advanced Microsoft Excel user in just three days. This Excel Bootcamp includes 21 hours of hands-on training in formulas, functions, Pivot Tables, macros & more.	Add to cart
Intermediate Excel for Business August 10 Tuesday 10–5pm	$229 7 Hours Queens or Live Online	Go from beginner to experienced professional: summarize data with Pivot Tables, write advanced functions including VLOOKUP, and learn techniques to expedite your workflow.	Add to cart
Advanced Excel for Business August 11 Wednesday 10–5pm	$229 7 Hours Queens or Live Online	Become an Excel guru in this hands-on advanced training. You'll make functions more flexible, take Pivot Tables to the next level, automate tasks with macros, and learn advanced analytical tools.	Add to cart
Excel for Business Fundamentals August 13 Friday 10–5pm	$249 7 Hours Queens or Live Online	Learn all the basics to use Excel as your primary data processing tool. Create charts and tables, get started with formulas and functions, and format and print your output.	Add to cart
Intermediate Excel for Business August 16 Monday 10–5pm	$229 7 Hours Queens or Live Online	Go from beginner to experienced professional: summarize data with Pivot Tables, write advanced functions including VLOOKUP, and learn techniques to expedite your workflow.	Add to cart

Featured Excel Classes: In-Person (Manhattan) or Live Online

Excel for Business Bootcamp

Excel for Business Fundamentals

Intermediate Excel for Business

Advanced Excel for Business

Excel Certifications: In-Person (Manhattan) or Live Online

Excel Specialist Certification Program

Excel Expert Certification Program

Learn the Skills Guarantee™

Hands-on training in small groups

Time-tested curriculum and supporting materials

Learn from industry experts with teaching experience

Retake the course for free within one year

Corporate & Onsite Training

Private Training

Group Class Vouchers

Why Learn at NYIM

Highly Reviewed by Our Alumni

Excel Training Options for Queens Companies & Residents

Why Attend Excel Classes at NYIM?

Corporate Excel Training

Onsite Excel Courses in Queens

Attend Training Live Online

See What Students Are Saying About Live Online

Online Training Demo

Excel Resources

Free Resources

4 Advantages Gained by Attending Microsoft Excel Classes

10 Core Formatting Techniques in Excel

Top 10 Tips & Tricks You Need to Know in Microsoft Excel

Top Excel Shortcuts You Need for Financial Modeling

8 Reasons to Learn Excel

#1 Organize Your Data

#2 Learn the Industry-standard Tool

#3 Speed Up Calculations

#4 Analysis and Forecasting

#5 Save on IT Costs

#6 Increase Salary or Profit

#7 Increase Efficiency

#8 Easy to Learn