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

Price: $229.00

Course Code: 6H | Hours: 8

Microsoft Excel Training Class Overview - Level 3

The Career Center Advanced Excel training in New York City is a hands on, instructor-led class that will teach you more advanced techniques to organize, calculate, analyze, revise, and present your data. This classroom based live Excel class with a live instructor will cover topics such as Using Multiple Worksheet and Workbooks, VLOOKUPS, HLOOKUPS, Sharing and Protecting Worksheets and Workbooks, Data Validation, Sparklines, Data Mapping and Forecasting data. The Career Center Classroom Excel Training 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 multiple worksheets and workbooks
  • Use Lookup functions and formula auditing
  • Share and protect workbooks
  • Automate workbook functionality
  • Create sparklines and map data
  • Forecast data

Prerequisites:

Students are recommended to take the following course or possess equivalent knowledge:

Next Classes:

Related Classes:

See Also:

Microsoft Excel Training Course Outline - Level 3:

Lesson 1: Working with Multiple Worksheets and Workbooks

• Topic A: Use Links and External References
• Topic B: Use 3-D References
• Topic C: Consolidate Data

Lesson 2: Using Lookup Functions and Formula Auditing

• Topic A: Use Lookup Functions (VLOOKUP, HLOOKUP, Index & Match)
• Topic B: Trace Cells
• Topic C: Watch and Evaluate Formulas

Lesson 3: Sharing and Protecting Workbooks

• Topic A: Collaborate on a Workbook
• Topic B: Protect Worksheets and Workbooks

Lesson 4: Automating Workbook Functionality

• Topic A: Apply Data Validation
• Topic B: Search for Invalid Data and Formulas with Errors
• Topic C: Work with Macros

Lesson 5: Creating Sparklines and Mapping Data

• Topic A: Create Sparklines
• Topic B: Map Data

Lesson 6: Forecasting Data

• Topic A: Determine Potential Outcomes Using Data Tables
• Topic B: Determine Potential Outcomes Using Scenarios
• Topic C: Use the Goal Seek Feature
• Topic D: Forecasting Data Trends