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

Price: $229.00

Course Code: 6G | Hours: 8

Microsoft Excel Training Class Overview - Level 2

The Career Center, 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 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 course, 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:

Next Classes:

Related Classes:

See Also:

Microsoft Excel Training Class Outline - Level 2:

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