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 classes and courses for every skill level, from beginner to advanced, and cover Excel 2003, 2007, 2010, 2013 Excel 2016 and Excel 365. These courses are designed for students who desire to gain the necessary skills to create, edit, format and print basic Microsoft Office Excel worksheets and gain advanced skill sets necessary 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.

$229.00

Excel Level 2

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

$229.00

VBA Level 1

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

$345.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 as well as expand your Microsoft Excel knowledge. This one day course will empower you to have answers to excel question at your fingertip. There a numerous and a varied number of new tips you will learn irrespective of the Excel version used. This course will serve as a refresher as well as a reference. The course is for users at all levels, from beginners through intermediate and advanced.

$345.00

Excel: Pivot Tables

  • Make Pivot Table
  • Analyze Data
  • Make Pivot Chart
  • Summarize Data
  • Create Slicers
Excel PivotTables 2010 is for creating and analyzing PivotTable data. This course is meant for people with a sound working knowledge of Microsoft Excel and general computer proficiency. Students will learn how to build a PivotTable, analyze data using PivotTables, and present PivotTable data visually.

$149.00

VBA Level 2

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

$345.00

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 features in creating and analyzing databases. Students will learn how to sort and manage data in lists; filter and query data; apply lookup and database functions. Students will also learn how to analyze and evaluate the information in databases by creating pivot table and pivot charts.

$345.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.

$399.00