->
Lynda - Excel 2010: Advanced Formulas and Functions - 75923
Lynda - Excel 2010: Advanced Formulas and Functions
In Excel 2010: Advanced Formulas and Functions, author Dennis Taylor demystifies formulas and some of the most challenging of the nearly 400 functions in Excel and shows how to put them to their best use. The course reviews the building-block functions, along with a few critical keyboard shortcuts that will speed up working with Excel data. It also covers how to perform advanced searching and data retrieval with LOOKUP functions, tabulate data with counting, statistical, and math functions, reformat data with text functions, and work with financial data using advanced formulas. Exercise files accompany the course.


Table of Contents

  • Introduction
  • 1. Formula and Function Tips and Shortcuts
  • 2. Formula and Function Tools
  • 3. IF and Related Functions
  • 4. Lookup and Reference Functions
  • 5. Power Functions
  • 6. Statistical Functions
  • 7. Date Functions
  • 8. Math Functions
  • 9. Array Formulas and Functions
  • 10. Text Functions
  • 11. Financial Functions
  • 12. Information Functions
  • 13. Reference Functions
  • Conclusion
  • Lynda - Excel 2010: 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