Excel-- Beyond The Basics - Excel: Beyond The Basics. A book written by an end-user.

Home > Software > Home & Education > E-books & Literature > Excel-- Beyond The Basics > More information

Excel-- Beyond The Basics

Excel: Beyond The Basics. A book written by an end-user.

Editor : VJ Inc

Abstract available at 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