Comprehensive Excel -

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