We also offer courses and publications in: UK Flag London US Flag New York
  • Join us for the latest updates, tips and course dates!

Excel – Module 1: Going Further with Formula’s and Functions

Excel gives you the edge whenever you want to do something new with financial models, something never seen before in instrument pricing, and something that none of your competitors has ever done.
Delivered via Virtual Classroom you will be able to engage with the instructor and other participants, share screens, ask questions without leaving your office or your home, city or country.

Description

Module 1 - Excel - Going further with formulas and functions This module adds further tools to the modelers toolbox, covering various functions used in many different situations. It finishes with an exploration of basic pivot tables. 

• If function
• Find function
• Substitute function
• Value function
• Subtotal function
• Sumif and Countif functions
• Names and Arrays
• Vlookup and Hlookup functions
• Transposing data
• Pivot tables