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.