Program and Budget Analysis Using Microsoft Excel

Course 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 Modules

• Module 1: Getting Started: Warm-Up and Review
• Module 2: Querying and Analyzing Data
• Module 3: Computing Statistics on Collected Data
• Module 4: Time Series Analysis and Forecasting
• Module 5: Correlation and Regression: Analyzing Costs and Performance