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