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

Microsoft Excel 2010 Classes

Microsoft Excel 2010 is the Spreadsheet program in the Microsoft Office Suite. These courses are designed for students who desire to gain the necessary skills to create, edit, format, print basic Microsoft Office Excel 2010 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 6 levels of Microsoft Excel training.

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


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.


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


Buy Any 3 Classes Get 10% Off

(212) 684-5151