Loading...
Loading Course Details
Loading course information...
Course 5183 | Virtual | Classroom
Budget Analysis Techniques Boot Camp Using Microsoft Excel
Overview
More effective analyses lead to better budget decisions for the organization and improved financial performance. Using the various features and functions of Excel, participants will learn how to perform the analyses to support budgetary decisions and present data graphically for stakeholders. You will spend 80% of your class time working in Microsoft Excel to gain hands-on experience that you can apply on the job.
Who Attends
This course is designed for program and financial management personnel who want to understand and apply Excel's analytical techniques to support budget decision-making in their organizations.
Course Level: Basic
CLP: 40 | CPE: 40
Duration: 5 days
Price: $ 2299.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.
Course Details
Volume Discounts (5+ Seats)
Private Group TrainingAvailable Dates
Guaranteed to Run are designated with a 
August 10 - August 14, 2026
Class ID: 265183006
Washington, DC
8 AM - 4 PM EST
September 14 - September 18, 2026
Class ID: 265183007
Virtual
9 AM - 5 PM EST
November 16 - November 20, 2026
Class ID: 265183008
Virtual
9 AM - 5 PM EST
January 11 - January 15, 2027
Class ID: 275183001
Virtual
9 AM - 5 PM EST
March 1 - March 5, 2027
Class ID: 275183002
Virtual
9 AM - 5 PM EST
May 10 - May 14, 2027
Class ID: 275183003
Virtual
8 AM - 4 PM EST
June 14 - June 18, 2027
Class ID: 275183004
Virtual
9 AM - 5 PM EST
July 12 - July 16, 2027
Class ID: 275183005
Virtual
9 AM - 5 PM EST
August 9 - August 13, 2027
Class ID: 275183006
Virtual
9 AM - 5 PM EST
November 15 - November 19, 2027
Class ID: 275183007
Virtual
9 AM - 5 PM EST
Learning Objectives
- Perform basic Excel functions in support of the principles of analysis
- Query databases using the Filter tool and Advanced Filter tool
- Apply benefit-cost analysis to determine the net benefit, benefit-cost ratio, and return on investment (ROI) for a project or program
- Determine how costs and benefits impact budget decisions
- Determine how the time value of money impacts budget decisions
- Determine how time-based decision criteria measures impact budget decisions
- Apply sensitivity analysis to budget data to support decision-making
- Construct and display frequency distributions using histograms, descriptive statistics, the normal distribution, and Z-scores
- Use time series components, line graphs, trendlines, equations, and r-squared values to forecast budget amounts
- Perform a graphical analysis of data
- Present data and analyses effectively by linking datasheets, charts, or tables to a Word or PowerPoint file
Additional Features
100% Satisfaction Guarantee
100% Satisfaction Guarantee.
Producer Support
Need help during a virtual session? Our producers are here to ensure your learning experience runs smoothly.
Dedicated In-House Accessibility / Section 508 Compliance
Learn how we ensure accessible learning experiences for all participants in compliance with Section 508.
Student Resource Guides
Find helpful reference materials to support your learning during and after the course.
Learn More