Course 4002: Forecasting and Trend Analysis Using Microsoft® Office Excel® 2003£19.99
Description
Summary: This course provides 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.
Audience: Home and Office Users
Available Offline: Yes
Subscription: 12 months
Course Type: Self-paced Course
Estimated Time of Completion: 3 Hours
Language: English
Description:
This course provides 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.
Course Objectives
At the end of the 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.
Technical Requirements
To view this course, you need:
• A Pentium II, 256 MB RAM with a processor speed greater than or equal to 400 MHZ
• Microsoft® Windows® 2000 or higher
• Microsoft Internet Explorer 6.0 or higher
• Macromedia Flash 7.0 or higher (1MB disk space needed to install)
• Microsoft Windows Media Player 7.0 or higher
• Microsoft XML Core Services 3.0 or higher
• A Super VGA monitor with minimum screen resolution 1024x768, with 16-bit color.
• A sound card, and either speakers or headphones (for multi-media audio).
• Internet bandwidth of 56K or faster. Broadband internet access is recommended.
For courses containing Virtual Server-based labs (courses in the IT Professional and Developer Catalog), you will need:
• Microsoft Virtual Server ActiveX control (1MB disk space needed to install)
Accessibility Requirements
The following software must be running on your computer in order to access this course with Screen Reader Software:
• Microsoft Internet Explorer 6.0 or higher
• Window-Eyes from GW Micro
• JAWS from Freedom Scientific
• MSAA enabled
You may also be interested in...
Course 4100: Core Training for Microsoft Office Access 2003£19.99
Summary: This course introduces the basic features and tools of Microsoft® Office Access 2003, including the following: getting to know Access, creating a new database, importing and exporting information, simplifying data entry with forms, locating specific information, keeping information accurate, working with reports, making it easy for others to use the database, and keeping information secured. This course has been certified as Microsoft Office Specialist Approved Courseware, and covers all exam skill standards.
Course 4103: Core Training for Microsoft Office PowerPoint 2003£19.99
Summary: This course introduces the basic features and tools of Microsoft® Office PowerPoint® 2003, including the following: creating presentations, working with slides, making presentations look consistent, working with shapes, working with graphics, working with tables, charts, and diagrams, creating multimedia presentations, reviewing and sharing presentations, preparing a presentation for printing or web publication, and setting up and delivering slide shows. This course has been certified as Microsoft Office Specialist Approved Courseware, and covers all exam skill standards.
Course 4104: Core Training for Microsoft Office Outlook 2003£19.99
