MS Excel: Trend Analysis and Forecasting

INTRODUCTION

A forecast is a prediction about the future. For example, you may anticipate future changes and assess where present business practices will take you by analyzing previous data.

A trend is something that represents the present or the past. For example, by examining recent sales figures, you may evaluate the cash flow pattern and have a better knowledge of how your firm has fared and operates.

This course will teach you how to use MS Excel to do trend analysis and forecasting..

COURSE METHODOLOGY

This course is designed in the form of workshop which will includes a variety of learning tools to help participants function effectively and efficiently in a multifunctional environment through various methodologies including;

• Short lectures
• Brainstorming
• Case studies
• Group activities
• Role playing

COURSE OBJECTIVES

The attendees of this Certificate Program will be able to:

• Understand Excel TREND function – syntax
• Learn how to use TREND function in Excel
• Perform trend line analysis based on historical data
• Project trend into the future
• Learn ways to show trends in Excel
• Learn excel forecast v. trend

 WHO SHOULD ATTEND THIS COURSE?

• Project Managers
• Change management team
• Operational Excellence Personnel
• Operations Managers
• Asset Managers
• Supply chain manager
• Management Representatives
• Quality Directors
• Quality assurance professionals
• Anyone who is seeking improvement in skills for enhanced performance and career development

TARGETED SKILLS

• Power Query
• Practicing trend analysis
• Forecasting
• Reporting
• Analyzing business data
• Designing basic macros