Costing and Budgeting > Program and Budget Analysis Using Microsoft Excel

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

Get To Know The Trainer

Trainer Shabenah

4.5

Shabenah is an experienced corporate trainer, facilitator and consultant with deep knowledge in the field of IT, soft skills, leadership and communication. She has a great passion for training, learning and development, and is able to work effectively with people of all levels. Shabenah is also an active participant in local community and social activities.

VIEW PROFILE