Trend Analysis and Forecasting Techniques for Managers

INTRODUCTION

A forecast is something about the future. For example, by evaluating historical data, you may project future changes and determine where current business practices will lead you.

A trend is defined as something that depicts the present or the past. For example, by analyzing recent sales numbers, you may examine the cash flow pattern and have a better understanding of how your company has fared and is functioning.

This course will show you how to perform trend analysis and forecasting using MS Excel.

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?

• Accountants
• Senior and junior accountants,
• Business analysts,
• Accounting and finance professionals
• Business analysts
• Research professionals and staff

TARGETED SKILLS

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