Managing & Tabulating Data in Excel

Buy Managing & Tabulating Data in Excel    $9.99 (as at Jan 2005) 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 Managing & Tabulating Data in Excel homepage Audio | Business & Finance | Desktop Enhancements | Games | Home & Education | Internet | Multimedia & Design | Software Development | Utilities | Web Authoring | Home