Program and Budget Analysis Using Microsoft Excel

Overview

Learn to effectively navigate Excel for 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 75% of your time working in Microsoft Excel to get the hands-on training to apply what you learn back on the job.

Who Attends

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.

Course Level: Intermediate
CLP: 32 | CPE: 32
Duration: 4 Days

Price: $ 2059.00 Course prices shown here do not include a credit card surcharge. Payments by ACH, EFT, or check do not include the surcharge and are offered at a lower price. At checkout, you may choose a payment method that avoids the credit card surcharge.
A 3% credit card surcharge will be applied.

Course Details

FAQs Technology Requirements

For Groups

Volume Discounts (5+ Seats) Private Group Training Icon

Private Group Training

Available Dates

Guaranteed to Run are designated with a

September 14 - September 17, 2026

Class ID: 265182009

Washington, DC

8 AM - 4 PM EST

October 13 - October 16, 2026

Class ID: 265182010

Virtual

9 AM - 5 PM EST

November 30 - December 3, 2026

Class ID: 265182012

Virtual

9 AM - 5 PM EST

February 16 - February 19, 2027

Class ID: 275182001

Virtual

9 AM - 5 PM EST

April 19 - April 22, 2027

Class ID: 275182002

Virtual

9 AM - 5 PM EST

June 7 - June 10, 2027

Class ID: 275182003

Virtual

9 AM - 5 PM EST

August 9 - August 12, 2027

Class ID: 275182004

Virtual

9 AM - 5 PM EST

October 12 - October 15, 2027

Class ID: 275182005

Virtual

9 AM - 5 PM EST

December 6 - December 9, 2027

Class ID: 275182006

Virtual

9 AM - 5 PM EST

Learning Objectives

Navigate the Excel ribbon
Query databases using the Filter tool and the Advanced Filter tool
Aggregate and display different attributes of a data set using the PivotTable®
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 the r-squared value
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

Additional Features

Learn More

Related Courses and Products

COURSE

Budget Execution

Learn techniques to develop, analyze, and manage program financial plans to successfully execute a budget. This course explores the laws and procedures that guide the budgeting process, including cove...

COURSE

Budget Formulation

Learn about budget formulation as an essential step in the process of securing financial resources for your agency to fulfill the mission and deliver programs. You will also gain the skills and techni...

COURSE

Budget Justification:: Effective Preparation and Submission

Prepare effective written budget justifications that can win approval for budget requirements in your agency's formulated budget. In addition to learning about the overall budget justification process...

COURSE

PPBE Workshop: Defense Planning, Programming, Budgeting, and Execution

Learn how the Department of Defense (DoD) Planning, Programming, Budgeting, and Execution (PPBE) System defines which programs meet military strategy requirements and the amount of funding received. U...

Loading Course Details

Program and Budget Analysis Using Microsoft Excel

Overview

Who Attends

For Groups

Available Dates

Learning Objectives

Additional Features

Credits

This course is part of the following Management Concepts Certificate Programs:

Core Courses

Elective Courses

Prerequisites:

Mandatory

Suggested

Course Activities

Course Topics