Elert & Associates Technology Training
Home About Services Delivery Methods Courseware Testimonials Contact Us
Student Links Register for a Class Course Catalog Student Resources

Excel Data Analysis Tools

Objective

Learn to use the Scenario Manager, Goal Seek, and Solver tools to effectively analyze data in your worksheets. Also learn to create data tables and consolidate data. Finally, learn to use Excel 2016's one-click forecasting tool.

Prerequisite Skills

Comfortable with advanced Excel capabilities, including functions, formulas, and formatting options.

(Suggested courses: Excel Getting Started, Excel Functions & Formulas, Excel Formatting Spreadsheets I, and Excel Working with Workbooks)

Course Description

Are you experienced in Excel but want to learn additional, more advanced ways to view and analyze your worksheet data? Do you want to use tools such as the Scenario Manager, Goal Seek, and Solver to work with data?

Attend this course if you want to:

  • Use the Scenario Manager to quickly substitute different groups of values in a worksheet.

  • Use "what-if" analysis tools (Goal Seek and Solver) to forecast formula results when the input values are unknown.

  • Create a data table to show how changing certain values affects the results of the formulas.

  • Consolidate similar data from multiple worksheets onto one worksheet.

  • Use Excel 2016's one-click forecasting tool.

Class Length

90 minutes

Delivery Options

  • Virtual classroom - public
    ($70 per student; check times and register here)

  • Virtual classroom - private (up to ten people from the same organization)
    ($480 per class; contact us for more details)

  • On-site instructor-led
    (Contact us for details)

 

   

   

   Print this page without top and side navigation

View a virtual classroom demo