MSOfficeExcel 2007 Tutorial Data Analysis 15 codes

1 AddInstall Data Analysis Add-in

2 AddInstall Solver Add-in

3 Clear an outline

4 Create a Group

5 Create a Scenario Summary or PivotTable Report

6 Create a What-If Scenario with Goal Seek

7 Create an Outline

8 Create and Show a Scenario

9 Create Validation Rules

10 Show a Scenario

11 To clear the circles

12 Ungroup outline data

13 Use Data Analysis Tools

14 Use Solver

15 View invalid data