Details
The Career Center’s, hands on, instructor-led, Intermediate Excel training course class in New York City will teach you more advanced techniques to organize, calculate, analyze, revise, and present your data. Our Excel class is classroom based instruction with a live instructor that will cover topics such as Advanced Formulas and Functions, Tables, Lists and Charts, and PivotTables and PivotCharts. The Career Center’s Classroom Excel Course is conducted at our facility in Midtown Manhattan NYC. We also provide Onsite Excel Training Courses, Offsite Excel Training Classes or 1:1 Private Excel Lessons.
Upon successful completion of this Microsoft Excel 2016 training, students will be able to:
- Work with Functions
- Work with Lists
- Analyze Data
- Visualize Data with Charts.
- Create advanced formulas.
- Analyze Data with PivotTables and PivotCharts.
Prerequisites:
Students are recommended to take the following course or possess equivalent knowledge:
- Microsoft Excel Level 1 2016
Outline
Lesson 1: Working with Functions
- Topic A: Work with Ranges
- Topic B: Use Specialized Functions
- Topic C: Work with Logical Functions
- Topic D: Work with Date & Time Functions
- Topic E: Work with Text Functions
Lesson 2: Working with Lists
- Topic A: Sort Data
- Topic B: Filter Data
- Topic C: Query Data with Database Functions
- Topic D: Outline and Subtotal Data
Lesson 3: Analyzing Data
- Topic A: Create and Modify Tables
- Topic B: Apply Intermediate Conditional Formatting
- Topic C: Apply Advanced Conditional Formatting
Lesson 4: Visualizing Data with Charts
- Topic A: Create Charts
- Topic B: Modify and Format Charts
- Topic C: Use Advanced Chart Features
Lesson 5: Using PivotTables and PivotCharts
- Topic A: Create a PivotTable
- Topic B: Analyze PivotTable Data
- Topic C: Present Data with PivotCharts
- Topic D: Filter Data by Using Timelines and Slicers
The Career Center is a full-service training provider that offers training services in a wide array of courses, including applications such as Microsoft Office, the Adobe Creative Suite, SQL, QuickBooks and AutoCAD.
As a Microsoft Silver Learning Partner we also offer all of the Microsoft Official Courses (MOC) and proudly accept Microsoft Software Assurance Training Vouchers.
The Career Center offers computer courses and hands-on training that helps people of all levels, from beginners to advanced users, increase their computer knowledge & efficiency. Conveniently located on the corner of 34th Street & Madison Avenue, The Career Center offers over 100 public classes in popular softwares.
The Career Center also offers other training solutions including:
- Onsite Training
- Private Corporate Classes
- Private Computer Tutoring
- Lab Rentals
For more information about individual or corporate training, please contact us at your convenience at (212) 684-5151 or [email protected]