Excel for Business Bootcamp

Beginner to Advanced Excel Training in NYC

Become an advanced Microsoft Excel user in just three days. Begin with data entry, charts, and essential shortcuts in Excel Fundamentals. Go to the next level with Pivot Tables and VLOOKUP in Intermediate Excel. Automate your workflow by recording macros in Advanced Excel. You'll learn everything you need to know to become an Excel pro.

This package includes our Fundamentals, Intermediate, and Advanced Excel classes at a 15% discount, along with three premium video suites and training manuals. Choose a predefined track or customize your own schedule - weekday, night, and weekend scheduling options are available. 

  • icon for small classesSmall classes
  • icon for small classesComputer provided
  • icon for small classesBook included
  • icon for small classesFree retake

Register for a Package 

$535 21 Hours 185 Madison Avenue, NYC In-person classroom training

Corporate training available

Email us for information

Custom Schedule
Register

Excel for Business Fundamentals

Thu, May 30, 10am–5pm

Intermediate Excel for Business

Fri, May 31, 10am–5pm

Advanced Excel for Business

Thu, Jun 13, 10am–5pm

Excel for Business Fundamentals

Thu, May 30, 10am–5pm

Intermediate Excel for Business

Fri, May 31, 10am–5pm

Advanced Excel for Business

Mon, Jun 3, 10am–5pm

Excel for Business Fundamentals

Sat, Jun 1, 10am–5pm

Intermediate Excel for Business

Sun, Jun 2, 10am–5pm

Advanced Excel for Business

Sat, Jun 22, 10am–5pm

Excel for Business Fundamentals

Sat, Jun 1, 10am–5pm

Intermediate Excel for Business

Sun, Jun 2, 10am–5pm

Advanced Excel for Business

Mon, Jun 3, 10am–5pm

Excel for Business Fundamentals

Sat, Jun 1, 10am–5pm

Intermediate Excel for Business

Sat, Jun 15, 10am–5pm

Advanced Excel for Business

Sat, Jun 22, 10am–5pm

Excel for Business Fundamentals

Mon–Tue, Jun 3–4, 6–9pm

Intermediate Excel for Business

Wed–Thu, Jun 5–6, 6–9pm

Advanced Excel for Business

Wed–Thu, Jun 12–13, 6–9pm

Excel for Business Fundamentals

Wed, Jun 5, 10am–5pm

Intermediate Excel for Business

Thu, Jun 6, 10am–5pm

Advanced Excel for Business

Thu, Jun 13, 10am–5pm

Excel for Business Fundamentals

Tue, Jun 11, 10am–5pm

Intermediate Excel for Business

Wed, Jun 12, 10am–5pm

Advanced Excel for Business

Thu, Jun 13, 10am–5pm

Excel for Business Fundamentals

Mon, Jun 17, 10am–5pm

Intermediate Excel for Business

Tue, Jun 18, 10am–5pm

Advanced Excel for Business

Tue, Jun 25, 10am–5pm

Excel for Business Fundamentals

Fri, Jun 21, 10am–5pm

Intermediate Excel for Business

Mon, Jun 24, 10am–5pm

Advanced Excel for Business

Tue, Jun 25, 10am–5pm

Excel for Business Fundamentals

Mon, Jul 1, 10am–5pm

Intermediate Excel for Business

Tue, Jul 2, 10am–5pm

Advanced Excel for Business

Mon, Jul 8, 10am–5pm

Excel for Business Fundamentals

Mon–Tue, Jul 1–2, 6–9pm

Intermediate Excel for Business

Mon–Tue, Jul 8–9, 6–9pm

Advanced Excel for Business

Mon–Tue, Jul 15–16, 6–9pm

Excel for Business Fundamentals

Wed, Jul 10, 10am–5pm

Intermediate Excel for Business

Thu, Jul 11, 10am–5pm

Advanced Excel for Business

Wed, Jul 17, 10am–5pm

