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


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.