Data Analysis With Pivot Tables

The University of Auckland Business School
Auckland, New Zealand

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

Course Description:

'' Many organisations are faced with information overload with vast amounts of detailed data being generated as part of standard operations. The challenge facing a decision maker is one of making sense from this mass of data. Data analysis involves extracting meaning that is solution oriented from data that is a simple record of events. The approach to doing this involves summarising the data to focus on key aspects and extracting meaning from these summaries.

Topics Covered
In this course we use a very powerful capability of the Excel spreadsheet environment namely Pivot Table Analysis. A pivot table gives you deep insight into your data that may not always be obvious. It enables you to crunch large volumes of data into meaningful and understandable summaries; yet you can also drill down into any part of the summarised data to examine details at finer levels. The basis used to summarise data can be defined in numerous ways depending on the nature of the questions you want to ask. Finally, we will use various graphical displays to visualise what the data is telling you.

This course will cover

Modelling a problem with pivot table fundamentals
Creating and customising pivot tables
Controlling how you view pivot data
Pivot charts and other visualisations
Sharing pivot tables
...''

Elements of this syllabus are subject to change.

Phone:0800 800 875

School Address/Venue(s):

The University of Auckland - Business School,
Graduate School of Enterprise.
Private Bag 92019, Auckland
New Zealand

Jobs & Resumes: Auckland
Houses & Roommates: Auckland
Travel Agencies: Auckland

Search other schools for Data Analysis With Pivot Tables training resources.

Accounting
Advanced Train the Trainer
Achieving Success
Appreciative Inquiry
Assertiveness Skills
Building Sustainable Relationships
Business Acumen
Business Skills for Administration Professionals
Business Skills for New Managers
Conflict Management
Business Writing Skills
Influencing & Persuading Skills
Interpersonal Communication Skills
Knowledge Management
Media Training and Fundamentals of PR
Mental Fitness
Neuro-Linguistic Programming for Business
Organisation Structure and Design
Presentation Skills

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.
 

Tips: If you want to post any message on this website, please do not include your real name, phone number, email address in the message body area. You should enter them in line text boxs respectively, if needed.