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

Upcoming Excel courses in New York City

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

Beginner Microsoft Excel 2016
  • Perform Calculations
  • Modify a Worksheet
  • Format a Worksheet
  • Print Workbooks
  • Manage Workbooks
Covers the basic skills, including creating a basic spreadsheet, performing calculations, and modifying, formatting and printing an Excel spreadsheet.


Advanced Microsoft Excel 2016
  • Multiple Worksheets
  • Lookup Functions
  • Share/Protect Workbooks
  • Automate Workbook
  • Sparklines/Map Data
  • Forecast Data
Focuses on advanced concepts, including: streamlining workflow; collaborating with other workbook users; auditing worksheets; analyzing data; working with multiple workbooks; importing and exporting data; integrating Excel data with the web, and structuring workbooks with XML.


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.


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.


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.


Intermediate Microsoft Excel 2016
  • Functions
  • Charts
  • Advanced Formulas
  • PivotTables & PivotCharts
  • Lists
  • Analyze Data
Concentrates on more advanced skills, including: using advanced formulas; organizing worksheets and tables; creating and modifying charts; analyzing data using PivotTables; Slicers; PivotCharts; inserting and modifying graphic objects; and customizing and enhancing Microsoft Excel workbooks.


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.


Database Cleansing
  • Identify Bad Practices
  • Analyze Data Integrity
  • Correct Poor Data Using Formulas
  • Structure Tables For Import
  • Analyze Data Integrity
Explore various issues that cause databases to be unreliable and identify tools that can be used to correct the underlying problems.


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.


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


We offer free retakes to all our Excel Training NYC