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