(212) 684-5151

Microsoft Excel Courses New York City

Training facility for Excel classes

Hands-on Excel training classes in Manhattan, NYC

Sign up today for NYC's premier Microsoft Excel classes and corporate training! Basic, intermediate, advanced, VBA, and private training, TCC has a wide offering of courses and class dates to choose from.

Our Excel courses are taught by engaging instructors in interactive classes. You'll get personalized training in small class sizes and our comfortable New York City facility. We offer a wide-range of training resources, including a cutting-edge online video suite. Our corporate training program has become the industry standard in providing flexible and customizable courses for any business.

Beginner to advanced Excel Training

Beginners, start with our Beginner Excel Course, where you'll review calculations, charts, formulas, and tables. In our Intermediate Excel Class, we'll dive into multi-input functions, Pivot Tables, and Sort & Filter. For advanced training, our Advanced Excel Class will show you how to automate workbook functionality, use advanced lookup functions, and forecast data using What-If Analysis. Microsoft Excel VBA & Macros will show you how to automate your daily work.

Beginner Excel Course Outline | Intermediate Excel Course Outline | Advanced Excel Course Outline

Upcoming Excel courses in New York City

Code Course Name Hours Price Location
6F Beginner Microsoft Excel 2016 7 $209 185 Madison Ave, NYC
6G Intermediate Microsoft Excel 2016 7 $209 185 Madison Ave, NYC
6H Advanced Microsoft Excel 2016 7 $209 185 Madison Ave, NYC
EB Microsoft Excel Bootcamp 21 $535 185 Madison Ave, NYC
VM Excel VBA and Macros Level I 7 $345 185 Madison Ave, NYC
VN Excel VBA and Macros Level II 7 $345 185 Madison Ave, NYC
VT Microsoft Excel PowerPivot 7 $299 185 Madison Ave, NYC
EF Useful Formulas and Functions 3 $375 185 Madison Ave, NYC
ED Create/Analyze Database in Excel 8 $675 185 Madison Ave, NYC
RD Relational Database Fundamentals 8 $425 185 Madison Ave, NYC

Beginner Microsoft Excel 2016
  • Perform Calculations
  • Modify Text
  • Format a Worksheet
  • Create Charts and Tables
  • Manage Workbooks
This beginner Excel course covers the fundamentals, including basic formulas, functions, formatting, printing, charts, & calculations. We'll also introduce you to some essential shortcuts to start boosting your speed. This class is the perfect introduction to Excel that will help you set a solid foundation in the software.

$209.00

Advanced Microsoft Excel 2016
  • Special Formatting
  • Advanced Functions
  • What If Analysis
  • Advanced Analytical Tools
  • Advanced Database Functions
  • Introduction to Macros
Our advanced Excel training will delve into data tables, goal seek, advanced database functions (including INDEX-MATCH), recording macros, and advanced analytical tools. Throughout the course you'll be building speed with our revolutionary time-saving tricks.

$209.00

Beginner VBA Course
  • Develop a Macro
  • Format with Macros
  • Make Interactive Worksheets
  • Work with Many Worksheets
  • Perform Calculations
In this beginner VBA & Macros course, you will learn to develop macros, perform calculations & more.

$345.00

PivotTables
  • Prepare data for PivotTable
  • Analyze Data Using PivotTables
  • Work with PivotCharts
  • Summarize PivotTable Data
Being able to harness the power of advanced PivotTable features and create PivotCharts, will help you gain a competitive edge. You will learn to summarize, organize and analyze data, in a way that can be easily presented, leading to data-driven business decisions.

$0.00

Advanced VBA Course
  • Navigate with Macros
  • Use Loops & Conditions
  • Create Forms
  • Understand Variables
  • Handle Events
In this advanced VBA & Macros training class, you will write scripts, create automated event processes & more.

$345.00

Intermediate Microsoft Excel 2016
  • Worksheet Management
  • Database Management
  • Database Functions
  • PivotTables & PivotCharts
  • Logical Functions
  • Statistical Functions
  • Pivot Tables
The intermediate Excel class focuses on more advanced functions (including VLOOKUP, COUNTIFS and SUMIFs), Sort & Filter, and Pivot Tables. You'll also learn crucial text-related features like splitting and joining text, removing duplicates, and data validation. Embedded in the course are pivotal time-saving tricks like Paste Special, keyboard shortcuts, and navigation techniques.

$209.00

Excel Bootcamp
  • Beginner Microsoft Excel 2016
  • Intermediate Microsoft Excel 2016
  • Advanced Microsoft Excel 2016
Sign up today for three levels of Excel at a 15% discount with our Microsoft Excel Bootcamp package: Basic, intermediate, advanced.

$535.00

Creating & Analyzing Database
  • Working with Databases
  • Using AutoFilter
  • Working with Advanced Filters
  • Lookup Formulas
  • Exporting and Importing Data
  • Creating/Revising PivotTable
Provides students with the knowledge and skills, to use advanced Excel features, in creating and analyzing databases. Learn how to sort and manage data; filter and query data; and apply lookup and database functions. Learn to analyze and evaluate the information in the databases by creating pivot table and pivot charts.

$675.00

Formulas & Functions
  • Apply Formula and Functions Basic
  • Statistical and Logical Functions
  • Lookup and Reference Formulas
  • Text Formulas
  • Date and Time Formulas
  • Array and Database Functions
Get a head start in acquiring the knowledge of using Formulas in your daily work. Want to expand your Microsoft Excel knowledge? This one day Excel training course will provide answers to your everyday workplace questions. This Excel course is for users at all levels, from beginners to intermediate and advanced.

$375.00

Excel: PowerPivot
  • Create Reports
  • Manipulate Data
  • DAX functions
  • Distribute PowerPivot Data
  • Import Data
  • Linked Tables
You will make use of the PowerPivot add-in to import data from various sources and create a dynamic report.

$0.00

What will I learn in these Excel classes?

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 which 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. How? With Excel. Because that is the kind of magnitude that this software possesses, and these are the types of skills that Excel makes easily transferable to the user.

We offer free retakes to all our Excel Training NYC