MS Excel: Trend Analysis and Forecasting

INTRODUCTION

A trend is anything that portrays the present or the past. For example, you may assess the cash flow trend and understand how your organization has fared and is performing by evaluating recent sales figures.

A forecast is anything that concerns the future. For example, you may forecast future changes and estimate where present business practices will lead you by examining previous data.

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?

• 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