Managing - Tabulating Data in Excel Description:

Abstract available at http://www.vgupta.com
Complete book in non-printable PDF Adobe Acrobat Format also available at http://vgupta.com/Products/Evaluation_copies.htm

You will need unzipping software to uncompress/unzip the book and sample files and the Adobe Acrobat Reader Software to read the book. Links and instructions available at http://vgupta.com/File_Readers.htm

No other book teaches data management and tabulation features in a simple tutorial style.
The books that cover these topics are usually categorized as "intermediate" or "advanced" level
and are written from the perspective of software developers or IT professionals

You will learn: Powerful data aggregation features like sub-totals & pivot reports, Data selection features, Data Validation and data entry features, and Linking Excel data sheets to enterprise or other database sources

Contents
1 Saving (Opening) In (From) Different File Formats
2 Data Entry Form
3 Reducing Errors In Data EntryÃãÂ#Ã#Â# Validation & Autocorrect
4 Using Fill And Other Tools To Save On Typing Time
5 Conditional Formatting
6 Sorting
7 Filter (Hiding The Data You Do Not Want To View)
8 Selecting All Cells/Content That Satisfy A Criterion
9 Subtotals
10 Pivot Reports
11 Scenarios And Goal Seek
12 Linking To A Database
13 Reading ASCII Text Data
14 Paste Special
15 Saving Or Transforming To Web And Document Formats




Size of file: 2 MB