Course Overview?
This highly-practical, intensive, hands-on course is packed with cutting edge spreadsheet design ideas to take your model structuring skills to the highest level. Far too many businesses spreadsheet models are flawed due to lack of well thought out objectives, layout and design. By adopting a structured design strategy, and utilizing best practice spreadsheet modelling standards and conventions you can develop better, robust and dynamic business models, providing greater insight to key business drivers, achieving greater accuracy and timely reporting, hence the need for four (4) full course days.
TARGET GROUP Target group
This training is designed for Chief Accountants, Accountants, HR Professionals, Administrators, Economists and Planners, Project officers, Assistant accountants, Accounts officers, Budget officers, Finance Managers, Finance officers, Auditors, Audit assistants, Audit officers, Treasurers, Financial Analysts, Tax Consultants, Investment professionals and other interested professionals who want to transform their Excel skills to the next level and move from building simple excel models to Complex financial models. Employees from Public and Private organizations are highly invited. For those want to develop data analysis and reporting skills, this training is a perfect match to their career goals!
Course contents
- Mastering the art of model design according to best practice design principles and standards.
- Ability to create and apply formulas and functions in model building and data analysis in order to create robust and dynamic models and reports
- Analyze data using excel functions and various data management tools, including PIVOT TABLES and Tables, in order to gain greater insight to key business drivers.
- Develop robust and dynamic models that enable the easy update of models through dynamic data range naming and Tables to enable easy refresh to update model.
- Create models and reports with interactive features that automatically change through the use of Text, date and time functions.
- Ability to apply various conditional formatting rules in order to be able to assess changes in performance or track activities real-time among other uses.
- Ability to protect and bullet proof your model to avoid errors and damage to your model structure and design layout
- Ability to connect data from various sources and update big data automatically by just a one click refresh button
- Ability to apply decision making tools, forecasting and statistical analysis tools
