Introduction To Pivottables And Pivotcharts In Excel

Published 1/2025
MP4 | Video: h264, 1920×1080 | Audio: AAC, 44.1 KHz

What you’ll learn

Create PivotTables from scratch for data organization.

Apply subtotals and grand totals for data summarization.

Format PivotTable data with number formatting techniques.

Insert and format slicers for interactive data filtering.

Update PivotTable data dynamically for real-time analysis.

Requirements

Basic Excel knowledge.

Data organization skills.

Experience with basic Excel formulas.

Description

Overview

Section 1: PivotTables

Lecture 1 Course Introduction

Lecture 2 WATCH ME: Essential Information for a Successful Training Experience

Lecture 3 DOWNLOAD ME: Course Files

Lecture 4 DOWNLOAD ME: Exercise Files

Lecture 5 PivotTables Explained

Lecture 6 Creating a PivotTable from Scratch

Lecture 7 Pivoting the PivotTable Fields

Lecture 8 Applying Subtotals and Grand Totals

Lecture 9 Applying Number Formatting to PivotTable Data

Lecture 10 Show Values As and Summarize Values By

Lecture 11 Grouping PivotTable Data

Lecture 12 Formatting Error Values and Empty Cells

Lecture 13 Choosing a Report Layout

Lecture 14 Applying PivotTable Styles

Lecture 15 Exercise 01

Lecture 20 Exercise 02

Lecture 21 Inserting and Formatting Slicers

Lecture 22 Inserting Timeline Slicers

Lecture 24 Updating PivotTable Data

Lecture 25 Exercise 03

Lecture 26 Course Close

Individuals who are new to Excel and want to learn foundational skills in data organization and visualization.,Business professionals who regularly work with data and want to enhance their reporting and data analysis capabilities.,Data Analysts and Researchers looking to efficiently summarize, organize, and present data insights to inform decision-making.,Professionals who oversee projects and need to create reports that summarize data trends and project metrics effectively.