Comprehensive Excel

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