How creators of “true detective” would uncover the story of MS Excel sensitivity tools

Microsoft Excel is a complete utility program, and most people who use it are aware of the many wonders it is capable of doing. Calculation, effects, drop and place and so on are some of the features that make it very efficient for users. But did you also know that it is very effective in also helping to make business forecasts?

Or, did you know that functions like Scroll Bars, Goal Seek, Data Tables, and Scenario Manager can enhance the power of your financial programs and take your ability to perform with these to exceptional heights?

You can learn all the functions of the wonderful program that MS Excel is, from a webinar that is being organized by Compliance4All, a leading provider of professional training for all the areas of regulatory compliance, on September 19.

Miles Hutchinson, who is a highly experienced, senior Finance professional, will explain these and other functions of MS Excel at this webinar. To gain thorough knowledge of how to put this program to optimal use in helping to make forecasts and other functions, please register by visiting https://www.compliance4all.com/control/w_product/~product_id=502703LIVE

• p>

Miles will explain the best practices for designing efficient forecasting models. He will also give a proper learning of how to apply Scroll Bars, Goal Seek, Data Tables, and Scenario Manager. All this learning, which can be had in just 90 minutes, can be applied over a lifetime.

Miles will demonstrate how the potency of MS Excel can be used to unleash its powerful sensitivity tools. This will help the participants gain a proper understanding of the complete power their financial models are capable of. He will also help them improve the design of their models using these tools.

Over the one-and-a-half hours of learning at this webinar, the expert will provide practical instructions and guidance for applying them and identify the key cautions to help avoid potential misfires.

He will cover the following areas at this session, which is aimed at the benefit of professionals who use the MS Excel program for their financial areas, such as Financial Analysts, Business Analysts, Information Reporting Officers, Tax Managers, Compliance Officers, Compliance Managers, CFO's, Controllers, Accounting Managers, Auditors, and Risk Managers:

• 20 rules of effective model design
• Applying Scroll Bars to individual cells to flex them over their relative ranges with the touch of your mouse
• Using Goal Seek to discover how much a single variable must move to reach a desired outcome
• Using Data Tables with one or two-inputs to deliver an array of outcomes from your model in just seconds
• Using Scenario Manager to store selected groupings of inputs and resulting outcomes
  • Use Scenario Manager to consolidate all "versions" of your model into one file
  • Use the standard Scenario Summary to compare your Scenarios automatically
• Expand your skills in financial modeling to a level you never dreamed of in just 90 minutes!
• Bonus - download a copy of the demo model along and the answer key to our demonstration!
• p>
About the speaker: Miles Hutchinson has been an auditor with PriceWaterhouseCooper and the Chief Financial Officer of a $1 billion real estate development company. He is a highly sought after professional speaker and consultant who has presented over 1000 seminars and training sessions on a myriad of business and financial topics, such as financial analysis and modeling, accounting matters, strategic planning, and compliance with the Sarbanes-Oxley Act.

About the Author

Compliance4All is a professional trainings provider for the regulated industries. It offers professional trainings for regulatory compliance professionals and offers innovative strategic consulting and advice to a broad range of organizations.

Rate this Article