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.
- 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.
- Sort & Filter
- 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.
- Intro Macros
- Protection & Sharing
- Audit Calculations
- Link Workbooks
- Import & Export Data
Excel 2010 Level 3 focuses on the more advanced concepts, including: streamlining the 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.
- 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.
- 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.