An Introduction to VBA

 

Learn the most important lines of code from an analyst’s perspective.  Learn how to automate repetitive tasks with the use of VBA.  Move away for the macro recorder with some simple lines of code to automate your spreadsheets.  

 

• Referring to sheets to avoid errors in a change of sheet name (few programmers follow these simple rules).

• Trapping a changing range (dynamic range), copy this moving range to a new location (paste values, paste formatting, paste everything).

• Using SpecialCells to isolate and manipulate like information (delete, highlight or copy this data).

• Using find and replace with VBA to locate and change data.

 

Filtering, Sorting and Consolidation Using VBA

This webinar will simplify typical VBA code for the financial analyst.  All coding will be achieved in as little lines as possible.

 

• Filter to isolate data, filter by colour, filter on multiple conditions.

• Sorting data efficiently, linking the range to a chart so it cascades and presents well.

• Using the advanced filter to create child sheets from a master data set.

• Consolidate a workbook, bring a group of templates into a consolidation sheet and have calculations summarise the data.  Automate the process so it picks any new information.

 

Looping and Working with VBA Change Events

 

This webinar takes users through some more advanced techniques in the VBA language.  Looping, creating If statements and change events to manage information.

 

• Looping constructs – how to loop through a range of cells efficiently, how to perform the same macro a specified number of times.

• How to loop through sheets and manipulate and cleanse your data to save time.

• Change events to trigger a macro when a cell or group of cells change.

• Creating IF statements in VBA to trigger an event.