Course
|
Excel

Pivot Tables

Pivot Tables allow you to search, filter and sort data very quickly, making them an essential data analysis tool in Excel
3 HOURS
Intermediate
12 Lessons
CPE/CPD & NASBA ACREDITED
Learning Outcomes
Create Pivot Tables from your Excel data
Format the values and cells in a Pivot Table
Adjust the values displayed in a Pivot Table
Leave your number for the fastest response

Get More Info

Looking to understand how Kubicle can better help your organization meet its learning objectives? Book some time with one of our consultants today.
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
helping to build
data, Tech & ai skills in
g2-badgebritish-airwaysjotunamazon-logopwc-logoford-logo
Course
|
Excel

Pivot Tables

Pivot Tables allow you to search, filter and sort data very quickly, making them an essential data analysis tool in Excel
3 HOURS
Intermediate
12 Lessons
CPE/CPD & NASBA ACREDITED
Learning Outcomes
Create Pivot Tables from your Excel data
Format the values and cells in a Pivot Table
Adjust the values displayed in a Pivot Table
Leave your number for the fastest response

Get More Info

Looking to understand how Kubicle can better help your organization meet its learning objectives? Book some time with one of our consultants today.
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.

What’s Included

12 Lessons
Preparing Your Data for Pivot Tables
3 MINS
LESSON
Preparing Your Data for Pivot Tables
Exercise

You need to arrange your data in a certain format before creating a PivotTable. Learn how to do so in this lesson

Build Your First Pivot Table
5 MINS
LESSON
Build Your First Pivot Table
Exercise

Our first Pivot Table will compare the performance of our salespeople by state and provide some insights into how the business is run.

Formatting Pivot Tables
3 MINS
LESSON
Formatting Pivot Tables
Exercise

Pivot Table data initially appears without any formatting. Banded rows, comma separators and other techniques can be used to make your data much more readable.

Changing Pivot Table Output Values
5 MINS
LESSON
Changing Pivot Table Output Values
Exercise

The default SUM output format can be changed to many different alternatives in a Pivot Table. Learn how to apply these alternatives in this lesson

Grouping Date Columns
3 MINS
LESSON
Grouping Date Columns
Exercise

Date columns can be difficult to deal with in a PivotTable unless you know how to use Excel's Group function to format them.

Updating Pivot Tables with New Data
4 MINS
LESSON
Updating Pivot Tables with New Data
Exercise

Adding columns and rows to PivotTables is made easier by using Tables but still requires some changes to your PivotTable settings, notably in the Group settings.

Pivot Table Subtotals
3 MINS
LESSON
Pivot Table Subtotals
Exercise

Subtotals are created when you have more than one row or column label. Learn how to create and format them correctly in this lesson

Sorting Pivot Table Data
3 MINS
LESSON
Sorting Pivot Table Data
Exercise

Pivot Tables come with lots of sorting options for both columns and rows. Learn how to access these options in this short lesson

Apply Filters to Pivot Tables
4 MINS
LESSON
Apply Filters to Pivot Tables
Exercise

Simple filters can be applied to Pivot Tables by manual selection, creating rules and using the search bar. This lesson covers all 3 methods.

Pivot Table Slicers
4 MINS
LESSON
Pivot Table Slicers
Exercise

Slicers are new to Excel 2010 and allow you to perform much better manual selection filters than before

Build Charts from a Pivot Table
3 MINS
LESSON
Build Charts from a Pivot Table
Exercise

Charts can be extracted directly from a Pivot Table, but a better option is to create Pivot Chart directly from the dataset.

Pivot Table Data in Formulas
3 MINS
LESSON
Pivot Table Data in Formulas
Exercise

You might be tempted to insert Pivot Table data into formulas but be careful, this action is has many pitfalls to be wary of.

See More
See Less
Certifications
Earn a certificate with every exam you complete. All successful course completions are recognized by CPD, CPE, and NASBA. As your team gains confidence, skill, and speed, your firm becomes more competitive.
Earn cPE / CPD Credits
No items found.
Get More Info
Looking to understand how Kubicle can better help your organization meet its learning objectives?  Book some time with one of our consultants today.
Contact Information
Looking to speak to someone directly?
01 700 9000
info@kubicle.com
Dublin, Ireland
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
Plus Size YourLearning with Academies+
THE PLATFORM OF CHOICE FOR 1M+ USERS

A Learner Experience Designed to Deliver Transformation

Testimonials

How Leading Teams Use Kubicle to Upskill & Excel

Heineken Case Study
ADL Logo