Excel is a fantastically flexible tool. It can do many things, but is best-known for its number-crunching, data-processing abilities. Learning how to use Excel formulas is the key to mastering these. This book contains all three volumes of Excel: Learn Formulas Fast.
This book teaches Excel formulas step by step. At each stage, it follows a simple, effective structure as follows:
Context: a situation where you would use what you are learning
Example: a way of using what you are learning
Explanation: how the example works
Exercise(s): practice using the new concept, applying it in new ways and to new situations; and practice using it in combination with earlier concepts, to achieve more advanced results
Answers: a simple way to check your work: these are always on the next page, so you don’t read them by accident
The course covers: - The different types of data - Formatting and rounding - Formulas - Absolute and Relative Cell References - Making comparisons inside formulas - Using logic in formulas - Having formulas make decisions - Math functions - Statistical functions - Information functions - String functions - Date and Time functions - Lookup and Reference functions
If you want to learn how to use Excel formulas, fast, this is the book for you.