Summarising Microsoft Office Excel 2003 Data to Make Better Business Decisions

New Horizons Learning Centres of Australia
Sydney, Brisbane, Melbourne, Perth, Newcastle, Australia

Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced

Course Description:

'' 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.
Pre-requisites:
Experience with analyzing business data to make decisions about products, projects, and strategic direction.
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.
Outline:
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 ...''

Phone:+61 2 8263 5900

School Address:

Level 6, St. Martins Tower
31 Market Street
Sydney NSW 2000 Australia
Level 4, 200 Creek Street,
Brisbane, QLD 4000
Level 2, 31 Queen Street,
Melbourne, VIC 3000

Jobs & Resumes: Sydney, Brisbane, Melbourne, Perth, Newcastle
Houses & Roommates: Sydney, Brisbane, Melbourne, Perth, Newcastle

Macromedia Fireworks MX 2004 Web Graphics and Interactivity
XML
Windows 2000
Windows XP
ACT! 2005
MYOB
Project 2003
Visio Professional 2003
Team Collaboration Using Microsoft Windows Sharepoint Services
Forecasting and Trend Analysis using Microsoft Office Excel 2003
Managing Critical Business Information Using Microsoft Office Access 2003
Managing Financial Information Using Microsoft Office Access 2003
Time and Task Management Using Microsoft Office Outlook 2003
Windows SharePoint Services Level 2 Building Extended Collaborative Solutions
InfoPath 2003 Creating Forms

Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
 

Facts: We provide free training course catalog service since 2003, in English and Chinese. Tens of thousands of visitors search our database from our portal and partners' websites each day.