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 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
Size of file: 1.74 MB
|