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 Crashcourse Intermediate & Advanced

Course Summary

Alleviate your Job, University or School

  • +

    Course Syllabus

    • basic functions
      • start (+ downloadable excel file for the course)
      • if function basic
      • if function with or() and and()
      • sumif function
      • sumifs function
      • countif function
      • countifs function
      • max, min, small and large and transpose functions
      • vlookup function
      • vlookup approximative match
      • match function
      • choose function
      • vlookup with more tables
      • hlookup function
      • index and match function
      • days and time functions
      • sumproduct function
      • array functions
      • Pivottables and Slicer
      • conditional formating
      • Alternatives to dropdown lists - buttons
    • financial functions
      • Future Value function
      • PMT function
      • Rate function
      • nper function
      • Net Present Value function
      • IRR function
      • XIRR & XNPV
      • Duration function
      • Goal Seek function
      • Offset function for different Growth scenarios
      • data consolidation
    • Dynamics
      • dynamic range for dropdown list
      • dynamic excel charts
    • basic statistic functions
      • mean, average, averageif, averageifs
      • random numbers and norm.inv function
    • Excel Solver
      • Excel File
      • solver addin activation
      • Cost minimizing using the Excel Solver
      • Excle File for the course
      • The End - Thank you

Course Fee:
USD 50

Course Type:


Course Status:



1 - 4 hours / week

This course is listed under Development & Implementations and Data & Information Management Community

Related Posts:

Attended this course?

Back to Top

Awards & Accolades for MyTechLogy
Winner of
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