| Course Overview |
| Module Introduction |
| How to Use this Course |
| Course Information |
| Deriving Business Intelligence from Excel Data |
| Module Introduction |
| Defining Business Intelligence and Its Tools |
| Lesson Introduction |
| Defining Business Intelligence |
| Using Spreadsheet Technologies for Business Intelligence |
| Self Test |
| Recognizing the Need for Business Intelligence |
| Lesson Introduction |
| Using Business Intelligence Internally |
| Analyzing Competition |
| Delegating Specific Process Analysis |
| Self Test |
| Identifying the Risks of Business Intelligence |
| Lesson Introduction |
| Mitigating the Risks of Business Intelligence |
| Prioritizing the Need for Business Intelligence |
| Self Test |
| Module Summary |
| Summarizing Data By Using Lists |
| Module Introduction |
| Discovering Information in Data Lists |
| Lesson Introduction |
| Defining a Data List |
| Prerequisites of Creating a Data List |
| Self Test |
| Lab A: Creating a Data List |
| Lesson Introduction |
| Scenario |
| Exercises |
| Lab Review |
| Converting a Crosstab Table to a Data List |
| Lesson Introduction |
| Using Crosstab Tables |
| Converting a Crosstab Table to a Data List |
| Self Test |
| Summarizing List Data Using a SUBTOTAL Formula |
| Lesson Introduction |
| Using a SUBTOTAL formula |
| Summarizing Microsoft Office Excel 2003 Data to Make Better Business Decisions |
| Creating a SUBTOTAL Formula |
| Self Test |
| Lab B: Filtering a List |
| Lesson Introduction |
| Scenario |
| Exercises |
| Lab Review |
| Tips for Using Data Lists and SUBTOTAL Formulas |
| Lesson Introduction |
| Best Practices for Using Data Lists and SUBTOTAL Formulas |
| Timesaving Measures Using Data Lists and SUBTOTAL Formulas |
| Self Test |
| Module Summary |
| Creating a PivotTable |
| Module Introduction |
| The Power of PivotTables |
| Lesson Introduction |
| Presenting Data in Excel |
| Using PivotTables in Excel |
| Exploring the Capabilities of PivotTables |
| Identifying the Essentials of Using PivotTables |
| Self Test |
| Lab A: Creating a PivotTable |
| Lesson Introduction |
| Scenario |
| Exercises |
| Lab Review |
| Lab B: Working with a PivotTable |
| Lesson Introduction |
| Scenario |
| Exercises |
| Lab Review |
| Module Summary |
| Fine-Tuning PivotTables |
| Module Introduction |
| Filtering Data and Formatting in PivotTables |
| Lesson Introduction |
| Describing PivotTable Filters |
| Filtering Data in PivotTables |
| Revealing Business Intelligence by Using Excel |
| Self Test |
| Lab A: Working with a PivotTable and PivotChart |
| Lesson Introduction |
| Scenario |
| Exercises |
| Lab Review |
| Module Summary |
Cursos online
Cursos Presenciais
Course in English
