(212) 684-5151

185 Madison Ave., Suite 1104
New York, NY 10016

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

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

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.


Excel VBA & Macros Level II
  • Navigate with Macros
  • Use Loops & Conditions
  • Create Forms
  • Understand Variables
  • Handle Events
Automate your job tasks in Microsoft Office Excel. The course is intended for advanced Microsoft Excel professionals that need to automate Excel spreadsheet using Visual Basic for Applications (VBA).


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.


Excel VBA & Macros Level I
  • Develop a Macro
  • Format with Macros
  • Make Interactive Worksheets
  • Work with Many Worksheets
  • Perform Calculations
Automate your job tasks in Microsoft Office Excel. The course is intended for advanced Microsoft Excel professionals that need to automate Excel spreadsheet using Visual Basic for Applications (VBA).


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