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
|
