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

Microsoft Excel Training Classes NYC

Looking to learn Excel? The Career Center has Excel classes and courses for every skill level, from beginner to advanced. Excel trainings cover 2003, 2007, 2010, 2013, 365 and Excel 2016. Courses are designed for students to create, edit, format and print basic Microsoft Office Excel worksheets; gain skill sets for calculating data using functions and formulas; sorting and filtering data, using PivotTables and PivotCharts for analyzing data; and customizing workbooks. The Career Center offers 9 levels of Microsoft Excel training, all conveniently located in the New York City area.

Excel Level 1

  • Intro to Basics
  • Simple Calculations
  • Move Data
  • Format Data
  • Print Workbooks
Excel 2010 Level 1 covers the basic skills, including: creating a basic spreadsheet, performing calculations, and modifying, formatting and printing an Excel spreadsheet.


Excel Level 2

  • Sort & Filter
  • Charts
  • PivotTables
  • Advanced Calculations
Excel 2010 Level 2 concentrates on some more advanced skills, including: using advanced formulas, organizing worksheet and table, creating and modifying charts, analyzing data using PivotTables, Slicers, and PivotCharts, inserting and modifying graphic objects in a worksheet and customizing and enhancing Microsoft Excel workbooks.


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.


Creating & Analyzing Database

  • Working with Databases
  • Using AutoFilter
  • Working with Advanced Filters
  • Lookup Formulas
  • Exporting and Importing Data
  • Creating/Revising PivotTable
This 1-day course provides students with the knowledge and skills, to use advanced Excel features, in creating and analyzing databases. Students will learn how to sort and manage data; filter and query data; and apply lookup and database functions. Students will learn to analyze and evaluate, the information, in databases, by creating pivot table and pivot charts.