Excel 2016 for PC – Pivot Tables - Only £12
e-courses4you
Summary
- Tutor is available to students
Overview
Learn how to develop a whole new appreciation for the information in your spreadsheets with our Excel 2016 for PC - Pivot Tables course.
Learn how to develop a whole new appreciation for the information in your spreadsheets with our Excel 2016 for PC - Pivot Tables course
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.
Unlimited access for 60 days
Access anywhere, any time
Fast effective training, written and designed by industry experts
Track your progress with our Learning Management System
Unlimited support
Save money, time and travel costs
Learn at your own pace and leisure
Easier to retain knowledge and revise topics than traditional methods
What the course will teach you:
- Select appropriate data for a Pivot Table
- Create a Pivot Table
- To use the Quick Analysis Tool
- Delete a Pivot Table
- Format a Pivot Table
- Print a Pivot Table with column and row field
- View and extract data from a Pivot Table
Description
Excel 2016 for PC – Pivot Tables - Only £12
Units Of Study
Description
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
Questions and answers
Currently there are no Q&As for this course. Be the first to ask a question.
Reviews
Currently there are no reviews for this course. Be the first to leave a review.
Add to basket or enquire
Course provided by
Legal information
This course is advertised on reed.co.uk by the Course Provider, whose terms and conditions apply. Purchases are made directly from the Course Provider, and as such, content and materials are supplied by the Course Provider directly. Reed is acting as agent and not reseller in relation to this course. Reed's only responsibility is to facilitate your payment for the course. It is your responsibility to review and agree to the Course Provider's terms and conditions and satisfy yourself as to the suitability of the course you intend to purchase. Reed will not have any responsibility for the content of the course and/or associated materials.
