Hands On Training

Pivot Tables in Spreadsheets

DataCamp

(3)

Course Features

Duration

4 hours

Delivery Method

Online

Available on

Limited Access

Accessibility

Mobile, Desktop, Laptop

Language

English

Subtitles

English

Level

Intermediate

Teaching Type

Self Paced

Video Content

4 hours

Course Description

Large amounts of data can be difficult and time-consuming to manage in spreadsheets. Would you like a quick and efficient way to organize and analyze all your data? Pivot Tables are the solution! This course will teach you how to quickly and efficiently organize thousands of datapoints using Google Sheets. We'll be looking at the average rainfall of several US cities as well as the Top 10 Fortune Global 500. We will also review some films that were released between 2010 and 2016. These examples will show you how to sort, filter, and subtotal your data. By the end of this course, you will be able to create custom pivot tables using any size data!

Course Overview

Virtual Labs

International Faculty

Post Course Interactions

Hands-On Training,Instructor-Moderated Discussions

Skills You Will Gain

Prerequisites/Requirements

Intermediate Spreadsheets

What You Will Learn

Explore the world of Pivot Tables within Google Sheets, and learn how to quickly organize thousands of data points with just a few clicks of the mouse

You will learn techniques such as sorting, subtotaling, and filtering your data using these real world examples

By the end of the course, you will be able to create your own custom pivot tables with datasets of any size!

Course Content

Expand all sections

Module 1: Introduction to Pivot Tables for Google Sheets

Module 2: Behind the Scenes of the Pivot Table

Module 3: Advanced Options

Module 4: Editing Data and Troubleshooting

Course Instructors

Frank Sumanski

Founder, SpreadsheetAllstars.com

My mission is to share my passion and knowledge of Microsoft Excel, Data, and Analytics with the world. I founded Office Innovator to provide corporate and academic Microsoft Excel training, and Spre...

Course Reviews

Average Rating Based on 3 reviews

5.0

100%