+353-1-416-8900REST OF WORLD
+44-20-3973-8888REST OF WORLD
1-917-300-0470EAST COAST U.S
1-800-526-8630U.S. (TOLL FREE)

PRINTER FRIENDLY

Financial Modeling With Microsoft® Excel® - Webinar

  • ID: 3989384
  • Webinar
  • 90 Minutes
  • Lorman Business Center, Inc.
1 of 4
Explore the business professionals’ guide for using Microsoft® Excel® to create financial scenarios and models.

In today’s world, there are many choices in financial software. Microsoft® Excel® is one of the best and most versatile financial decision making tools available. Learn how to use the features in Excel® to build financial models. The topic will discuss the tools in Excel® and then build on demonstrations of simple formulas and pie charts, powerful formulas and functions, pivot tables and statistics.

Learning Objectives
  • You will be able to define financial modeling.
  • You will be able to identify the goal of financial modeling.
  • You will be able to review formulas, graphs, statistics and pivot tables.
  • You will be able to discuss calculations using financial formulas in Excel®.
Note: Product cover images may vary from those shown
2 of 4
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
Note: Product cover images may vary from those shown
3 of 4

Loading
LOADING...

4 of 4
Jay R. Carlson, FatDAWGS.com
Note: Product cover images may vary from those shown
5 of 4
This webinar is designed for presidents, vice presidents, accountants, CFOs, controllers, tax managers, directors, analysts, bookkeepers, tax preparers and accounts payable professionals.
Note: Product cover images may vary from those shown
Adroll
adroll