1. Home
  2. Courses
  3. Federal Budget Analysis Using Microsoft Excel

Federal Budget Analysis Using Microsoft Excel (BUDG8150)

learning

Federal Budget Analysis Using Microsoft Excel

Description

Analysis plays an increasingly important role in today’s performance-based, outcome-oriented federal budgeting environment. This course covers methods of analysis frequently used to clearly define and answer budgetary questions. You will learn when and how to use selected Microsoft Office products (mainly Excel but also PowerPoint and Word) to improve analysis and job performance. Lessons are structured around the requirements for analysis contained in financial management laws and implementing OMB circulars. This course is part of the Master Certificate in Federal Financial Management.

Duration

3 days

Level

Intermediate

Who Should Attend?

Federal employees who need to strengthen their budget analysis skills. Participants should have experience in preparing budget estimates and executing an approved budget or have completed Budget Formulation (BUDG7101) and Budget Execution (BUDG7100). A basic knowledge of Excel such as that attained by completing an Introduction to Excel course is required. When taken through virtual instruction, each participant must have access to Microsoft Excel, PowerPoint and Word on his/her computer.

Credits

1.8 CEU's, 24 CPE's

Learning Outcomes

Describe a structured, five-step approach for conducting performance analysis to support evidence-driven budget decisions Apply Excel functions including calculations of future obligations and costs, benefits, net present value (NPV), and sensitivity analysis to evaluate competing alternatives when developing agency budget requests Use Excel functions including descriptive and normative techniques to assess variances and trends when executing performance budgets Prepare Excel data tables and charts with linkages between worksheets and to PowerPoint and Word documents for use in reporting performance results Develop a summary-level narrative for new budget authority incorporating Excel-based analytical results

Available Sessions

Session Code Start Date End Date Location Tuition
Session Code BUDG8150-001 Start Date Dec 10, 2024 9:00 AM EST End Date Dec 12, 2024 5:00 PM EST Location Virtual Tuition $1,199.00

Register For Session

Bring This Class To My Location

Other Recommended Courses

{{{CourseGetInTouch}}}