|
Topic 33: Discover the Amazing Power of Excel 2003 Data Analysis Tools! |
Views: 2247
|
Thread Tools | Rate Thread |
#1
|
|||
|
|||
Topic 33: Discover the Amazing Power of Excel 2003 Data Analysis Tools!
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:
|