Forecasting and Trend Analysis using Microsoft Office Excel 2003

New Horizons Learning Centres of Australia
Sydney, Brisbane, Melbourne, Perth, Newcastle, Australia

Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced

Course Description:

'' In this course, experienced Excel users gain an understanding of advanced data forecasting and charting techniques. It covers the risks and benefits of forecasting, different forecasting and trending methods, and ways to maximize profit potential.
Pre-requisites:
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.
The ability to create line graphs and column charts from Excel data.
Familiarity with named ranges in Excel
Outline:
Lesson 1: The Risks and Benefits of Forecasting Data
- What Is Data Forecasting?
- The Business Needs for Data Forecasting
- Summary of the Risks and Benefits of Data Forecasting
Lesson 2: Creating Formula-Based Forecasts
- Three Formula-Based Forecasting Resources
- Walkthrough: Creating Forecasts from Existing Data
- Demonstration: Analyzing Data by Using Goal Seek
- Exercise: Establishing Targets by Using Goal Seek
- Tips and Tricks for Formula-Based Forecasts
Lesson 3: Forecasting Using Moving Averages
- What Is a Moving Average?
- What Decisions Do Moving Averages Help Me Make?
- Walkthrough 1: Calculating and Charting a Moving Average
- Walkthrough 2: Creating an Interactive Chart
- Tips and Tricks - Refining Moving Average Analysis
Lesson 4: Maximizing Profit Potential
- Net Present Value and Internal Rate of Return
- Walkthrough 1: Calculating Net Present Value
- Walkthrough 2: Calculating Internal Rate of Return
- Introduction to Solver
- Walkthrough 3: Determining Optimal Project Mixes
- Discussion: Best Practices for Defining Problems in Solver
- Summarizing Data Forecasting Benefits
- Next Steps ...''

Phone:+61 2 8263 5900

School Address:

Level 6, St. Martins Tower
31 Market Street
Sydney NSW 2000 Australia
Level 4, 200 Creek Street,
Brisbane, QLD 4000
Level 2, 31 Queen Street,
Melbourne, VIC 3000

Jobs & Resumes: Sydney, Brisbane, Melbourne, Perth, Newcastle
Houses & Roommates: Sydney, Brisbane, Melbourne, Perth, Newcastle

Macromedia Dreamweaver MX 2004 Designing and Developing Web Sites
Macromedia Fireworks MX 2004 Web Graphics and Interactivity
XML
Windows 2000
Windows XP
ACT! 2005
MYOB
Project 2003
Visio Professional 2003
Team Collaboration Using Microsoft Windows Sharepoint Services
Summarising Microsoft Office Excel 2003 Data to Make Better Business Decisions
Managing Critical Business Information Using Microsoft Office Access 2003
Managing Financial Information Using Microsoft Office Access 2003
Time and Task Management Using Microsoft Office Outlook 2003
Windows SharePoint Services Level 2 Building Extended Collaborative Solutions

Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
 

Facts: We provide free training course catalog service since 2003, in English and Chinese. Tens of thousands of visitors search our database from our portal and partners' websites each day.