->
Lynda - Excel 2011 for the Mac: Advanced Formulas and Functions - 191596
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

  • Introduction
  • 1. Formula and Function Tools
  • 2. Formula and Function Tips and Shortcuts
  • 3. IF and Related Functions
  • 4. Lookup and Reference Functions
  • 5. Statistical Functions
  • 6. Power Functions
  • 7. Selected Financial Functions
  • 8. Selected Math Functions
  • 9. Date and Time Functions
  • 10. Text Functions
  • 11. Array Formulas and Functions
  • 12. Reference Functions
  • 13. Information Functions
  • Conclusion
  • Lynda - Excel 2011 for the Mac: Advanced Formulas and Functions


     TO MAC USERS: If RAR password doesn't work, use this archive program: 

    RAR Expander 0.8.5 Beta 4  and extract password protected files without error.


     TO WIN USERS: If RAR password doesn't work, use this archive program: 

    Latest Winrar  and extract password protected files without error.


     Coktum   |  

    Information
    Members of Guests cannot leave comments.




    rss