Program and Budget Analysis Using Microsoft Excel

Management Concepts

How long?

  • 4 days
  • online, in person

Management Concepts

Disclaimer

Coursalytics is an independent platform to find, compare, and book executive courses. Coursalytics is not endorsed by, sponsored by, or otherwise affiliated with any business school or university.

Full disclaimer.

Because of COVID-19, many providers are cancelling or postponing in-person programs or providing online participation options.

We are happy to help you find a suitable online alternative.

Who should attend

This course is designed for all program and financial management personnel who want to learn about many of the data analysis tools available in Microsoft Excel to aid in creating more compelling analyses of their programs.

About the course

A Federal budget analyst’s inability to properly use Microsoft Excel can lead to poor financial performance. But learning how to effectively navigate Excel can result in more productive analyses and the ability to graphically represent data, aiding in organizational efforts to track expenditures and control budget execution. You will spend about 80% of your time working in Microsoft Excel to get the hands-on training to apply what you learn back on the job.

Learning Objectives

  • Navigate the Excel ribbon
  • Query databases using the Filter tool and the Advanced Filter too
  • Aggregate and display different attributes of a data set using the PivotTabl
  • Use Excel’s Descriptive Statistics tool to calculate statistical measures of central tendency, variation, and shape
  • Use the Histogram tool to organize your data and create a frequency distribution
  • Perform graphical analysis of data
  • Use the Rank and Percentile tool to calculate a data item’s rank and percentile ranking
  • Use time series data and Excel’s trendline function to forecast future budgets, costs, and workloads
  • Learn which trendline (linear, polynomial, logarithmic, or exponential) is the best to use based on R2
  • Identify cost drivers using Excel’s Correlation tool
  • Develop simple linear and multiple linear regression models to develop forecasts and predictive equations using Excel’s Regression tool

Course Topics

Getting Started: Warm-Up and Review

  • The Role of Analysis
  • What Is Analysis?
  • Program Analysis
  • Budget Analysis
  • Financial Analysis
  • Overarching Analysis Principles
  • Excel Overview
  • Excel Dimensions
  • Review of the Excel Basics
  • Order of Operations Review
  • Lesson Wrap-Up

Querying and Analyzing Data

  • Building Background
  • Sorting and Querying/Filtering
  • Excel's Filter Tool
  • Excel's Advanced Filter Tool
  • Excel's PivotTable Tool
  • Lesson Wrap-Up

Computing Statistics on Collected Data

  • Building Background
  • Frequency Distributions
  • Common Shapes of Frequency Distributions
  • Descriptive Statistics
  • Normal Distributions
  • Excel Functions Used with the Normal Distribution
  • Rank and Percentile Tool
  • Lesson Wrap-Up

Time Series Analysis and Forecasting

  • Time Series Analysis
  • Inserting A Trendline
  • Lesson Wrap-Up

Correlation and Regression: Analyzing Costs and Performance

  • Building Background
  • Simple Linear Regression
  • Simple Linear Regression Equation
  • Excel’s Regression Tool
  • Regression Statistics
  • Correlation
  • Correlation Versus Causality
  • The Correlation Matrix
  • Multiple Linear Regression
  • More Regression Statistics
  • Lesson Wrap-Up

Program and Budget Analysis Using Microsoft Excel at Management Concepts

From  $1,139

Something went wrong. We're trying to fix this error.

Thank you for your application

We will contact the provider to ensure that seats are available and, if there is an admissions process, that you satisfy any requirements or prerequisites.

We may ask you for additional information.

To finalize your enrollment we will be in touch shortly.

Disclaimer

Coursalytics is an independent platform to find, compare, and book executive courses. Coursalytics is not endorsed by, sponsored by, or otherwise affiliated with any business school or university.

Full disclaimer.