Applied Excel & Business
Professional Development Advisor
This is a London Shool of Business Certified Masterclass
Become a certified guru in Excel, solve business problems in an analytical way with models
Please do tell us what you would like to see in this masterclass and we will make a special effort to ensure your topics are included into the training ...
Highly practical course and easy to master
Become an expert analyst & more efficient
Real life case studies used to explain concepts
Easy to learn & applicable to your work
Certified by the London School of Business
Add a quality certification to your CV
Bring your own business problems
We fix your problems while you learn
All material handed over in hard & soft copy
These are your materials, to reuse
Indefinite access to an online reading portal
The learning continues beyond the class
Post workshop support for technical areas
Even after the program you are supported
A deep dive into Microsoft Excel for modelling business problems ... Macros, Monte Carlo, Valuation, Forecasting and much more ...
Build a Performance Dashboard
Microsoft BI now integrates into Excel and we will build dashboards in this masterclass
You dont' even have to be technically minded to do this !
Who is this suitable for ?
Develop effective assessment techniques and reporting methods for Key Performance Indicators
Price business strategies using models that can be applied to operations or sales
Techniques for analysing market data, forecast using Excel's in built statistical and scenario tools
Advance Tooling in Business Analytics
The workshop will address a large number of technical challenges analysts face when modelling in Microsoft Excel. The workshop begins with how to frame business requirements, how to identify specific factors that can be used in modelling, building the models and generating reports. The workshop is a deep dive on Excel but it goes beyond the tools and also explores new ways to solve paradoxical problems business analysts face around capacity, cost modelling, forecasting, valuation & much more.
Integrate Excel with databases and dashboards
Goal Seek, Scenario Analysis, Solver demonstrated
Learn how to value Discounted Cash Flow & more
Monte Carlo, Markov Analayis, ARIMA demonstration
Models for measuring quality and performance
Data tables, Pivot reporting, Error checking
Extracting financial statements & ratio analysis
Develop dynamic reports for stakeholders