Go Back   Wiki NewForum > Career Forum > Tech Forum & Tutorial > IT Forum > MS office Tutorials (2003 & 2007) > MS Excel 2003

Sponsored Links

MS Excel 2003 Step-by-step Excel 2003 Tutorials, Tips and Training

Views: 926  
Thread Tools Rate Thread Display Modes
Old 01-26-2010, 11:44 AM
seema seema is offline
Join Date:
Oct 2009
Posts: 5,551
Default 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.

Reply With Quote

New topics in MS Excel 2003

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Powered by vBulletin® Version 3.8.10
Copyright ©2000 - 2019, vBulletin Solutions, Inc.