Management Concepts

Data Analysis for Financial Managers Using Microsoft Excel

Available dates

Feb 18—21, 2020
4 days
Washington, District of Columbia, United States
USD 1089
USD 272 per day
May 4—7, 2020
4 days
Denver, Colorado, United States
USD 1089
USD 272 per day
Jun 2—5, 2020
4 days
Washington, District of Columbia, United States
USD 1089
USD 272 per day
+4 more options

Disclaimer

Coursalytics is an independent platform to find, compare, and book executive courses. Coursalytics is not endorsed by, sponsored by, or otherwise affiliated with Management Concepts.

Full disclaimer.

About the course

Data analysis has become an integral component of financial management. Using Microsoft® Excel to effectively make data-driven decisions can be complex and overwhelming. You will gain the skills and techniques to face this challenging task through real-world exercises. You will learn how to use Excel to validate data, and construct financial models to ultimately make the best possible decisions for your program or agency.

Learning Objectives

  • Perform basic statistical validity calculations
  • Calculate cost, labor hour, and project schedule variances, and forecast projects’ final costs and completion times, using Excel
  • Use Excel’s financial functions to calculate the amounts, rates, and time necessary to achieve financial goals or meet financial requirements
  • Calculate the financial value of a project or proposal and select among alternatives using basic measures such as Net Benefit (NB), Present Value (PV), Net Present Value (NPV), and the Internal Rate of Return (IRR)
  • Calculate break-even points and/or required volumes via graphical analysis, algebra, or Excel’s Goal Seek tool to achieve financial goals
  • Utilize Excel’s Data Table and Scenario Manager tools to display the results of various financial scenarios with altering variables
  • Utilize Excel’s Solver tool to create optimal job and supply or supplier assignments, given known outputs and constraints
  • Analyze and conduct model line and Monte Carlo simulations using a single server and an exponential distribution for service and arrival rates

Course Topics

The Push for Analytics and the Need for Valid Data

  • The Push For Analytics
  • Data Validity
  • Using Excel to Validate
  • Data Gathering

Conducting Variance Analysis

  • Getting Started
  • Calculate Variance in Standard Cost Systems
  • Earned Value Management and Variance

Solving Financial Problems Using Excel’s Financial Functions and Creating Intentional Circular References

  • Getting Started
  • Using Financial Functions
  • Resolving and Creating Circular References

Evaluating the Financial Impact of Projects and the Selection of Alternatives

  • Getting Started
  • Using Basic Financial Measures in Project Evaluation
  • Applying Discount Rates and Calculating the Internal Rate of Return (IRR)
  • Selecting Among Alternatives Using Net Present Value (NPV) and the Cost-Effectiveness Technique

Applying Excel’s Goal Seek to Cost-Volume Analysis

  • Getting Started
  • Using Graphical Analysis to Calculate Breakeven Points
  • Using the Algebraic Approach to Calculate Breakeven Points
  • Using Excel’s Goal Seek Tool to Calculate Breakeven Points and Estimate Volumes

Applying Excel’s Data Table and Scenario Manager Tools to Financial Models

  • Getting Started
  • Using Excel’s Data Table Tool for One-Variable Data Tables
  • Using Excel’s Data Table Tool for Two-Variable Data Tables
  • Using Excel’s Scenario Manager tool for Multiple-Variable Summary and PivotTable Reports

Applying Excel’s Solver Tool to Financial Problems

  • Getting Started
  • Applying Excel’s Solver Tool to Create Assignment Models
  • Applying Excel’s Solver Tool to Create Transportation Models

Queuing Theory and Application to Waiting Line Models

  • Getting Started
  • Simulating the Waiting Line Model with Fixed Service Times and Fixed or Varying Arrival Times in Single- and Two-Server Systems
  • Simulating the Waiting Line Model with Exponential Distribution Service and Arrival Times in Single-Server Systems
  • Simulating the Waiting Line Model Using the Monte Carlo Simulation Technique

Who should attend

This course is designed for federal financial management personnel including budget analysts, management analysts, or consultants who need to support managerial decision-making through the analysis of financial data.

Course reviews