Use Excel to Manage the Performance of Anything!

This course will teach anyone how to use Excel to assess and manage the performance of anything that can be measured and do it without generating any paper. It directly applies to:

• Budget And Financial Management
• Vendor And Contractor Management
• Organizational Performance Measurement
• Human Resource Performance Appraisals
• Program Evaluation
• Trend Analysis
• Performance Over Time

No special prior skill in Excel is required. Everything is spelled out in detailed, step-by-step instructions. All the user needs is a defined performance measure and its related periodic data values. Once these data on a given performance metric are entered, Excel will automatically generate the following performance management information:

• Descriptive Statistics Of Performance
• Correlation Coefficients
• Graphs Of Performance And Trends
• Time Series Regressions
• Indications Of Normal, Statistically Significantly High, And Statistically Significantly Low Performance
• Analysis Of Differences Between Sequential Time Periods
• Predictions Of Performance In The Next Period

Instructor: Bruce Truitt

Objectives:

This course will teach you how to

• Identify periods of significantly high performance
• Identify periods of normal but above average performance
• Identify periods of normal but below average performance
• Identify periods of significantly low performance
• Generate Descriptive Statistics for all time periods using three different models:
  • Linear (Straight Line) Model
  • Seasonal Model which adjusts for performance varying by time period
  • Indexed Model which references performance to the first reporting period
• Graph and run regressions using the above three models to
  • Identify which model best fits the data
  • Calculate how much performance variation each model explains
  • Determine to what extent time affects performance
  • Tell if performance is trending upward, flat, or trending downwards
• Graph all performance across all time periods
• Test to see if apparent performance differences in adjacent time periods are real
• Predict performance in the next time period
• Determine the utility of performance predictions

Who should attend: Executives, Managers, Supervisors, Monitors, Evaluators, Auditors, Investigators, Reviewers, and Analysts

Program level: Beginning

Prerequisites: A working knowledge of Excel or similar spreadsheet software

Delivery method: Group live

Recommended CPE credit: 8 hours

Click here for more information about Bruce Truitt.