What do you want to learn today?

Details

Microsoft Excel Training Class Overview - Level 3

The Career Center’s 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’s 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 Microsoft Excel 2016 training, 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:

  • Microsoft Excel Level 1 2016
  • Microsoft Excel Level 2 2016

Outline

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
  • 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
Reviews
Be the first to write a review about this course.
Write a Review

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]

Sending Message
Please wait...
× × Speedycourse.com uses cookies to deliver our services. By continuing to use the site, you are agreeing to our use of cookies, Privacy Policy, and our Terms & Conditions.