Excel 2016 for PC – Pivot Tables

£99.00

In the duration of this course you will learn the basics and more advanced features of Pivot Tables on Microsoft Excel 2016.

What are Pivot Tables?

Pivot tables are one of Excel’s most powerful features, they allow you to extract the significance from a large, detailed data set. In large sets of data, it can be hard to extract the information you want, but by building Pivot Tables you are able to ask questions and gain the information required.

Category: Tag:

In the duration of this course you will learn the basics and more advanced features of Pivot Tables on Microsoft Excel 2016.

What are Pivot Tables?

Pivot tables are one of Excel’s most powerful features, they allow you to extract the significance from a large, detailed data set. In large sets of data, it can be hard to extract the information you want, but by building Pivot Tables you are able to ask questions and gain the information required.

What’s Included?

Wiki_tick  Unlimited access for 12 months
Wiki_tick  Access anywhere, any time
Wiki_tick  Fast effective training, written and designed by industry experts
Wiki_tick  Track your progress with our Learning Management System
Wiki_tick  Unlimited support
Wiki_tick  Save money, time and travel costs
Wiki_tick  Learn at your own pace and leisure
Wiki_tick  Easier to retain knowledge and revise topics than traditional methods
Wiki_tick  Exam preparation quizzes, tests and mock exams to ensure that you are 100% ready

£99.00Add to cart

Modules

Microsoft Excel for PC – Pivot Tables

Module 1 – Getting Started

What you’ll learn in this training
What is a Pivot Table?
Selecting appropriate data for a Pivot Table

Module 2 – Creating & Deleting

Creating a Pivot Table
Selecting various data sources
Quick Analysis Tool
Recommended Pivot Table feature
Classic Pivot Table layout in the grid
Select different source data
Delete a Pivot Table

Module 3 – Custom Appearance & Layout

Add and remove field from a pivot table
Add and use the page field
Change the data area number format
Change how empty cells are displayed
Format a Pivot Table
Sort a Pivot Table
View data detail for an item
View detail for a data cell
Exclude row or column items from the data summary
Group Pivot Table by dates

Module 4 – Printing Options & Copying a Pivot Table

Printing a Pivot Table with column and row field
Insert page breaks after each row item
Copy a Pivot Table

Module 5 – Summarizing with Totals & Formulas

Display grand totals
Change the data summary function
Create a calculated field
Insert a calculated item
List the formulas used in a Pivot Table

Module 6 – Refreshing Data

Refreshing Pivot Table data
Refreshing data at specific time intervals

Module 7 – Pivot Charts

Create a Pivot Chart from an existing table
Create a Pivot Chart from scratch
Change the layout of a Pivot Chart
Convert a Pivot chart to a static chart

Module 8 – Sparklines & Slicers

Use sparklines and slicers
Create sparklines
Change the sparkline type
Format sparklines
View the parts of a slicer
Create a slicer
Format a slicer

System Requirements

Minimum specifications for the computer are:

Windows:

Microsoft Windows XP, or later
Modern and up to date Browser (Internet Explorer 8 or later, Firefox, Chrome, Safari)

MAC/iOS:

OSX/iOS 6 or later
Modern and up to date Browser (Firefox, Chrome, Safari)

All systems:

Internet bandwidth of 1Mb or faster
Flash player or a browser with HTML5 video capabilities (We recommend Google Chrome)