| Name | Description |
| Rolling Forecasts with Excel |
This course is designed to equip participants with the concepts and tools from which a model can be prepared which can be changed easily and automatically as business change requirements dictate. Changing external economic conditions can be reflected in KPI's easily and quickly and this process iterated continuously (e.g. every quarter).
The rolling aspect implies that the model produced during the day (an 18 month rolling forecast) is quickly adaptable to changing business circumstances and can be run as often as required. |
| Business Plan Modelling using Excel |
Effective business planning is fundamental to success in business. Building the plan model is the first step in transforming ideas into tangible reality. A well-organised plan should tell you if the concepts make sound business sense. It is easier to compete for support and resources with the aid of a convincing plan. |
| Data Analysis - Excel 365 – New Dynamic Functions, Top Pivot Table tips, Macros and more |
This packed course tackles new Excel Functions like FILTER UNIQUE, SEQUENCE, SORT and SORTBY showing their effectiveness over traditional Functions. We explore writing Custom Functions (LAMBDA, BYCOL) and use important Pivot Table techniques (in-table calculations, multi-sheet generation and the new PIVOTBY and GROUPBY). All manifestations of Formatting and key specific areas of Charting and effective Macro creation and editing are explored.
|
| Programming in VBA - Using Microsoft Excel |
The skills and knowledge acquired in this course are sufficient to be able to create real life working VBA applications within Excel. The learner will be able to work with VBA within the Excel environment to program and automate worksheet operations. Users of Excel up to Office 365 can be facilitated. |
| Excel Macros from A to Z using VBA |
This course refreshes the skills of Advanced users of Excel on the basics of Macros, then builds on the knowledge of participants to enable them to create, vet and edit Macros effectively and accurately using VBA. |