Details
Anyone looking to learn or extend their knowledge of using Excel to assist with financial decision making in a business context.
Attendance or equivalent knowledge of Excel Advanced Part 1 and Introduction to Finance for Non-financial managers.
This course will show you why Excel is an essential tool for financial modelling, guide you through some key models and also introduce the practice of rolling forecasting. There will also be the opportunity to explore tying up actual models with reporting.
Outline
Excel modelling fundamentals
Best practice tips
Common mistakes to avoid
Making the most of Excel functionality
Analysing data for financial models
Using Pivot Tables to analyse and prepare raw data
Analysing sales and cost data
Identifying fixed and variable costs using linear regression functions
Testing cause and effect using correlation functions
Using moving averages to model seasonality
Sales and cost budget models
Interpolation and extrapolation methods
Using Excel for 'what if' analysis on sales and costs
Capital investment models
Understanding discounted cashflow and net present value (NPV)
identifying relevant incremental cashflows
Using Excel functions to calculate NPV
Understanding internal rate of return (IRR)
Using Excel to calculate IRR
Business valuation models
Understanding and using different business valuation methods
Using cashflow projections for business valuations
Building a business valuation model using Excel
Rolling forecasts
Budgets versus rolling forecasts
Identifying key business drivers
How American Express use rolling forecasts
'What if' analysis with rolling forecasts
Using Excel for rolling forecasts
Dynamic reporting models
Building simple reporting models for divisional reporting
Best practice in designing user-friendly workbooks
Using VLOOKUP and HLOOKUP as dynamic functions
Best STL seeks to provide unrivalled value and quality service, enabled by our unique business model.
We offer a wide range of business application and management training courses. Best STL (formerly Best Training) have been offering Microsoft training courses since 1992.
We are the number 1 provider for MS Office training and consultancy in the UK offering London's largest schedule of genuine dates (414 as of 7:50pm Wed).
Our 98%+ recommendation rate endorses our approach to long-term mutually beneficial relationships.
We offer training at all levels from assisting with rollouts & upgrades to Office 2013, Office 365 & Office 2010 and all skill levels, from beginners to advanced and beyond. If that's not enough we're happy to offer tailored training sessions to meet your needs precisely.
Our training team are also experienced in running Training Needs Analysis (TNA), bespoke course development for performance led training, project managed Training Rollouts and consultancy services.
We don't just train Microsoft Office, we also offer VBA, Data analysis & reporting, as well as Excel financial modelling courses, and more besides. So browse our schedule to see what we can do for you. If you don't see what you're after, get in touch. ...