Excel-- Beyond The Basics

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