+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

# Utilizing Excel® for Financial Analysis and Modeling - Webinar

• ID: 4227673
• Webinar
• July 2018
• Region: Global
• 90 Minutes
1 of 4
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.

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
Jay R. Carlson - FatDAWGS.com
Note: Product cover images may vary from those shown
4 of 4
This webinar is designed for presidents, vice presidents, accountants, CFOs, controllers, tax managers, directors, analysts, bookkeepers, tax preparers, administrative professionals and accounts payable professionals.
Note: Product cover images may vary from those shown