Budget Estimating Using Microsoft Excel

Overview

Discover how to leverage Microsoft Excel to analyze budgets and finances to help ensure the accurate and timely preparation of budget worksheets. After an overview of budgeting, the rules and regulations that govern the process, and the basics of Excel, you will participate in hands-on activities to apply spreadsheet tools and techniques needed to prepare budget worksheets.

Who Attends

This course is designed for budget and program analysts or financial management professionals who want to become more productive when using spreadsheets to estimate and present program needs for a federal budget submission and justification.

Course Level: Basic
CLP: 24 | CPE: 24
Duration: 3 Days

Price: $ 1699.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

August 24 - August 26, 2026

Class ID: 265155008

Washington, DC

8 AM - 4 PM EST

September 14 - September 16, 2026

Class ID: 265155009

Virtual

9 AM - 5 PM EST

October 13 - October 15, 2026

Class ID: 265155010

Virtual

9 AM - 5 PM EST

November 2 - November 4, 2026

Class ID: 265155011

Virtual

9 AM - 5 PM EST

January 4 - January 6, 2027

Class ID: 275155001

Virtual

8 AM - 4 PM EST

March 8 - March 10, 2027

Class ID: 275155002

Virtual

8 AM - 4 PM EST

April 5 - April 7, 2027

Class ID: 275155003

Washington, DC

8 AM - 4 PM EST

May 10 - May 12, 2027

Class ID: 275155004

Virtual

8 AM - 4 PM EST

June 14 - June 16, 2027

Class ID: 275155005

Virtual

9 AM - 5 PM EST

July 12 - July 14, 2027

Class ID: 275155006

Virtual

8 AM - 4 PM EST

August 23 - August 25, 2027

Class ID: 275155007

Virtual

9 AM - 5 PM EST

September 13 - September 15, 2027

Class ID: 275155008

Virtual

9 AM - 5 PM EST

November 1 - November 3, 2027

Class ID: 275155009

Virtual

9 AM - 5 PM EST

Learning Objectives

Navigate the Excel Ribbon
Build a complete budget workbook using Excel, with account worksheets linked into a summary worksheet
Apply numerous Excel shortcuts to improve productivity
Link budget data to Microsoft PowerPoint and Word documents
Improve worksheet design using formulas, including =IF, =VLOOKUP, and conditional formatting
Create charts and graphs for budget presentations
Insert budget trend lines and perform simple regression
Prepare budget estimates using the analogy, complete enumeration, parametric, and extrapolation techniques
Link cells, worksheets, and workbooks
Design and produce a representative budget from a case study

Additional Features

Learn More

Related Courses and Products

COURSE

Program and Budget Analysis Using Microsoft Excel

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...

Loading Course Details

Budget Estimating 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