Comprehensive Excel

This book covers all topics in the other volumes in Excel® except Charting in Excel®.

The text is pithy and terse. The use of graphics makes the tutorials easier to use. The table of contents are detailed. You can look and pick some specific option which you need to learn. Or, you can use the exhaustive index to find the tutorial on a topic.

The chapters are sequenced based on functionality and not on menu-lists as in books by other publishers The book is extremely useful as a quick reference guide. Search for topics using the: Comprehensive Table of Contents, Innovative "Menu to Contents" Mapping, or the Exhaustive Index.

The use of functions and formulas, and several tips and tricks for working on functions are taught step-by-step with examples.

Contents:

The Excel Object Model
Saving (Opening) In (From) Different File Formats
Hiding And Unhiding Workbooks
Worksheets
Columns And Rows
Cells And Ranges
Data Entry Form
Reducing Errors In Data EntryВ— Validation & Autocorrect
Using Fill And Other Tools To Save On Typing Time
Formatting Cells And Ranges
Printing And Page Setup
Conditional Formatting
Shortcuts
Default Options
Customizing The Buttons Or Icons In The Toolbar
Placing/Removing Individual Icons On/From The Toolbar
Using The Help And Office Assistant
Sharing Workbooks & Online Collaboration
Highlighting, Tracking & Reviewing Changes
Password Protection
Inserting Comments
Hyper linking
Linking & Embedding Objects
Writing Formulas
Copying/Cutting And Pasting Formulae
Paste Special
Inserting Functions
Text Functions
Date And Time Functions
Mathematics, Trigonometry, And Engineering Functions
Logical & Information Functions
Smart Functions That Respond To Formula Result
Loan Repayments
Discount Cash Flows
Securities Functions
Functions For Basic Statistics
Probability Density Functions And Confidence Intervals
Other Mathematics & Statistics Functions
Tracing Cell References & Debugging Formula Errors
Nested Functions
Add-Ins: Enhancing Excel
Statistics Tools
Hypothesis Testing
Regression
Other Tools For Statistics
The Solver Tool For Constrained Linear Optimization
Recommended Add-Ins
Sorting
Scenarios And Goal Seek
Filtering
Subtotals
Pivot Reports
Linking To A Database
Reading ASCII Text Data
Saving Or Transforming To Web And Other Formats
Selecting Cells/Content That Satisfy A Criterion

Click here to Buy Now

Delivery:

You will receive information electronically immediately after ordering!

You will be able to download the product immediately after ordering!

Payment information safety is ensured by RegNow - one of the most reliable systems of registration, ordering and payment over the Web. RegNow is a company with a world-wide reputation. It processes transactions in all basic currencies and supports various forms of payment.