Register Online - Add to Cart

Credits

Sponsored by Lorman Education
Product ID: 405196EAU
 
Credit & Course Provided by:

Utilizing Excel® for Financial Analysis and Modeling

OnDemand Webinar (93 minutes)

Explore the business professionals' guide for using Microsoft® Excel® to create financial scenarios and models.There are many choices in financial software. Microsoft® Excel® is one of the best and most versatile financial decision-making tools available. This material demonstrates how to use the features in Excel® to build financial models. The topics discussed include how to use formulas, pie charts, functions, pivot tables and statistics to build financial models.

Authors

Jay R. Carlson, FatDAWGS.com

Agenda

What Is Financial Modeling?

  • Definitions

- Wikipedia®

- Investopedia®

The Goal of Financial Modeling

Why Excel®?

Tools

  • Formulas Overview
  • Graphs Overview
  • Statistics Overview
  • Pivot Tables Overview

Demonstrations in Excel®

  • Household Budget to Introduce Formulas and Pie Charts
  • Calculations Using Financial Formulas in Excel®

- PMT Function

- CUMIPMT Function

- FV Function

  • Creating Column Charts
  • Statistics

- AVERAGE

- STDEVS

- FORECAST, LINEAR

  • Pivot Tables

Lessons (I've) Learned