| |
|
| |
Summarizing Microsoft Office Excel 2003 Data to Make Better Business Decisions Training Class
Course ID: 5239
|
|
| |
|
|
| |
|
|
| |
Summarizing Microsoft Office Excel 2003 Data to Make Better Business Decisions Training Seminar
Overview:
In this course, students learn effective techniques in data summary and display. It covers the role of business intelligence in the workplace and introduces the power of Excel. Students learn skills regarding data lists and PivotTables.
Who Should Attend:
This course is designed for experienced Excel users who have a vested interest in analyzing Excel data more effectively. This audience is familiar with tracking project budgets and chart trends, and they have no difficulty using Excel to create formulas, charts, and cell formats.
At Course Completion:
After completing this 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 their 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.
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
Agenda |
|
| |
Lesson 1: Deriving Business Intelligence from Excel Data
What Is Business Intelligence?
The Need for Business Intelligence
Discussion: The Need for Business Intelligence
Summary of Discovering Business Intelligence in Excel
|
|
Lesson 2: Summarizing Data Using Lists
Demonstration: Revealing Information in Data Lists
Walkthrough 1: Creating a Data List
Walkthrough 2: Creating a Crosstab Table
Walkthrough 3: Creating a SUBTOTAL Formula
Walkthrough 4: Filtering a Data List
Tips and Tricks for Using Data Lists and SUBTOTAL Formulas
|
Lesson 3: Creating a PivotTable
The Power of PivotTables
Demonstration: Exploring the Capabilities of PivotTables
Walkthrough 1: Creating a PivotTable
Walkthrough 2: Pivoting a PivotTable
Walkthrough 3: Adding Fields to and Removing Fields from the PivotTable
Using PivotTables to Reveal Business Intelligence
|
Lesson 4: Fine-Tuning PivotTables
Demonstration: Filtering Data in PivotTables
Exercise 1: Filtering a PivotTable
Walkthrough 1: Filtering a PivotTable by Using Page Fields
Walkthrough 2: Formatting a PivotTable
Walkthrough 3: Creating a PivotChart
Revealing Business Intelligence by Using Excel
Discussion: Taking Business Intelligence Outside the Workbook
| |
|
| |
|
|
|
| |
|
|
| |
Pre-requisites |
|
| |
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.
Experience with analyzing business data to make decisions about products, projects, and strategic direction.
|
|
|
|
| |
|
|
|
|
| |
|
|
| |
|
|
|
| |
| |
|
|
| |
Summarizing Microsoft Office Excel 2003 Data to Make Better Business Decisions Training Course Dates and Locations
|
|
| |
|
|
| |
Course ID: 5239
| Course Duration: 1 Day
|
|
| |
|
|
| |
Locations: |
|
| |
|
|
| |
|
|
| |
|
|
| |
| Start Date |
Price |
|
Location/Event Details |
Register Online |
Request
More Info |
|
Print/Fax
Register |
|
|
| |
|
|
| |
|
|
|
|
| |
|
|
|
| |
|
|
| |
|
|
| |
Select a market segment to view more courses
|
|
| |
|
|
| |
Or, select a category to view more Information Technology courses
|
|
| |
|
|
| |
 Browse By Category
Browse By Location
Browse New Courses
|
|
| |
|
|
|
| |
| |
|
|
|
|