Intermediate Excel: Analytical Tools for Treasury and Finance
This course introduces participants to Excel’s data analysis features, including functions, macros, pivot tables and the Visual Basic for Applications (VBA) language.
Agenda Topics
- User interaction and data summarization
- Data visualization and optimization
- Data cleaning and automation
Course Length
Two 2.5-Hour Virtual Sessions or One Full Day In-Person
Learning objectives
- Create a dashboard with Excel
- Master data summarization and visualization tools
- Manipulate raw data into a user-friendly format
- Conduct sensitivity/scenario analysis, optimization and forecasting
- Automate repetitive tasks through macros
Advanced Excel Analytics: VBA Programming
This Advanced Excel Analytics course focuses on using Visual Basic for Applications (VBA) scripts to write functions and custom macros. The use of user forums, which control macro events, is also discussed. All examples and illustrations utilize financial and treasury applications.
Agenda Topics
- Functions, subroutines and programming language
- Interactions with cells, ranges and worksheets
- Case study: Multilateral netting application
Course Length
Two 2-Hour Virtual Sessions or One Half Day In-Person
Learning objectives
- Understand the use of VBA and its relation to macros
- Write simple functions and subroutines
- Debug programs