From the course: Cert Prep: Excel Expert - Microsoft Office Specialist for Office 2019 and Office 365
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Create and modify PivotTables
From the course: Cert Prep: Excel Expert - Microsoft Office Specialist for Office 2019 and Office 365
Create and modify PivotTables
- [Instructor] In this video, we are going to look at how to create and modify PivotTables. We will modify field selections and options, create slicers, so that we can filter our information, group our PivotTable data, add a calculated field and see how easy it is to format the data. Lets take a look at our PivotTables workbook. Now, on the exam, you may be asked to modify an existing PivotTable, and I happen to have one in this workbook. Two trees 2016 sales, and its in a PivotTable format. When you're working in a PivotTable or a PivotChart, you will have your PivotTable tools, and then analyze and design tabs that are available to you. Under your analyze tab, over on the far right hand side, you have a show group. If you're not seeing your field list, click field list and that window will open, so that you can look and see which fields are available to you, which ones have been added as a filter, a…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
-
-
-
-
(Locked)
Create and modify dual-axis and combo charts2m 47s
-
(Locked)
Create and modify box and whisker and funnel charts5m 55s
-
(Locked)
Create and modify histogram and map charts6m 27s
-
(Locked)
Create and modify sunburst and waterfall charts6m 39s
-
(Locked)
Create and modify PivotTables7m 44s
-
(Locked)
Create and modify PivotCharts6m 5s
-
(Locked)
Challenge: Manage advanced charts and tables28s
-
(Locked)
Solution: Manage advanced charts and tables5m 40s
-
(Locked)
-
-