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 Secrets: High Productivity learning what-if-analysis

Course Summary

A to Z Guide to make use of Excel What if Analysis in many possible ways PLUS lots of secrets finally revealed.

• +

Course Syllabus

• Lets get Started...
• Introduction to Course
• Using Exercise Files
• Course E-Brochure
• What if Analysis Presentation
• What is what if Analysis?
• What is what if Analysis
• Where are these What if Analysis Tools
• Keyboard Shortcuts to Access what if Analysis Tools
• Goal Seek
• What is Goal Seek?
• Requirements of Goal Seek and solving Procedure
• Solving Investment Problem
• Marks Goal Problem
• Loan Repayment Problem
• Finding Missing Value
• Calculating Number of Guest within Allocated Budget
• Calculating Monthly payments for Home Loan
• Scenario Manager
• What is a Scenario Manager?
• Requirements of Creating scenarios and solving Procedure
• Creating a Scenario
• Editing and Deleting a Scenario
• Scenario Summary (Table+Pivot Table)
• Merging Scenarios in same workbook
• Merging Scenarios from different workbooks
• Data Table
• Data Table: An Introduction
• Requirements of Creating a data Table and solving Procedure
• One Variable Data Table
• Two Variable Data Table
• Reference Formula to create a Data Table
• Hide Formula Cells
• Referencing Blank Cells and create a Data Table
• Commission Data Table
• Solver
• What is Solver?
• Enable Solver Add-in
• Solving Problem
• Bonus Files
• (1) PMT and Cash Flow
• (2) Form Controls : Prerequisits
• (2) Form Controls : Scroll Bar
• (2) Form Controls : Spin Button
• (2) Form Controls : Check Boxes
• (3) Switch Scenarios using (QAT, Macro)
• Cheat Sheet (Revise Anytime using cheat sheets)
• Cheat Sheet: Access What if Analysis tools
• Cheat Sheet: Goal Seek
• Cheat Sheet: Scenario Manager (1)
• Cheat Sheet: Scenario Manager (2)
• Conclusion
• Thanks for Joining
• Conclusion
• Next Step
• Next Steps
• Summary Quiz

Course Fee:
USD 49

Self-Study

Course Status:

Active

1 - 4 hours / week

This course is listed under Data & Information Management Community

Related Posts:

Data Analysis

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