Excel For Mac 3 Pivot Tables Intro & Masterclass

Create data analysis in Excel using Pivot Tables with just a few clicks, together with summary Pivot Charts. Exam 70-779
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.
Create Pivot Charts in a few simple clicks.
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
This course covers one of the most useful, but scariest-sounding, functions in Microsoft Excel; PIVOT TABLES.It sounds difficult, but in fact can be done in just a few clicks. We'll do our first one in a couple of minutes - that's all it takes. We'll also add a chart as well in that time.After only these first few minutes, you will be streets ahead of anyone who doesn't know anything about Pivot Tables - it is really that important.After this introduction, we'll go into some detail into how to set up your Pivot Table - the initial data, and the various options that are available to you. We will go into advanced options that most people don't even know about, but which are very useful. This includes using conditional formatting, adding slicers and timelines so that you can create dashboards, and advanced calculations, such as Percentage of total, Cumulative totals, and calculated fields and items. We'll also have a look at Pivot Charts and their relationship to Pivot Tables.By the end, you will be an Expert user of Pivot Tables, able to create reliable analyses which are able to be drilled-down quickly, and you'll be able to help others with their data analysis.
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
Section 2: Creating our first PivotTable and PivotChart
Lecture 6 Our first PivotTable
Lecture 7 PivotTable Menus
Lecture 8 Update from Microsoft
Lecture 9 Creating charts from PivotTables (old version)
Lecture 10 Update from Microsoft 2
Lecture 11 Creating Pivot Charts (new version)
Lecture 12 PivotChart Menus and An Introduction to Practice Activity 1
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
Section 11: PivotCharts
Lecture 78 Welcome to Pivot Charts
Lecture 79 Relationship of Pivot Chart with Pivot Table
Lecture 80 Options and Styles
Lecture 81 Bubble charts
Lecture 82 Adding legends
Lecture 83 Positioning and Resizing charts and graphs, inc. moving charts into chart sheets
Lecture 84 Modifying chart and graph parameters
Lecture 85 Applying chart layouts and styles
Lecture 86 Bonus Lecture
This is for you if you have ever heard of the "Pivot Table", but didn't know what it is or how to use it.,This is also for you if you use PivotTables, and want to go deeper. Much deeper. :-),We'll also go into the more advanced functions, and create charts as well, quickly and easily.
Screenshots