185 Madison Ave. at 34th St., Suite 1104, New York, NY 10016 • 212-684-5151

Excel Training

The Career Center has Microsoft Excel Training Class options for any level, from Beginner to Advanced.

Whether you are a beginner seeking to learn basic excel spreadsheet skills, or an Advanced user looking to automate Excel, we have just the right Excel class for you.

All of our Excel training classes are instructor led, hands-on and in small classes. We offer day, evening and weekend class options, providing a convenient schedule for even the busiest professional.

Beginner Excel
  • 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 Excel
  • 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
  • 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 Excel
  • 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
  • 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