Comprehensive Tutorials for Excel is a PDF download e-Book with comprehensive step by step tutorials covering all aspects of working with Excel.
The PDF of tutorials is structured in a way so that required help an be quickly searched or located in the index to gain knowledge and complete the task at hand in a timely manner.
The use of functions and formulas with several tips and tricks for working on functions are taught step by step with tutorial examples.
Key concepts in the Comprehensive Tutorials for Excel include:
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 and Auto correct
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 and Embedding Objects
Writing Formulas
Copying/Cutting And Pasting Formulas
Paste Special
Inserting Functions
Text Functions
Date And Time Functions
Mathematics, Trigonometry, And Engineering Functions
Logical and 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 and Statistics Functions
Tracing Cell References and 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