Forecasting and Trend Analysis Using Microsoft Office Excel 2003

New Horizons Malaysia
Kuala Lumpur, Kuantan, Penang, Petaling Jaya, Malaysia

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.

Who Should Attend:
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.

At Course Completion:
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. - Establish target values using Goal Seek. - Calculate moving averages. - Chart moving averages interactively. - Calculate Net Present Value and Internal Rate of Return. - Define and solve problems in Solver.

Prerequisite Comments:
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: Top
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
Top
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
...''

Elements of this syllabus are subject to change.

Phone:+ 603-26946455

School Address:

3rd Floor, Wisma Thakurdas
Kuala Lumpur,16-1, Jalan Raja Laut 50350
Malaysia


Jobs & Resumes: Kuala Lumpur, Kuantan, Penang, Petaling Jaya
Houses & Roommates: Kuala Lumpur, Kuantan, Penang, Petaling Jaya
Travel Agencies: Kuala Lumpur,

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

RHCT
RHCE
Automated Medical Office
HIPAA Awareness - Privacy and Confidentiality
Human Anatomy & Physiology �Body Systems
Human Anatomy & Physiology �Medical Terms
Medical Coding - Evaluation & Management, Anesthesiology, Surgery
Medical Coding - Surgery, Lab, Radiology, Medicine
Medical Insurance - Billing
Medical Office Procedures and Administration
Beyond the Spreadsheet: Managing Financial Information Using Microsoft Office Access 2003
Career Development
Call Center Management
Call Center
business writing
Business Problem Solving
business etiquette
Business Ethics
Budgeting

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.
 

Tips: Besides Acquiring latest course information by the search form, Students can also leave their study interests here and let schools callback.