Excel For Mac 3: Pivot Tables Intro & Masterclass

Excel For Mac 3: Pivot Tables Intro & Masterclass
Last updated 9/2021
MP4 | Video: h264, 1280×720 | Audio: AAC, 44.1 KHz

What you’ll learn
Create Pivot Tables with a just a few clicks, simply and quickly.
Maintain and expand Pivot Tables.
Update data sources, and maintain formatting during refreshes.
Know and use about the more advanced features, and create advanced Pivot Tables.
Find out how much powerful it is, and how quickly it can improve your data analysis.
Requirements
You should be able to open and save Microsoft spreadsheets. You should also be able to enter data.
That’s it! We’ll create our first Pivot Table in just a couple of minutes – that’s all.
Description
Overview

Section 1: Introduction

Lecture 1 Welcome

Lecture 2 Welcome to Udemy

Lecture 3 Introduction to Udemy

Lecture 4 Do you want auto-translated subtitles in more languages?

Lecture 5 Curriculum

Lecture 6 Our first PivotTable

Lecture 7 PivotTable Menus

Lecture 8 Update from Microsoft

Lecture 10 Update from Microsoft 2

Lecture 13 Practice Activity Number 1

Lecture 14 Answer to Practice Activity 1

Section 3: Expanding our PivotTable

Lecture 15 Source data requirements

Lecture 16 Adding additional values

Lecture 17 Recommended PivotTables

Lecture 18 Moving PivotTable

Lecture 19 Refresh PivotTable – why it doesn’t auto-update

Lecture 20 Extracting data

Lecture 21 Sorting

Lecture 22 Practice Activity Number 2

Lecture 23 Answer to Practice Activity 2

Section 4: Going deeper in our PivotTable

Lecture 24 Adding additional row fields

Lecture 25 Different layouts – Compact, Outline and Tabular

Lecture 26 Blank Rows

Lecture 27 Group Records

Lecture 28 Showing or hiding additional detail – the +/- buttons

Lecture 29 Adding columns

Lecture 30 Adding page fields

Lecture 31 Adding filters

Lecture 32 Changing source

Lecture 33 Using a table source

Lecture 34 Final options

Lecture 35 Introduction to Practice Activity 3

Lecture 36 Practice Activity Number 3

Lecture 37 Answers to Practice Activity 3

Section 5: Modify field selections

Lecture 38 Change aggregate (COUNT, MIN, MAX)

Lecture 39 Repeat All

Lecture 40 Using Conditional Formatting to hide Repeat All

Lecture 41 Grand Totals

Lecture 42 Adding subtotals

Lecture 43 Show items with no data

Lecture 44 Practice Activity Number 4

Lecture 45 Answers to Practice Activity 4

Section 6: PivotTable Options

Lecture 46 Display

Lecture 47 Row filters and Allow multiple filters per field

Lecture 48 Layout

Lecture 49 Data and Alt Text

Lecture 50 Practice Activity Number 5

Lecture 51 Answers to Practice Activity Number 5

Section 7: Slicers

Lecture 52 Create slicers

Lecture 53 Identifying impossible options, and selecting more than one option at once.

Lecture 54 Join to multiple PivotTables

Lecture 55 Options

Lecture 56 Practice Activity Number 6

Lecture 57 Answer to Practice Activity 6

Section 8: Dates

Lecture 58 Aggregates

Lecture 59 Group by time period and Slicers

Lecture 60 Practice Activity Number 7

Lecture 61 Answer to Practice Activity 7

Section 9: Formatting

Lecture 62 Formatting number values

Lecture 63 Custom Formatting – number formatting

Lecture 64 Custom Formatting – dates and text

Lecture 65 Custom Formatting – sections and colors

Lecture 66 Conditional Formatting – Highlighting cells

Lecture 67 Conditional Formatting – Data Bars and Color Sets

Lecture 68 Styles

Lecture 69 Practice Activity Number 8

Lecture 70 Answer to Practice Activity 8

Section 10: Advanced calculations

Lecture 71 Percentage of total

Lecture 72 Percentage of total – Advanced

Lecture 73 Difference from

Lecture 74 Cumulative totals

Lecture 75 Index

Lecture 76 Calculated fields

Lecture 77 Calculated items

Lecture 80 Options and Styles

Lecture 82 Adding legends

Lecture 86 Bonus Lecture