COURSE 4785 | 2-DAY SESSION
Power Excel
Finance, Forecasting, Risk Analysis and Decision Making For Program and Project Managers
A two day, hands-on class focused on exercises that will make you an
Excel wizard in Statistics, Forecasting, Risk Analysis and Decision Processes!
No advanced math is required! Let Excel do the crunching for you!
If you are ever faced with real business problems like:
- What are our chances of making a profit on the new product release?
- What is our realistic return on investment?
- Will we finish the project on time? What is the real probability?
- How do I prioritize my project risks?
- What is the expected reliability of this new product? I have no idea where to set the warranty period…
- Is my market testing reliable? What is the probability that if I go with this marketing plan, it will be effective? What tool would I use to figure this out?
- We've developed a new test but how effective is it really? What is the likelihood that if a subject tests positive, they really are positive?
- What metrics do I use to measure results and how should I show the data?
- What kind of chart should I use?
- How can I improve on our forecasting ability?
- How can I display a trend or perform a regression analysis using Excel?
- How can I create and run a 'what if' scenario? Will it actually return meaningful data?
- How can I create interactive summaries that can be reformatted on a moment's notice?
Whether you are a project manager, performing financial analysis,
risk analysis or simply need to better understand your business
processes, this class is for you.
Immediate Benefits for Workshop Participants
- Acquire immediate skills to manage your projects with data and fact
- Analyze project data and interpret the results using a battery of statistical tools
- Improve your ability to accurately predict outcomes through the use of sophisticated probability functions
- Develop dynamic data reporting capability thought the use of PivotTables
- Accurately measure processes to determine whether they are in control or whether the processes need correction
- Perform forecasting using trend and regression analysis on your data and investigate scenarios to determine potential outcomes.
- Quantitatively identify risks and their potential impacts on your projects
- Determine if one factor on a project has an impact on another factor through the use of the scatter diagram
- Prioritize and act on key project impacts, customer issues, highest risk factors, major project benefits or the top 20% of any factors impacting your project through the use of the Pareto Chart
- Instantly perform hundreds of calculations on data through the use of a single Array Formula.
- Model uncertainties that evolve over time using Markov chains
- Understand the pitfalls of using IRR and what to do to make it work for you
- Use the most powerful tool to help you accurately estimate your project timelines
- Automate reports and calculations using Excel macros
- Quickly filter and sort data to zero in on the results you need
- Harvest the techniques that show you how to effectively use the Excel Chart wizard and create killer charts every time
- Engineer optimization models that will show the best way to accomplish objectives using Excel's Solver capability
- Create dynamic, automated calendars for reporting time
|