Excel for Business Fundamentals

Sat, Jul 13, 10am–5pm

Intermediate Excel for Business

Sun, Jul 14, 10am–5pm

Advanced Excel for Business

Sat, Jul 20, 10am–5pm

Excel for Business Fundamentals

Sat, Jul 13, 10am–5pm

Intermediate Excel for Business

Sat, Jul 27, 10am–5pm

Advanced Excel for Business

Sun, Aug 18, 10am–5pm

Excel for Business Fundamentals

Mon, Jul 15, 10am–5pm

Intermediate Excel for Business

Tue, Jul 23, 10am–5pm

Advanced Excel for Business

Tue, Jul 30, 10am–5pm

Excel for Business Fundamentals

Mon, Jul 15, 10am–5pm

Intermediate Excel for Business

Tue, Jul 16, 10am–5pm

Advanced Excel for Business

Wed, Jul 17, 10am–5pm

Excel for Business Fundamentals

Wed–Thu, Jul 17–18, 6–9pm

Intermediate Excel for Business

Wed–Thu, Jul 31–Aug 1, 6–9pm

Advanced Excel for Business

Wed–Thu, Aug 7–8, 6–9pm

Excel for Business Fundamentals

Mon, Jul 22, 10am–5pm

Intermediate Excel for Business

Tue, Jul 23, 10am–5pm

Advanced Excel for Business

Tue, Jul 30, 10am–5pm

Excel for Business Fundamentals

Mon, Jul 22, 10am–5pm

Intermediate Excel for Business

Mon, Jul 29, 10am–5pm

Advanced Excel for Business

Fri, Aug 9, 10am–5pm

Excel for Business Fundamentals

Fri, Jul 26, 10am–5pm

Intermediate Excel for Business

Mon, Jul 29, 10am–5pm

Advanced Excel for Business

Tue, Jul 30, 10am–5pm

Excel for Business Fundamentals

Fri, Jul 26, 10am–5pm

Intermediate Excel for Business

Fri, Aug 2, 10am–5pm

Advanced Excel for Business

Fri, Aug 9, 10am–5pm

Excel for Business Fundamentals

Sun, Jul 28, 10am–5pm

Intermediate Excel for Business

Sun, Aug 11, 10am–5pm

Advanced Excel for Business

Sun, Aug 18, 10am–5pm

Excel for Business Fundamentals

Mon–Tue, Jul 29–30, 6–9pm

Intermediate Excel for Business

Mon–Tue, Aug 12–13, 6–9pm

Advanced Excel for Business

Wed–Thu, Sep 4–5, 6–9pm

Excel for Business Fundamentals

Mon–Tue, Jul 29–30, 6–9pm

Intermediate Excel for Business

Wed–Thu, Jul 31–Aug 1, 6–9pm

Advanced Excel for Business

Wed–Thu, Aug 7–8, 6–9pm

Excel for Business Fundamentals

Thu, Aug 1, 10am–5pm

Intermediate Excel for Business

Thu, Aug 8, 10am–5pm

Advanced Excel for Business

Wed, Aug 21, 10am–5pm

Excel for Business Fundamentals

Thu, Aug 1, 10am–5pm

Intermediate Excel for Business

Fri, Aug 2, 10am–5pm

Advanced Excel for Business

Fri, Aug 9, 10am–5pm

Excel for Business Fundamentals

Wed, Aug 7, 10am–5pm

Intermediate Excel for Business

Thu, Aug 8, 10am–5pm

Advanced Excel for Business

Fri, Aug 9, 10am–5pm

Excel for Business Fundamentals

Wed, Aug 7, 10am–5pm

Intermediate Excel for Business

Thu, Aug 15, 10am–5pm

Advanced Excel for Business

Wed, Aug 21, 10am–5pm

Excel for Business Fundamentals

Sat, Aug 10, 10am–5pm

Intermediate Excel for Business

Sun, Aug 11, 10am–5pm

Advanced Excel for Business

Sun, Aug 18, 10am–5pm

Excel for Business Fundamentals

Sat, Aug 10, 10am–5pm

Intermediate Excel for Business

Sat, Aug 24, 10am–5pm

Advanced Excel for Business

Sat, Sep 14, 10am–5pm

Excel for Business Fundamentals

Tue, Aug 13, 10am–5pm

Intermediate Excel for Business

Tue, Aug 20, 10am–5pm

Advanced Excel for Business

Tue, Sep 3, 10am–5pm

Excel for Business Fundamentals

Tue, Aug 13, 10am–5pm

Intermediate Excel for Business

Thu, Aug 15, 10am–5pm

Advanced Excel for Business

Wed, Aug 21, 10am–5pm

Excel for Business Fundamentals

Wed–Thu, Aug 14–15, 6–9pm

Intermediate Excel for Business

Wed–Thu, Aug 28–29, 6–9pm

Advanced Excel for Business

Wed–Thu, Sep 4–5, 6–9pm

Excel for Business Fundamentals

Mon, Aug 19, 10am–5pm

Intermediate Excel for Business

Mon, Aug 26, 10am–5pm

Advanced Excel for Business

Tue, Sep 3, 10am–5pm

Excel for Business Fundamentals

Mon, Aug 19, 10am–5pm

Intermediate Excel for Business

Tue, Aug 20, 10am–5pm

Advanced Excel for Business

Wed, Aug 21, 10am–5pm

Excel for Business Fundamentals

Fri, Aug 23, 10am–5pm

Intermediate Excel for Business

Fri, Aug 30, 10am–5pm

Advanced Excel for Business

Tue, Sep 3, 10am–5pm

Excel for Business Fundamentals

Fri, Aug 23, 10am–5pm

Intermediate Excel for Business

Mon, Aug 26, 10am–5pm

Advanced Excel for Business

Tue, Sep 3, 10am–5pm

Excel for Business Fundamentals

Sun, Aug 25, 10am–5pm

Intermediate Excel for Business

Sun, Sep 8, 10am–5pm

Advanced Excel for Business

Sat, Sep 14, 10am–5pm

Excel for Business Fundamentals

Mon–Tue, Aug 26–27, 6–9pm

Intermediate Excel for Business

Wed–Thu, Aug 28–29, 6–9pm

Advanced Excel for Business

Wed–Thu, Sep 4–5, 6–9pm

Excel for Business Fundamentals

Thu, Aug 29, 10am–5pm

Intermediate Excel for Business

Thu, Sep 5, 10am–5pm

Advanced Excel for Business

Thu, Sep 12, 10am–5pm

Excel for Business Fundamentals

Thu, Aug 29, 10am–5pm

Intermediate Excel for Business

Fri, Aug 30, 10am–5pm

Advanced Excel for Business

Tue, Sep 3, 10am–5pm

Excel for Business Fundamentals

Wed, Sep 4, 10am–5pm

Intermediate Excel for Business

Thu, Sep 5, 10am–5pm

Advanced Excel for Business

Thu, Sep 12, 10am–5pm

Excel for Business Fundamentals

Wed, Sep 4, 10am–5pm

Intermediate Excel for Business

Wed, Sep 11, 10am–5pm

Advanced Excel for Business

Tue, Sep 24, 10am–5pm

Excel for Business Fundamentals

Sat, Sep 7, 10am–5pm

Intermediate Excel for Business

Sun, Sep 8, 10am–5pm

Advanced Excel for Business

Sat, Sep 14, 10am–5pm

Excel for Business Fundamentals

Tue, Sep 10, 10am–5pm

Intermediate Excel for Business

Tue, Sep 17, 10am–5pm

Advanced Excel for Business

Tue, Sep 24, 10am–5pm

Excel for Business Fundamentals

Tue, Sep 10, 10am–5pm

Intermediate Excel for Business

Wed, Sep 11, 10am–5pm

