This recorded webinar is specifically designed for finance professionals working with Microsoft Excel in their day-to-day working roles.
Expert presenter Marcus Small will go through the process of gathering data from a GL and the use of a unique identifier (in this course a cost centre code), turning a single report format into a suite of reports for a range of cost centres.
Key topics:
- Use VBA to make automated batch reports less time consuming
- Produce consistently in a reusable template
- Learn simple code which can be applied to any repetitive task
Learning objectives
- Gain an understanding of automated batch reports using VBA
- Work through the detailed tasks accompanying the webinar to test knowledge acquired
- Build models based on automated batch reports using teaching points and template resources supplied
Audience
Professionals working in SME or Corporate entities in specialist or analyst and mid-level career roles working in job functions such as external reporting, financial control and management accounting.
