A Small Class Size is the Best Learning Environment*
Only F1 has no more than 6 Delegates in a Class
Everyone has Individual Attention from the Trainer

View Recent History

Visual Studio 2005 Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(8521) Microsoft CRM 3.0 Sales Management - Microsoft Training Courses in London and South West
Course:(8524) Microsoft CRM 3.0 Service Scheduling - Microsoft Training Courses in London and South West
Course:(4005) Beyond the Spreadsheet: Managing Financial Information Using Microsoft Office Access 2003 - Microsoft Training Courses in London and South West
Course:(8879) Using the Microsoft Dynamics Sure Step Methodology for Microsoft Dynamics CRM - Microsoft Training Courses in London and South West
Windows Server 2008 Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(4006) Time and Task Management Using Microsoft Office Outlook 2003 - Microsoft Training Courses in London and South West
Course:(8912) Customisation and Configuration in Microsoft Dynamics CRM 4.0 - Microsoft Training Courses in London and South West
Course:(F1033) Fast Track to Microsoft Dynamics CRM 4.0 Certification: Become a CRM Developer in 5 Days Flat! - Microsoft Training Courses in London and South West
Exchange Server 2010 Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(80054) Project Managing Microsoft Dynamics CRM Implementations with Microsoft Dynamics Sure Step - Microsoft Training Courses in London and South West
Course:(F1034) Fast Track to Microsoft Dynamics CRM 4.0 Certification: Become a CRM Expert in 7 Days Flat! - Microsoft Training Courses in London and South West
Course:(F1023) What's New in Microsoft CRM 3.0 - Technical - Microsoft Training Courses in London and South West
Course:(80141) Integrating Microsoft Dynamics CRM 4.0 and Microsoft Office SharePoint Server 2007 - Microsoft Training Courses in London and South West
Course:(8911) Installation and Deployment in Microsoft Dynamics CRM 4.0 - Microsoft Training Courses in London and South West
Course:(4003) Summarizing Microsoft Office Excel 2003 Data to Make Better Business Decisions - Microsoft Training Courses in London and South West
Course:(80003) Workflow in Microsoft Dynamics CRM 4.0 - Microsoft Training Courses in London and South West
Course:(8913) Applications in Microsoft Dynamics CRM 4.0 - Microsoft Training Courses in London and South West
Course:(8529) Microsoft CRM 3.0 Administration - Microsoft Training Courses in London and South West
Visual Basic .NET Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(4008) Building Better Microsoft Office Word 2003 Documents in Less Time - Microsoft Training Courses in London and South West
Course:(F1024) What's New in Microsoft CRM 3.0 - Applications - Microsoft Training Courses in London and South West
Application Centre Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(8530) Microsoft CRM 3.0 Data Migration - Microsoft Training Courses in London and South West
Knowledge Management Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(8531) Extending Microsoft CRM 3.0 - Microsoft Training Courses in London and South West
Course:(F1029) Intermediate Microsoft Dynamics CRM 4 for Small and Medium Businesses - Microsoft Training Courses in London and South West
Course:(8526) Microsoft CRM 3.0 Installation and Configuration - Microsoft Training Courses in London and South West
Visual Studio 6.0 Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(8910) What's New in Microsoft Dynamics CRM 4.0 - Microsoft Training Courses in London and South West
Visual Basic 6.0 Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(F1032) Fast Track to Microsoft Dynamics CRM 4.0 Certification: Become a CRM Power User in 3 Days Flat! - Microsoft Training Courses in London and South West
Visual Studio 2010 Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(8969) Extending Microsoft Dynamics CRM 4.0 - Microsoft Training Courses in London and South West
Course:(8522) Microsoft CRM 3.0 Marketing Automation - Microsoft Training Courses in London and South West
Course:(F1028) Introduction to Microsoft Dynamics CRM 4 for Small and Medium Businesses - Microsoft Training Courses in London and South West
Course:(F1037) Customisation of xRM/CRM for Microsoft Partners and Customers - Microsoft Training Courses in London and South West
Course:(8525) Microsoft CRM 3.0 Customization - Microsoft Training Courses in London and South West
Course:(F1030) Advanced Microsoft Dynamics CRM 4 for Small and Medium Businesses - Microsoft Training Courses in London and South West
Course:(80047) Using Microsoft Dynamics Sure Step - Microsoft Training Courses in London and South West
Visual Studio .NET Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(80002) Administration in Microsoft Dynamics CRM 4.0 - Microsoft Training Courses in London and South West
indexes/Certification_courses_index.aspx Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(3373) First Look: Getting Started with Windows SharePoint Services 3.0 Hands-On Lab - Microsoft Training Courses in London and South West
Visual Studio 2008 Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(F1035) Fast Track to Microsoft Dynamics CRM 4.0 Certification: Become a CRM Guru in 10 Days Flat! - Microsoft Training Courses in London and South West

Compare Recently Viewed Course Dates


Exclusive
Office

Summarizing Microsoft Office Excel 2003 Data to Make Better Business Decisions
(Microsoft Training Course: 4003) - 0.5 day - £600 exc VAT

We currently do not have any dates scheduled for this course.
Please contact us to arrange a closed course for your company or add your details to courses in waiting.
(Remember F1 has smaller classes)
Ask a Question ?Print 2 Page PDF


> Target Audience
This 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. This course is designed for experienced Excel users who have a vested interest in analyzing Excel data more effectively.
> Course outline
  1. Deriving Business Intelligence from Excel Data
  2. Summarizing Data Using Lists
  3. Creating a PivotTable
  4. Fine-Tuning PivotTables
Module 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
Skills
  • Describe the business intelligence process.
  • List the needs for business intelligence.
  • Explain how to extend business intelligence analysis beyond the spreadsheet.
  • Summarize business intelligence analysis in Excel.
top
Module 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
Skills
  • Create a data list.
  • Filter data lists.
  • Add a Total row to a data list.
  • Summarize data using SUBTOTAL formulas.
top
Module 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
Skills
  • Describe PivotTable views.
  • Create a PivotTable.
  • Pivot a PivotTable.
  • Add fields to and remove fields from a PivotTable.
top
Module 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
Skills
  • Filter a PivotTable.
  • Filter a PivotTable using Page fields.
  • Apply an AutoFormat to a PivotTable.
  • Create a PivotChart.
top
> Pre-Requisites
Before attending this course, students must have the following pre-requisites:
  • Experience with analyzing business data to make decisions about products, projects, and strategic direction.
  • The ability to create formulas, including advanced formulas using the Insert Function dialog box.
  • The ability to create line graphs and column charts from Excel data.
> Purpose
After completing 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 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.
> EXAMS
There are no exams directly associated with this course