Program and Budget Analysis Using Microsoft Excel

0

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.

Chat with us LIVE to get a

FREE QUOTATION!

COURSE INCLUDES

  • 2 Days of training
  • E-Certificate of Completion
  • E-Training manual
  • Trainer logistic to client`s place

COURSE BENEFITS

  • 1 or 20 pax, same price
  • Confirmed-to-run even for 1 pax
  • Cheapest available (*we will price match!)
  • Money-Back-Guaranteed Quality
  • HRDF Certified & Claimable

ALL IN FROM ONLY

RM1,999/DAY

RRP RM2,860/DAY   SAVE RM861

*T&C Applies

PARTICIPANT REVIEWS FOR THIS COURSE

What Other People Bought

LOGIN

Login with your social account

or

Don’t have an account with us?

Edit Profile

Address

FREE FOR LIFE

Sign Up to Bookmark your Favourite Course
or Request for a Quotation instantly

Sign in with your social account

or

By signing up, you agree to our Terms of Use and Privacy Policy

Have an account with us already?