Excel Classes NYC
The Career Center is the premier provider of Microsoft Excel Classes in NYC. We offer Public Excel Courses, Excel Corporate Onsite Classes, private 1:1 and group training sessions.
We currently offer our public classes in Excel 2010 and Excel 2016. All of our courses have a live instructor with a hands-on classroom experience.
EXCEL CLASSES NYC - BOTH CORPORATE TRAINING AND PUBLIC CLASSES FOR INDIVIDUALS
Excel Level 1
Excel 2016 Level 1 covers the basic skills, including: creating a basic spreadsheet, performing calculations, and modifying, formatting and printing an Excel spreadsheet.
Excel Level 2
Excel 2016 Level 2 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.
Excel Level 3
Excel 2016, Level 3 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.
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.
- 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.
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 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.
- 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.
We offer free retakes to all our Excel Classes NYC