Comprehensive Excel Abstract available at http://www.vgupta.com Complete book in non-printable PDF Adobe Acrobat Format also available at...
Download

Comprehensive Excel Ranking & Summary

Comprehensive Excel Tags

Comprehensive 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 The chapters are sequenced based on functionality and not on menu-lists as in books by other publishers The book is extremely useful as a quick reference guide. Search for topics using the: Comprehensive Table of Contents, Innovative "Menu to Contents" Mapping, or the Exhaustive Index The use of functions and formulas, and several tips and tricks for working on functions are taught step-by-step with examples Contents 1 The Excel Object Model 2 Saving (Opening) In (From) Different File Formats 3 Hiding And Unhiding Workbooks 4 Worksheets 5 Columns And Rows 6 Cells And Ranges 7 Data Entry Form 8 Reducing Errors In Data Entry— Validation & Autocorrect 9 Using Fill And Other Tools To Save On Typing Time 10 Formatting Cells And Ranges 11 Printing And Page Setup 12 Conditional Formatting 13 Shortcuts 14 Default Options 15 Customizing The Buttons Or Icons In The Toolbar 16 Placing/Removing Individual Icons On/From The Toolbar 17 Using The Help And Office Assistant 18 Sharing Workbooks & Online Collaboration 19 Highlighting, Tracking & Reviewing Changes 20 Password Protection 21 Inserting Comments 22 Hyper linking 23 Linking & Embedding Objects 24 Writing Formulas 25 Copying/Cutting And Pasting Formulae 26 Paste Special 27 Inserting Functions 28 Text Functions 29 Date And Time Functions 30 Mathematics, Trigonometry, And Engineering Functions 31 Logical & Information Functions 32 Smart Functions That Respond To Formula Result 33 Loan Repayments 34 Discount Cash Flows 35 Securities Functions 36 Functions For Basic Statistics 37 Probability Density Functions And Confidence Intervals 38 Other Mathematics & Statistics Functions 39 Tracing Cell References & Debugging Formula Errors 40 Nested Functions 41 Add-Ins: Enhancing Excel 42 Statistics Tools 43 Hypothesis Testing 44 Regression 45 Other Tools For Statistics 46 The Solver Tool For Constrained Linear Optimization 47 Recommended Add-Ins 48 Sorting 49 Scenarios And Goal Seek 50 Filtering 51 Subtotals 52 Pivot Reports 53 Linking To A Database 54 Reading ASCII Text Data 55 Saving Or Transforming To Web And Other Formats 56 Selecting Cells/Content That Satisfy A Criterion

Comprehensive Excel Related Software