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?
• 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: