Training Doyens

OVERVIEW Financial analysis is an area of opportunity and risk . Analysis should incorporate tests of sensitivity to changes in key variables using the most advanced tools available. Typical financial forecasting models do not effectively utilize these tools. This exposes the analyst to blind spots in their analysis. Analysts will want to obtain and become proficient in the use of the more sophisticated “what if” analysis tools of the trade. WHY SHOULD YOU ATTEND Learn best practices for designing efficient financial forecasting models. Learn how to apply spinner and scroll bar controls, goal seek, data tables, and Excel scenario manager to your models in just 90 minutes. Experienced CGMA and financial analyst, Miles Hutchinson will demonstrate the Excel’s sensitivity tool for you. He will provide  practical instructions and guidance for applying them and will help you identify the key cautions to avoid potential misfires. AREAS COVERED • 20 rules of effective fi...

OVERVIEW No matter what business you are in, a dashboard is a critical tool in your communication armoury and as with any communication tool, presentation is everything. Although there are many tools that can be used to create a dashboard, MS Excel is commonly used due to its power, its flexibility and the fact that most people have it installed on their computer.  Thistraining focuses on what you need to know to create an interactive professional-looking dashboard using MS Excel.  You'll learn how to: make the Excel Dashboards maintenance-free when new data becomes available; create the pivot tables needed to drive the dashboard; create great looking visuals; add interactivity using slicers; automate elements of the dashboard with a macro and protect the cells containing critical formulas. WHY SHOULD YOU ATTEND In this advanced Excel training session, you'll learn how to create a stunning, interactive professional-looking dashboard using MS Excel. AREAS COVE...

Financial analysis is an area of opportunity and risk, and it should incorporate tests of sensitivity to changes in key variables using the most advanced tools available. Join our upcoming webinar be presented by Miles Hutchinson tolearn techniques of advanced financial modeling in Excel and best practices for designing efficient forecasting models. Webinar Highlights: ·          20 rules of effective advanced financial modeling in Excel ·          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 Financial Modeling with Excel's Advanced Sensitivity Tools LEARNING OBJECTIVES Attend this briefing and demonstration on Excel to unleash its powerful sensitivity tools. Get the full powe...