Course 4003: Summarizing Microsoft® Office Excel® 2003 Data to Make Better Business Decisions£19.99
Description
Summary: This online course will teach you some of the most effective techniques in data summary and display. It covers the role of business intelligence in today's workplace and introduces the power of Excel in business intelligence analysis. You will also learn how to hone your skills regarding data lists and PivotTables.
Audience: Home and Office Users
Available Offline: Yes
Subscription: 13 months
Course Type: Self-paced Course
Estimated Time of Completion: 3 Hours
Language: English
Description:
One of the great challenges business people face today is not collecting information, but making sense of the information they already have. Within the endless rows of Microsoft® Excel® data is information that can help you make better business decisions, but how can you filter your way through all that information? This online course, through hands-on activities, will teach you some of the most effective techniques in data summary and display. It covers the role of business intelligence in today's workplace and introduces the power of Excel in business intelligence analysis. You will also learn how to hone your skills regarding data lists and PivotTables.
Course Objectives
At the end of the course, students will be able to:
• Describe the role business intelligence plays in organizational planning and explain how to extend business intelligence analysis beyond the spreadsheet.
• Use data lists and SUBTOTAL formulas to summarize your Excel data.
• Create and use PivotTables to visualize worksheet data.
• Limit the data displayed in a PivotTable to only the data needed to make a specific decision.
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