Advanced Excel for Business

Thu, Sep 12, 10am–5pm

Excel for Business Fundamentals

Mon, Sep 16, 10am–5pm

Intermediate Excel for Business

Mon, Sep 23, 10am–5pm

Advanced Excel for Business

Tue, Sep 24, 10am–5pm

Excel for Business Fundamentals

Mon, Sep 16, 10am–5pm

Intermediate Excel for Business

Tue, Sep 17, 10am–5pm

Advanced Excel for Business

Tue, Sep 24, 10am–5pm

Show more packages

The Excel for Business Bootcamp includes

Excel for Business Fundamentals

Master the core Microsoft Excel functions in this one-day course. Automate calculations and data entry. Apply formatting to text and cells to make your spreadsheet scannable and visually appealing. In this hands-on training, you will learn all the basics to use Excel as your primary data processing tool. You'll produce polished and print ready spreadsheets while learning tricks to accelerate your workflow.

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. Use tools and formulas to format text. Manipulate data visuals with advanced charting skills. Use statistical formulas like COUNTIFS and SUMIFS to learn more about your data. At the end of intermediate Excel, you'll unlock powerful techniques that will help you complete tasks more quickly.

Advanced Excel for Business

Advance your career with this essential course for professionals that use Excel daily. You'll make functions more flexible, take Pivot Tables to the next level, and automate tasks with macros. Utilize Excel's most important tools with training in core database functions. If you have a strong working knowledge in Excel and want to save even more time with custom shortcuts and advanced features, this is the perfect course for you. 

Full Course Syllabus

Download PDF Outline

Excel for Business Fundamentals

Introduction

  • Data Entry
  • Interface

Formulas

  • Autofill
  • Calculations
  • True or False
  • AutoSum Functions
  • Text Functions
  • Multi-Input Functions
  • Absolute Cell References

Formatting

  • Formatting
  • Format Painter
  • Conditional Format

Charts & Tables

  • Line Chart
  • Column Chart
  • Pie Chart
  • Tables

Workbook Management

  • Printing
  • Worksheets
  • Repeat Action
  • Shortcuts
  • 5 Fundamental keyboard shortcuts and a review of others previously covered

End of Class Project

  • Project
  • Save and Close

Intermediate Excel for Business

Worksheet Management

  • Navigation
  • Paste Special

Working with Text

  • Splitting Text
  • Joining Text
  • Named Ranges
  • Data Validation
  • Sort & Filter
  • Remove Duplicates

Database Functions

  • VLOOKUP
  • HLOOKUP
  • VLOOKUP - Closet Match

Logical Functions

  • AND, OR
  • IF statements

Pivot Tables

  • Pivot Tables
  • Pivot Tables & Grouping
  • Multiple Pivot Tables

Statistical Functions

  • Ranking
  • COUNTIFS
  • SUMIFS

Advanced Charts

  • Combo Charts

End of Class Project

  • Project

Advanced Excel for Business

Cell Management

  • Advanced Cell Locking
  • Hot Keys
  • Windows
  • Cell Auditing

Special Formatting

  • Date functions
  • Conditional Formatting-Formulas

Advanced Functions

  • Nested IF statements
  • IF statements with AND/OR

What If Analysis

  • Goal Seek
  • Data Tables

Advanced Analytical Tools

  • Data Consolidation
  • Conditional SumProduct
  • Pivot Table-Calculations
  • Pivot Charts

Advanced Database Functions

  • MATCH function
  • VLOOKUP-MATCH
  • INDEX-MATCH
  • INDEX-Double MATCH

Introduction to Macros

  • Recording Macros
  • Relative Macros

End of Class Project

  • Project

Excel Bootcamp New York City

Why attend NYIM's Excel Bootcamp in NYC?

Microsoft Excel is an essential tool for professionals and enterprises in New York City and around the globe. It’s used to store data, conduct analysis, and manage finance and accounting functions. Excel is a vital application for the modern workforce. 

