Topic 33: Discover the Amazing Power of Excel 2003 Data Analysis Tools!

[seema]

Sorting and filtering lists: With the information you have in a list, you can sort and display data that meet certain criteria, insert formulas to calculate subtotals, and create summary tables.

Subtotals: Excel can quickly goes through the whole table and inserts rows and adds totals for the column that you specify.

PivotTable: It is a quick way to analyze data such as summing up data in a rectangular table shape when you have more than one category to summarize upon.

What-If Analysis: The ability to assist in decision making with dynamic models. A dynamic model uses formulas that instantly recalculate when you change values in cells that are used by the formulas.

Similar Threads:

• Topic 27: Discover the Excel Automatic Calculaion Capability!
• Topic 15: Discover the Full Potential of Excel IF() Function
• Topic 13: Discover What You can do with Excel conditional Formatting
• Topic 4: Formatting Excel data according to your needs
• Topic 2: Start Exploring Microsoft Excel 2003