You are in Training / Microsoft / Professional Development / Course 4002

4002 Forecasting and Trend Analysis Using Microsoft Office Excel 2003
To view the course outline click here.

Microsoft® Excel® is the spreadsheet program most commonly used by financial analysts, project managers, academics, and small business owners around the world to track and analyze business and personal data. Because of the increasing demands on their time, business professionals need to learn efficient and effective data forecasting methods that give them the answers they need. This course will provide experienced Excel users with a practical, hands-on understanding of advanced Excel data forecasting and charting techniques. It examines the risks and benefits of forecasting, teaches different forecasting and trending methods, and explores ways to maximize profit potential.
What you will learn
After completing this course, students will be able to:

  • Describe the role data forecasting plays in organizational planning.

  		•

    Identify the positive and negative aspects of data forecasting.

  		•

    Create formula-based data forecasts.

  		•

    Define best, middle, and worst case scenario data.

  		•

    Calculate moving averages.

  		•

    Chart moving averages interactively.

  		•

    Calculate Net Present Value and Internal Rate of Return.

  		•

    Define and solve problems in Solver.

  		•

    Establish target values using Goal Seek.
    Prerequisites
    Before attending this course, students must have:

  		•

    Experience with analyzing business data to make decisions about products, projects, and strategic direction.

  		•

    The ability to use Excel to create formulas, including advanced formulas using the Insert Function dialog box.

  		•

    Familiarity with named ranges (for example, abbreviations that replace cell addresses, such as C3:D15, with nicknames such as AllSales).

  		•

    The ability to create line graphs and column charts from Excel data.
    Audience

    This course is designed for experienced Microsoft Excel users, including project managers, financial analysts, accountants, business owners, and other business professionals who have a vested interest in forecasting trends at the industrial, corporate, and project levels. This audience uses Excel on a regular basis and has no difficulty creating formulas, charts, and cell formats.
    Duration
    Half day-Instructor-led