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

Excel 2010 Data Analysis Tools

Objective

Learn to use various add-ins and other Excel tools to analyze and manipulate data effectively.

Prerequisite Skills

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

(Suggested courses: Excel 2010 Getting Started, Excel 2010 Functions & Formulas, Excel 2010 Formatting Spreadsheets I, and Excel 2010 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.

Class Length

90 minutes

Delivery Options

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

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

  • Virtual classroom - one on one
    (Register for a 45-minute 1-on-1 Application Support session. Cost is $70 per student per session.)

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

 

   

   

   Print this page without top and side navigation

View a virtual classroom demo