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 2013: Analysis Techniques and Random Numbers

Course Summary

Analysis Techniques using What-If, Solver, graphing, functions and statistical features in Excel.


  • +

    Course Syllabus

    Add-ins for Excel 2013
    - 8m 28s

    —Managing Excel Add-ins 8m 28s
    What-if Analysis, Goal Seek, Scenarios, and Solver
    - 52m 1s

    —Goal Seek Simple Formula 4m 51s
    —Goal Seek Simple Formula in Excel 3m 4s
    —Goal Seek Payment Example 3m 18s
    —Goal Seek Payment Example in Excel 4m 18s
    —Scenarios 4m 53s
    —Scenarios Example in Excel 11m 25s
    —Solver Set-up Working with an Example 9m 41s
    —Solver Example in Excel with and Without Applying Constraints 9m 41s
    —Summary 0m 46s
    Random Number Generator
    - 37m 9s
    Descriptive Statistics
    - 32m 32s
    Graphing Data
    - 40m 3s
    Z-tests
    - 43m 43s
    T-tests
    - 55m 33s
    Variance Tests Chi-square Test and F-test
    - 1h 17m
    ANOVA: Analysis of Variance
    - 56m 37s
    Regression
    - 42m 42s


Course Fee:
USD 29

Course Type:

Self-Study

Course Status:

Active

Workload:

1 - 4 hours / week

Related Posts:

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