Introduction To Pivottables And Pivotcharts In Excel

Master data organization and visualization with PivotTables and PivotCharts for streamlined analysis and insights.

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.

Generate PivotCharts to visualize data effectively.

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.

Access to a Microsoft Excel version that supports PivotTables and PivotCharts.

Description

**This course includes downloadable course instructor files and exercise files to work with and follow along.**Welcome to "Introduction to PivotTables and PivotCharts in Excel." This course teaches you the essentials of organizing and visualizing data using PivotTables and PivotCharts. You'll grasp the fundamentals of PivotTables, including creating them from scratch, applying subtotals, and formatting data effectively. Then, you'll delve into PivotCharts, mastering the art of creating and formatting dynamic visual representations of your data.By the end of the course, you should be able to understand how to add interactivity to your PivotTables and charts using slicers and timelines, enhancing your ability to analyze and present data efficiently. Whether you're a beginner seeking to streamline data analysis or a professional aiming to improve your Excel skills, this course equips you with invaluable data management and visualization tools. Join us and unlock the power of PivotTables and PivotCharts in Excel.In this course, you will learn how to:Create PivotTables from scratch for data organization.Apply subtotals and grand totals for data summarization.Format PivotTable data with number formatting techniques.Generate PivotCharts to visualize data effectively.Insert and format slicers for interactive data filtering.Update PivotTable data dynamically for real-time analysis.This course includes:114 minutes of video tutorials23 individual video lecturesCourse Files to follow alongCertificate of completion

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

Section 2: PivotCharts

Lecture 16 Creating a PivotChart

Lecture 17 Formatting a PivotChart - Part 1

Lecture 18 Formatting a PivotChart - Part 2

Lecture 19 Using Map Charts

Lecture 20 Exercise 02

Section 3: Adding Interaction to PivotTables and Charts

Lecture 21 Inserting and Formatting Slicers

Lecture 22 Inserting Timeline Slicers

Lecture 23 Connecting Slicers to PivotCharts

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.