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