MyPage is a personalized page based on your interests.The page is customized to help you to find content that matters you the most.


I'm not curious

Excel 2010: Advanced Formulas and Functions

Course Summary

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.


  • +

    Course Syllabus

    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


Course Fee:
USD 19.99

Course Type:

Self-Study

Course Status:

Active

Workload:

1 - 4 hours / week

This course is listed under Development & Implementations Community

Related Posts:

Array

 

Attended this course?

Back to Top

Awards & Accolades for MyTechLogy
Winner of
REDHERRING
Top 100 Asia
Finalist at SiTF Awards 2014 under the category Best Social & Community Product
Finalist at HR Vendor of the Year 2015 Awards under the category Best Learning Management System
Finalist at HR Vendor of the Year 2015 Awards under the category Best Talent Management Software
Hidden Image Url

Back to Top