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

Microsoft Excel Training Classes NYC

Sign up today for NYC's premier Microsoft Excel courses and corporate training! Beginner, intermediate, advanced, VBA, and private training, The Career Center has a wide offering of courses and class dates to choose from.

Looking for a boring, auditorium-style lecture? You won't find that here. Our Excel courses are taught by engaging instructors in interactive classes. You'll get personalized training in small class sizes and comfortable New York City facility. We offer a wide-range of training resources, including printed materials, a cutting-edge online video suite, and shortcut sheets.

Microsoft Excel is the most powerful spreadsheet and analytical tool used in business today, and our basic through advanced courses are proven to show unmatched results. You'll learn analytical formulas and functions, database management, Pivot Tables, Macros, VBA and more! Our Excel corporate training program has become the industry standard in providing flexible and customizable courses for any business.

If you're new to Excel, start with our beginner Microsoft Excel Level 1 course, where you'll review calculations, charts, formulas, and tables. In our intermediate class, Microsoft Excel Level 2, we'll dive into multi-input functions, Pivot Tables, and Sort & Filter. For advanced training, Microsoft Excel Level 3 will show you how to automate workbook functionality, use advanced lookup functions, and forecast data using What-If Analysis. If you're looking to automate your daily work, Microsoft Excel VBA Level 1 will show you how to program with macros and VBA.

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.

$229.00

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.

$229.00

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

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

$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

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.

$229.00

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

$345.00

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.

$425.00

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.

$345.00

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

$149.00

We offer free retakes to all our Excel Training NYC