This recorded webinar will simplify typical VBA code in order to save time for the busy finance professional.
Overview
This recorded webinar will simplify typical VBA code in order to save time for the busy finance professional.
Using practical exercise and segmented into short lessons for ease of learning, this webinar will help you develop and enhance the technology skills that are important for financial professionals.
Key topics:
- Sorting data with code – recorded code vs. succinct code
- Code by using a simple Autofilter in VBA
- Transposing data throughout the workbook onto a single worksheet.
- Updating a master sheet from child sheets.
As part of this webinar you will receive:
- Downloadable worksheets with practical tasks to embed the knowledge
- A learning manual with step by step instructions
This recorded webinar is delivered by Excel expert and trainer, Marcus Small. Click here for Marcus' biography.
Course updated: 2020
Objectives
- Use a filter to to isolate data by colour or multiple conditions
- Sort data efficiently and link to a chart so teh change cascades
- Use the advanced filter to create child sheets from a master data set
- Build a consolidated worksheet and apply calculations to summarise the data
- Automate the process so that new information is picked up
Audience
Professionals working in SME or Corporate entities in specialist or analyst roles, and mid-level career roles working in job functions such as external reporting, financial control and management accounting.