In our Microsoft Excel Bootcamp in NYC, you’ll go from beginner to advanced in three days. You’ll learn the most advanced functions of Excel including Pivot Tables, VLOOKUP, and macros. At the end of the course, you’ll complete a course project that you can show off to prospective employers to validate your skills.

At NYIM, We Offer:

  • Flexible scheduling: weekday, weeknight & weekend classes
  • Engaging and interactive instructors
  • Revolutionary video suite with several hours of premium content
  • Proprietary course manual and shortcut sheets
  • Small class sizes for personalized attention

Start with Essential Skills for Excel 

Are you new to Excel? No problem! Our instructor will guide you through the core business functions in our Excel Fundamentals course. Our beginner course starts with data entry, formatting, and other essential tasks like creating charts. The class is entirely hands-on, meaning you'll be working on real-world exercises and projects all day.

Increase Your Knowledge with Pivot Tables and VLOOKUP

In the intermediate course, we'll build upon the foundation we set in Excel Fundamentals, learning how to work with text, navigate with shortcuts, create advanced formulas, and summarize data with Pivot Tables. By the end of the day, you'll have 20+ essential functions and formulas at your fingertips, and you'll be working exponentially faster in Excel. 

Automate Tasks and Create Advanced Visuals

In the Advanced Excel class, students reinforce intermediate-level concepts while taking skills to the next level. Extend your knowledge of Pivot Tables with advanced formulas and Pivot Charting. Master advanced functions, data visualizations, and Hot Keys. You'll impress your colleagues with your ability to automate repetitive formatting and calculations tasks by recording macros.

The Benefits of Excel Bootcamp at NYIM

Flexible Scheduling

With our flexible scheduling options, you can customize Microsoft Excel training to suit your learning style and take classes when it’s most convenient for you. NYIM offers weekday, weekend, and weeknight availability to accommodate busy professionals. If you're not sure, you can lock in affordable rate by purchasing a package and choosing your class dates at a later time. 

Students who want more time to review concepts can schedule the beginner, intermediate, and advanced courses with breaks in between to practice concepts learned in class. Quick learners can sign up for back-to-back sessions to go from beginner to advanced in a single weekend. There’s no pressure to choose your courses right away. After signing up, you have two years to complete the program.

Engaging Instructors

NYIM instructors are seasoned professionals with years of real-world experience using MS Excel. Our teachers walk you through class exercises with patience and a sense of humor to make training more enjoyable! Whether you’re new to MS Excel or have been using the program for years, each student receives personalized attention when needed to clarify activities or directions.

Free Access to Video Training

Included with the package, you will receive access to three premium video suites—beginner, intermediate, and advanced training videos in Excel. Each video suite has several hours of content demonstrating how to perform functions, calculations, and implement shortcuts. The entire video suite, a $285 value, is provided free of charge to students that enroll in the bootcamp.

Custom Training Manual & Shortcut Sheets

Our custom training manuals are developed by our instructors to follow the class structure and exercises. After each course, the workbook is a valuable resource to review and practice exercises that you learned in class. As a bonus for our Excel students, we provide quick-reference shortcut sheets for common shortcuts. You won’t have to read your course workbook book to review time-saving navigational keys.

Small Classes and Personalized Attention

Our small class sizes give us the opportunity to work with students from a variety of backgrounds and experience levels. At the end of each section, you’ll have a chance to perform practice exercises that reinforce the material. Instructors are available to answer questions, for both beginners and experts during the course.

Sign Up For our Microsoft Excel Bootcamp at NYIM!

At NYIM, we value our students and take pride in being the #1 Microsoft Excel Bootcamp in New York City. We have all the tools you need to succeed, including a modern computer lab with the latest version of Microsoft Excel. Our proven model of instruction, customized training, small class sizes, and premium video suite offer all the tools you need to master Microsoft Excel. Sign up for our Excel Bootcamp today!