Excel PivotTable Quick Tips

Focused View

Jess Stratton

16:30

372 View

01 - Introduction

01 - Analyze your data quickly with PivotTables.mp4

00:34

02 - 1. PivotTable Basics

01 - Get data ready for a PivotTable.mp4

00:59

02 - Create a basic PivotTable.mp4

00:55

03 - Use a recommended PivotTable.mp4

00:42

03 - 2. Adjusting PivotTable Data

01 - Rearrange a PivotTable.mp4

01:07

02 - Calculate values in a PivotTable.mp4

00:52

03 - Summarize values in a PivotTable.mp4

01:12

04 - Expand and collapse details in a PivotTable.mp4

00:49

05 - Format data in a PivotTable.mp4

01:05

06 - Group data in a PivotTable.mp4

00:45

04 - 3. Filtering and Sorting Data

01 - Filter data in a PivotTable.mp4

00:37

02 - Sort data in a PivotTable.mp4

00:19

05 - 4. Conditional Formatting with PivotTables

01 - Apply conditional formatting to a PivotTable.mp4

00:55

02 - Remove conditional formatting from a PivotTable.mp4

00:36

06 - 5. PivotCharts and Slicers

01 - Create a basic PivotChart.mp4

01:03

02 - Insert slicers into a PivotTable.mp4

01:17

07 - 6. Addressing Common Error Messages

01 - PivotTable error messages Field name not valid.mp4

00:53

02 - Refresh a PivotTable.mp4

00:36

03 - PivotTable error messages Overlapping reports.mp4

01:14

Description

Excel PivotTables–which allow you to quickly calculate and analyze large amounts of data–are one of the most powerful features of Microsoft’s ubiquitous spreadsheet tool. But many users have only a basic understanding of how PivotTables work. In this course, instructor Jess Stratton offers a plethora of bite-sized tips designed to deepen your understanding of how PivotTables work and how to use them more effectively.

Learn how to properly format data and create a basic PivotTable in Excel. Discover ways to adjust, rearrange, and group data to calculate and summarize values that you can put to use on the job. Get tips on data filtering and sorting, conditional formatting, and using PivotCharts and slicers. Along the way, Jess shows how to deal with common PivotTable error messages, such as invalid field names and overlapping reports. By the end of this course, you’ll be able to create more robust PivotTables in minutes—just in time for that next meeting.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

Excel

Excel Modeling

Jess Stratton

Instructor's Courses

I am an instructor with LinkedIn Learning - With over 300 hours of instructional content on Lynda.com, my courses are specialized for businesses, home office, social media, and personal use focusing on Google Apps, Microsoft Office, home tech, and productivity/mobile apps. My writings have been in computer textbooks, and I have several published articles in industry magazines and major websites including Lifehacker.org. I'm a frequent speaker at large industry conferences about productivity, web, and Lotus Notes/Domino. I used to own and operate a successful brick-and-mortar boutique style computer learning facility in downtown shopping district. I LOVE my job. I get to help people be the very best at their own jobs.

Linkedin Learning

View courses Linkedin Learning

LinkedIn Learning is an American online learning provider. It provides video courses taught by industry experts in software, creative, and business skills. It is a subsidiary of LinkedIn. All the courses on LinkedIn fall into four categories: Business, Creative, Technology and Certifications. It was founded in 1995 by Lynda Weinman as Lynda.com before being acquired by LinkedIn in 2015. Microsoft acquired LinkedIn in December 2016.