Learn how to use VBA to make automated batch reports less time consuming with this recorded webinar, especially designed for finance professionals working with Microsoft Excel.
Description
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.