Skip to main content
National School of Government and Public Services, Prospectus home page
Prospectus Online

Home Specialist skills Data and Analytics Excel Forecasting and Data Analysis

Excel Forecasting and Data Analysis

  • bullet point
    Understand how you can forecast in Excel using different methods based on seasonal, linear or exponential data
  • bullet point
    Calculate forecast errors to update your forecast model to assure more accurate forecasts
  • bullet point
    Learn how to conduct trend analysis, break-even analysis, calculate correlation coefficient and creating statistical analysis using Excel's analysis toolpack
  • bullet point
    Visualise trends and forecasts in Excel charts

Overview

Off the shelf (OTS)
Delivery method
Virtual icon

Virtual

Virtual icon

Face to Face

Course duration
Duration icon

6 / 7 hours

Competency level
Working icon

Working

Pink building representing strand 4 of the campus map
Delivery method
  • Virtual icon

    Virtual

  • Virtual icon

    Face to Face

Course duration
Duration icon

6 / 7 hours

Competency level
  • Working icon

    Working