The book is a must for anyone who wishes to master the most important power of a spreadsheet application-- the use of basic to complex functions.

The book has exhaustive and systematic step-by-step instructions on writing, copying, debugging and auditing formulae

Also learn: Formatting like a graphic designer, Using the "hidden" power of Excel like the quick auto-format feature & short cut menus, and Removing commonly encountered annoyances, Utilizing the HELP feature efficiently, Employing Excel in a workgroup setting, and Setting the default environment of Excel

Contents

1 Customizing The Buttons Or Icons In The Toolbar
2 Placing/Removing Individual Icons
3 Default Options
4 Sharing Workbooks & Online Collaboration
5 Tracking and Reviewing Changes
6 Password Protection
7 Inserting Comments
8 Hyper linking
9 Linking & Embedding Objects
10 Writing Formulas
11 Copying/Cutting And Pasting Formulae
12 Paste Special
13 Inserting Functions
14 Text Functions
15 Date And Time Functions
16 Mathematics, Trigonometry, & Engineering Functions
17 Logical & Information Functions
18 Smart Functions That Respond To Formula Result
19 Tracing Cell References & Debugging Formula Errors
20 Nested Functions
21 Add-Ins: Enhancing Excel
22 Scenarios And Goal Seek
23 Saving Or Transforming To Web And Other Formats
24 Selecting Cells/Content That Satisfy A Criterion