Lynda - Excel 2011 for the Mac: Advanced Formulas and Functions
Conquer some of the most daunting features in Microsoft Excel once and for all. In this version of his popular course, designed specifically for Excel for Mac users, author Dennis Taylor demystifies some of the most challenging of the 300+ formulas and functions in Excel, and shows how to put them to their best use. Dennis covers key shortcuts, the IF and LOOKUP functions for search and data retrieval, the statistical and math functions, and the date, time, and text functions that make formatting easier. He also covers combining functions to extend their power. These practical examples transition effortlessly to real-world scenarios.
Table of Contents
Introduction1. Formula and Function Tools2. Formula and Function Tips and Shortcuts3. IF and Related Functions4. Lookup and Reference Functions5. Statistical Functions6. Power Functions7. Selected Financial Functions8. Selected Math Functions9. Date and Time Functions10. Text Functions11. Array Formulas and Functions12. Reference Functions13. Information FunctionsConclusion