• Visit Our Network:
  • gtnews
  • Corporate Treasurers Council
  • AFP Advisors Network
  • CIEBA
The Resource for the Global Finance Profession

Intermediate Excel: Analytical Tools for Treasury and Finance

Webinar Archive

Member: $275 | Non-member: $375
4.5 CTP/CCM Credits
0 CPE Credit
4.5 FP&A Credit
CPE Field of Study: Not Applicable

+ Add to Cart

Course Description

This course introduces the experienced Excel user to the more advanced data analysis features of the product including functions, macros, pivot tables and the Visual Basic for Applications language. Through hands-on examples, participants will learn to extract business insights from their spreadsheet applications and enhance their analytical capabilities of treasury related applications.

Learning Objectives: 
  • Use intermediate and advanced analytical techniques in Excel 
  • Understand various types of quantitative analytical methods in Excel
Take-Aways: 
  • PivotTables 
  • Text and Date Manipulation 
  • Optimization with SOLVER 
  • Automation with Macros

Speaker(s)

Michael Hunstad, PhD

Adjunct Professor of Mathematical Programming , Illinois Institute of Technology

Dr. Hunstad has been designing and building cash flow forecasting models for almost 15 years. He began his career as a consultant with Treasury Strategies and went on to become a Principal and head of the Cash Flow Forecasting and Analytics practice areas. He is currently an adjunct professor of applied mathematics and econometrics at the Illinois Institute of Technology and the Vice President and Head of Qualitative Research at North Trust Global Investments.

Dr. Hunstad holds and MBA in finance, a PhD in mathematical and statistical modeling and is finishing a second PhD in economics. He has published more than 20 articles on cash forecasting.

Click here for information on CTP/CCM and CPE credit requirements.

 Average 1 out of 5
Reviews
 
By kathy.zevola
 
By KaKru770297
 
By Anonymous
 
By maureen.donahue
 
By nicholas.tosi
Copyright © 2014 Association for Financial Professionals, Inc. - All rights reserved.
AFP, 4520 East-West Highway, Suite 750, Bethesda, MD 20814, Phone 1.301.907.2862
Follow Us AFP on LinkedInAFP on TwitterAFP on YouTubeAFP Newsfeed