Forecasting and Trend Analysis using Microsoft Office Excel 2003

New Horizons Learning Centres of Australia
Brisbane, Melbourne, Newcastle, Perth, Sydney, 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:


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:1300 794 006

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

9 Denison Street,
Newcastle West NSW 2302


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

Search other schools for Forecasting and Trend Analysis using Microsoft Office Excel 2003 training resources.

Visio Professional 2007
Microsoft Windows SharePoint Services 3.0
InfoPath 2007
SharePoint 2007
QuarkXPress 6.0
Microsoft Office 2007
MS Word 2007
Windows Vista
Microsoft Expression Web 2007
Team Collaboration Using Microsoft Windows SharePoint Services
Access 2007
Lotus Notes 7
Managing Critical Business Information Using Microsoft Office Access 2003
VBA ACCESS 2003
Managing Financial Information Using Microsoft Office Access 2003
Web Design with XHTML, HTML, and CSS
Time and Task Management Using Microsoft Office Outlook 2003
XML
FileMaker Pro 7.0

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.