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

Price: $9.99 USD Category: E-books & Literature Added: Sep 29th 2010 Publisher: VJ Inc Homepage: http://www.vgupta.com