Teach on Udemy

Turn what you know into an opportunity and reach millions around the world.

Learn More

Your cart is empty.

Keep shopping

Pivot Tables, Power Pivot Tables, Power Query & Power BI

Name: Pivot Tables, Power Pivot Tables, Power Query & Power BI
Rating: 4.5 (2307 reviews)

5 Course Excel Bundle: Microsoft Excel, Pivot Tables, Power Pivot Tables, Power Query & Power BI (Excel 2007-2019, O365)

Created byMyExcelOnline John Michaloudis, Bryan Hong

Last updated 2/2021

English

What you'll learn

Become more PRODUCTIVE at using Microsoft Excel which will SAVE YOU HOURS per day & ELIMINATE STRESS at work!
We teach you how to use Microsoft Excel with CONFIDENCE that will lead to greater opportunities like a HIGHER SALARY and PROMOTIONS!
Increase your Microsoft Excel SKILLS and KNOWLEDGE within HOURS which will GET YOU NOTICED by Top Management & prospective Employers!
COURSE #1: Learn ALL the Pivot Table features: Slicers, Pivot Charts, Filtering, Grouping, Sorting, Dashboards, Data Analysis, Calculated Fields plus MORE!
COURSE #2: Learn Power Pivot, DAX Formulas, Measures, Calculated Columns & Table Relationships!
COURSE #3: Learn Power Query (Get & Transform), import & transform your data, consolidate from multiple workbooks, folders, worksheets plus MORE!
COURSE #4: Learn Power BI and create interactive Dashboards that tell a story about your data!
COURSE #5: 333 Excel Keyboard Shortcuts explained, covering Formatting, Ribbon, Formulas, VBA, Pivot Tables, Power BI plus MORE!
7 COURSE BONUSES: Excel PDF Cheat Sheets, 101 Ready Made Excel Templates, plus MORE!!!
ADDED BONUS: This entire courses can be DOWNLOADED for offline viewing on the Udemy mobile app (Android & iOS)!
DOWNLOADABLE Excel workbooks so you can keep on your desktop & practice!
Test your skills with various real life Quizzes & Homework Practice Activities & Assignments!
Personal Excel support from Professional Excel Trainers with 30+ Years of combined Excel Training!

Course content

38 sections • 402 lectures • 18h 26m total length

COURSE INTRODUCTION3:54
A MESSAGE FROM YOUR INSTRUCTOR - JOHN MICHALOUDIS3:38
EXCEL WORKBOOKS - IMPORTANT INSTRUCTIONS (PLEASE READ)0:30
Dear Student,
Each tutorial comes with an Excel workbook which you can download at the start of each chapter and keep on your desktop to practice forever!
These workbooks are in a finished form with the Pivot Table already created for you, as I show you during the video.
It is recommended that you follow along by creating a new Pivot Table simply by clicking in the data within the Data_Table sheet of each workbook and going to Insert > Pivot Table > New Worksheet.
You can then follow along as I go through the instructions in each tutorial.
By re-creating the Pivot Table from the beginning, this is the best way to learn and enhance your Excel knowledge!

Thank You,
John Michaloudis
Chief Inspirational Officer
www.MyExcelOnline.com
HANDOUT #1: COURSE TRACKER EXCEL WORKBOOK [FREE EXCEL WORKBOOK DOWNLOAD]0:13
HANDOUT #2: PIVOT TABLE CHEAT SHEET [FREE PDF DOWNLOAD]
HANDOUT #3: 5 SPEEDY STEPS TO AN EXCEL PIVOT TABLE [FREE PDF DOWNLOAD]
Bonus Cheat Sheet
HANDOUT #4: 101 READY MADE EXCEL TEMPLATES [FREE EXCEL WORKBOOKS DOWNLOAD]
HANDOUT#5: 50+ EXCEL KEYBOARD SHORTCUTS IN A KEYBOARD LAYOUT [FREE PDF DOWNLOAD]

WORKBOOKS0:02
Dear Student,

Each tutorial comes with an Excel workbook which you can download at the start of each chapter and keep on your desktop to practice forever!

These workbooks are in a finished form with the Pivot Table already created for you, as I show you during the video.

It is recommended that you follow along by creating a new Pivot Table simply by clicking in the data within the Data_Table sheet of each workbook and going to Insert > Pivot Table > New Worksheet.

You can then follow along as I go through the instructions in each tutorial.

By re-creating the Pivot Table from the beginning, this is the best way to learn and enhance your Excel knowledge!

Thank You,

JOHN MICHALOUDIS

YOUR PIVOT TABLE INSTRUCTOR
ARRANGING YOUR DATA SET ~ Tabular Format2:17
Customize your Excel Pivot Table - Tabular Format
ARRANGING YOUR DATA SET ~ No Gaps2:23
Customize your Excel Pivot Table - No Gaps
ARRANGING YOUR DATA SET ~ Formatting1:20
Customize your Excel Pivot Table - Formatting
ARRANGING YOUR DATA SET ~ Tables2:38
Customize your Excel Pivot Table - Excel Tables
ARRANGING YOUR DATA SET ~ TIP: Clean Your Data Set2:11
Customize your Excel Pivot Table - Clean Your Data Set
CREATING A PIVOT TABLE ~ Inserting a Pivot Table3:14
Customize your Excel Pivot Table - Insert a Pivot Table
CREATING A PIVOT TABLE ~ Field List - Activate, move, resize & layout1:33
Customize your Excel Pivot Table - Field List, Activate, Move
CREATING A PIVOT TABLE ~ Field List & Areas5:18
Customize your Excel Pivot Table - Field List & Areas
CREATING A PIVOT TABLE ~ Drill down to audit1:35
Customize your Excel Pivot Table - Drill down to audit
CREATING A PIVOT TABLE ~ Sort Field List from A to Z0:37
Customize your Excel Pivot Table - Sort Field List
CREATING A PIVOT TABLE ~ TIP: Double click on any labels to show more Fields0:46
Customize your Excel Pivot Table - Double click on a label
CREATING A PIVOT TABLE ~ TIP: Defer Layout Update0:48
Customize your Excel Pivot Table - Defer layout update
OPTIONS > DATA ~ Pivot Cache explained0:53
Customize your Excel Pivot Table - Pivot Cache
OPTIONS > DATA ~ Refresh1:12
Customize your Excel Pivot Table - Refresh
OPTIONS > DATA ~ Refresh All2:20
Customize your Excel Pivot Table - Refresh All
OPTIONS > DATA ~ Refresh External Data4:51
Customize your Excel Pivot Table - Refresh External Data
OPTIONS > DATA ~ Import from Access database2:19
Customize your Excel Pivot Table - Import from Access
OPTIONS > DATA ~ Change Data Source3:03
Customize your Microsoft Excel Pivot Table - Change Data Source
OPTIONS > ACTIONS ~ Clear Filters & Clear Pivot1:10
Customize your Microsoft Excel Pivot Table - Clear Filters & Pivot
OPTIONS > ACTIONS ~ Select & format3:08
Customize your Microsoft Excel Pivot Table - Select & Format
OPTIONS > ACTIONS ~ Move a Pivot Table0:53
Customize your Microsoft Excel Pivot Table - Move a Pivot Table
DESIGN > STYLES ~ Pivot Table Styles3:35
Customize your Microsoft Excel Pivot Table - Pivot Table Styles
DESIGN > STYLES ~ Customising a Pivot Table Style4:05
Customize your Microsoft Excel Pivot Table - Customizing a Pivot Table
DESIGN > STYLES ~ Use a customised style in another workbook1:20
Customize your Microsoft Excel Pivot Table - Customized Pivot Table Styles
DESIGN > LAYOUT ~ Subtotals0:48
Customize your Microsoft Excel Pivot Table - Subtotals
DESIGN > LAYOUT ~ Grand Totals0:54
Customize your Microsoft Excel Pivot Table - Grand Totals
DESIGN > LAYOUT ~ Report Layouts2:41
Customize your Microsoft Excel Pivot Table - Report Layouts
DESIGN > LAYOUT ~ Blank Rows0:32
Customize your Microsoft Excel Pivot Table - Blank Rows
DESIGN > LAYOUT ~ TIP: Show the Classic Pivot Table Layout1:00
Customize your Microsoft Excel Pivot Table - Classic Pivot Table Layout
OPTIONS > SHOW ~ Expand & Collapse buttons4:19
Customize your Microsoft Excel Pivot Table - Expand & Collapse buttons
OPTIONS > SHOW ~ Move & Remove Fields and Items2:32
Customize your Microsoft Excel Pivot Table - Move & Remove Field Items
OPTIONS > SHOW ~ Show/Hide Field List0:20
Customize your Microsoft Excel Pivot Table - Show & Hide Field List
OPTIONS > SHOW ~ Show/Hide Field Headers0:19
Customize your Microsoft Excel Pivot Table - Show & Hide Field Headers
CUSTOMISATION ~ Change "Count of" to "Sum of"1:01
Customize your Microsoft Excel Pivot Table - Change from Count to Sum
CUSTOMISATION ~ Number formatting1:34
Customize your Microsoft Excel Pivot Table - Number Formatting
CUSTOMISATION ~ Field name formatting2:09
Customize your Microsoft Excel Pivot Table - Field Name formatting
CUSTOMISATION ~ TIP: Predetermined number formatting1:21
Customize your Microsoft Excel Pivot Table - Predetermined number formatting
CUSTOMISATION ~ TIP: Change Sum views in Label areas0:44
Customize your Microsoft Excel Pivot Table - Change Sum values
LAYOUT & FORMAT ~ Indent rows in compact layout0:52
Customize your Microsoft Excel Pivot Table - Indent Rows
LAYOUT & FORMAT ~ Change the layout of a report filter1:18
Customize your Microsoft Excel Pivot Table - Change Report Filter layout
LAYOUT & FORMAT ~ Format error values0:42
Customize your Microsoft Excel Pivot Table - Format error values
LAYOUT & FORMAT ~ Format empty cells1:20
Customize your Microsoft Excel Pivot Table - Format empty cells
LAYOUT & FORMAT ~ Keep column widths upon refresh0:46
Customize your Microsoft Excel Pivot Table - Fix column widths
LAYOUT & FORMAT ~ TIP: Automatic Refresh a Pivot Table0:48
Customize your Microsoft Excel Pivot Table - Automatic Pivot Table Refresh
LAYOUT & FORMAT ~ TIP: Printing a pivot table on two pages1:13
Customize your Microsoft Excel Pivot Table - Print a Pivot Table
LAYOUT & FORMAT ~ TIP:Show report filter on multiple pages2:15
Customize your Microsoft Excel Pivot Table - Show Report Filter items on multiple sheets
CUSTOMIZE YOUR PIVOT TABLE
Course Review0:47
I really hope you found this course valuable, but either way, please leave a review and share your experience.

Tell me what you think! Write a review when you can. I’m also available for questions - send me a direct message anytime.

Cheers,

JOHN MICHALOUDIS
HOMEWORK: SET UP A PIVOT TABLE0:14

WORKBOOKS0:02
Dear Student,

Each tutorial comes with an Excel workbook which you can download at the start of each chapter and keep on your desktop to practice forever!

These workbooks are in a finished form with the Pivot Table already created for you, as I show you during the video.

It is recommended that you follow along by creating a new Pivot Table simply by clicking in the data within the Data_Table sheet of each workbook and going to Insert > Pivot Table > New Worksheet.

You can then follow along as I go through the instructions in each tutorial.

By re-creating the Pivot Table from the beginning, this is the best way to learn and enhance your Excel knowledge!

Thank You,

JOHN MICHALOUDIS

YOUR PIVOT TABLE INSTRUCTOR
Create multiple subtotals1:36
Summarize your Microsoft Excel Pivot Table - Multiple Subtotals
Count2:19
Summarize your Microsoft Excel Pivot Table - Count
Average2:36
Summarize your Microsoft Excel Pivot Table - Average
Maximum1:55
Summarize your Microsoft Excel Pivot Table - Maximum
Minimum1:19
Summarize your Microsoft Excel Pivot Table - Minimum
Product3:31
Summarize your Microsoft Excel Pivot Table - Product
Count Numbers2:26
Summarize your Microsoft Excel Pivot Table - Count Numbers
Std Dev6:59
Summarize your Microsoft Excel Pivot Table - Standard Deviation
Varp3:28
Summarize your Microsoft Excel Pivot Table - Variance Population
PRO PIVOT TABLE TIP: Show various Grand Totals2:28
Summarize your Microsoft Excel Pivot Table - Show various Grand Totals
PRO PIVOT TABLE TIP: Shortcuts to Field & Value Field Settings2:12
Summarize your Microsoft Excel Pivot Table - Shortcuts
PRO PIVOT TABLE TIP: See all pivot Items5:52
Summarize your Microsoft Excel Pivot Table - See all Pivot Table items
PRO PIVOT TABLE TIP: Show a unique count2:29
Summarize your Microsoft Excel Pivot Table - Show a unique count
VALUE FIELD SETTINGS > SUMMARIZE VALUES BY
HOMEWORK: SUMMARIZE VALUES BY0:14

WORKBOOKS0:02
Dear Student,

Each tutorial comes with an Excel workbook which you can download at the start of each chapter and keep on your desktop to practice forever!

These workbooks are in a finished form with the Pivot Table already created for you, as I show you during the video.

It is recommended that you follow along by creating a new Pivot Table simply by clicking in the data within the Data_Table sheet of each workbook and going to Insert > Pivot Table > New Worksheet.

You can then follow along as I go through the instructions in each tutorial.

By re-creating the Pivot Table from the beginning, this is the best way to learn and enhance your Excel knowledge!

Thank You,

JOHN MICHALOUDIS

YOUR PIVOT TABLE INSTRUCTOR
% of Grand Total2:01
Summarize your Microsoft Excel Pivot Table - % of Grand Total
% of Column Total2:08
% of Column Total
% of Row Total1:47
Summarize your Microsoft Excel Pivot Table - % of Row Total
% Of3:56
Summarize your Microsoft Excel Pivot Table - % Of
% of Parent Row Total (NEW IN EXCEL 2010)3:12
Summarize your Microsoft Excel Pivot Table - % of Parent Row Total (New in Excel 2013, Excel 2013 & Excel 2016)
% of Parent Column Total (NEW IN EXCEL 2010)2:16
Summarize your Microsoft Excel Pivot Table - % of Parent Column Total (New in Excel 2013, Excel 2013 & Excel 2016)
% of Parent Total (NEW IN EXCEL 2010)2:44
Summarize your Microsoft Excel Pivot Table - % of Parent Total (New in Excel 2010, Excel 2013 & Excel 2016)
Difference From4:47
Summarize your Microsoft Excel Pivot Table - Difference From
% Difference From4:11
Summarize your Microsoft Excel Pivot Table - % Difference From
Running Total in2:13
Summarize your Microsoft Excel Pivot Table - Running Total In
% Running Total in (NEW IN EXCEL 2010)2:51
Summarize your Microsoft Excel Pivot Table - % Running Total In (New in Excel 2010, Excel 2013 & Excel 2016)
Rank Smallest to Largest (NEW IN EXCEL 2010)2:14
Summarize your Microsoft Excel Pivot Table - Rank Smallest to Largest (New in Excel 2010, Excel 2013 & Excel 2016)
Rank Largest to Smallest (NEW IN EXCEL 2010)2:14
Summarize your Microsoft Excel Pivot Table - Rank Largest to Smallest (New in Excel 2010, Excel 2013 & Excel 2016)
Index3:38
Summarize your Microsoft Excel Pivot Table - Index
PRO PIVOT TABLE TIP: Shortcuts to Show Values As1:08
Summarize your Microsoft Excel Pivot Table - Shortcuts
CASE STUDY ~ ACCOUNTING: % of Revenue Margins2:31
Summarize your Microsoft Excel Pivot Table - % of Revenue Margins
CASE STUDY ~ FINANCIAL: Actual v Plan Variance Report4:43
Summarize your Microsoft Excel Pivot Table - Actual v Plan variance report
VALUE FIELD SETTINGS > SHOW VALUES AS
HOMEWORK: SHOW VALUES AS0:14

WORKBOOKS0:02
Dear Student,

Each tutorial comes with an Excel workbook which you can download at the start of each chapter and keep on your desktop to practice forever!

These workbooks are in a finished form with the Pivot Table already created for you, as I show you during the video.

It is recommended that you follow along by creating a new Pivot Table simply by clicking in the data within the Data_Table sheet of each workbook and going to Insert > Pivot Table > New Worksheet.

You can then follow along as I go through the instructions in each tutorial.

By re-creating the Pivot Table from the beginning, this is the best way to learn and enhance your Excel knowledge!

Thank You,

JOHN MICHALOUDIS

YOUR PIVOT TABLE INSTRUCTOR
Group by Date2:37
Group your Microsoft Excel Pivot Table - by Date
Group by Months1:43
Group your Microsoft Excel Pivot Table - by Months
Group by Quarters & Years1:41
Group your Microsoft Excel Pivot Table - by Quarters & Years
Group by Sales ranges3:11
Group your Microsoft Excel Pivot Table - by Sales ranges
Group by Text fields2:09
Group your Microsoft Excel Pivot Table - by Text fields
Group by Time1:38
Group your Microsoft Excel Pivot Table - by Time
PRO PIVOT TABLE TIP: Shortcuts to Grouping1:32
Group your Microsoft Excel Pivot Table - Shortcuts
PRO PIVOT TABLE TIP: Grouping by Half Years1:48
Group your Microsoft Excel Pivot Table - by Half Years
PRO PIVOT TABLE TIP: Group by a Date that starts on a Monday1:53
Group your Microsoft Excel Pivot Table - Dates that start on a Monday
PRO PIVOT TABLE TIP: Grouping by a custom date1:41
Group your Microsoft Excel Pivot Table - by Custom Dates
PRO PIVOT TABLE TIP: Group by fiscal years & quarters6:29
Group your Microsoft Excel Pivot Table - by Fiscal years & Quarters
PRO PIVOT TABLE TIP: Errors when grouping by dates2:46
Group your Microsoft Excel Pivot Table - Errors
PRO PIVOT TABLE TIP: Group two pivot tables independently3:52
Group your Microsoft Excel Pivot Table - by 2 Pivot Tables
PRO PIVOT TABLE TIP: Fixing the problem of counting grouped sales0:38
Group your Microsoft Excel Pivot Table - Fixing problems
PRO PIVOT TABLE TIP: Display dates that have no data0:52
Group your Microsoft Excel Pivot Table - Display Dates
CASE STUDY ~ ACCOUNTING: Quarterly Comparative Report6:37
Group your Microsoft Excel Pivot Table - Quarterly Comparative Report
CASE STUDY ~ FINANCIAL: Min & Max Bank Balance4:35
Group your Microsoft Excel Pivot Table - Minimum & Maximum Bank Balance
GROUPING
HOMEWORK: GROUPING0:14

WORKBOOKS0:02
Dear Student,

Each tutorial comes with an Excel workbook which you can download at the start of each chapter and keep on your desktop to practice forever!

These workbooks are in a finished form with the Pivot Table already created for you, as I show you during the video.

It is recommended that you follow along by creating a new Pivot Table simply by clicking in the data within the Data_Table sheet of each workbook and going to Insert > Pivot Table > New Worksheet.

You can then follow along as I go through the instructions in each tutorial.

By re-creating the Pivot Table from the beginning, this is the best way to learn and enhance your Excel knowledge!

Thank You,

JOHN MICHALOUDIS

YOUR PIVOT TABLE INSTRUCTOR
Sorting by Largest or Smallest1:51
Sort your Microsoft Excel Pivot Table - Largest to Smallest
Sort an Item Row (Left to Right)1:24
Sort your Microsoft Excel Pivot Table - Left to Right
Sort manually (drag, write, right click)2:01
Sort your Microsoft Excel Pivot Table - Manually
Sort using a Custom List3:13
Sort your Microsoft Excel Pivot Table - Custom List
Override a Custom List sort1:20
Sort your Microsoft Excel Pivot Table - Override a Custom List
Sort row from A-Z and sales from Z-A1:16
Sort your Microsoft Excel Pivot Table - From A-Z
PRO PIVOT TABLE TIP: Sort new items added to your data source1:11
Sort your Microsoft Excel Pivot Table - New items
PRO PIVOT TABLE TIP: Clear a sort0:21
Sort your Microsoft Excel Pivot Table - Clear a Sort
PRO PIVOT TABLE TIP: Sort Largest to Smallest Grand Totals0:19
Sort your Microsoft Excel Pivot Table - Largest to Smallest Grand Totals
SORTING
HOMEWORK: SORTING0:14

WORKBOOKS0:02
Dear Student,

Each tutorial comes with an Excel workbook which you can download at the start of each chapter and keep on your desktop to practice forever!

These workbooks are in a finished form with the Pivot Table already created for you, as I show you during the video.

It is recommended that you follow along by creating a new Pivot Table simply by clicking in the data within the Data_Table sheet of each workbook and going to Insert > Pivot Table > New Worksheet.

You can then follow along as I go through the instructions in each tutorial.

By re-creating the Pivot Table from the beginning, this is the best way to learn and enhance your Excel knowledge!

Thank You,

JOHN MICHALOUDIS

YOUR PIVOT TABLE INSTRUCTOR
Filter by Dates6:41
Filter your Microsoft Excel Pivot Table - Dates
Filter by Labels - Text2:35
Filter your Microsoft Excel Pivot Table - Text
Filter by Labels - Numerical Text2:44
Filter your Microsoft Excel Pivot Table - Numeric Text
Filter by Values3:50
Filter your Microsoft Excel Pivot Table - Values
Filter by Values - Top or Bottom 10 Items2:06
Filter your Microsoft Excel Pivot Table - Top or Bottom X Items
Filter by Values - Top or Bottom %1:39
Filter your Microsoft Excel Pivot Table - Top or Bottom %
Filter by Values - Top or Bottom Sum1:42
Filter your Microsoft Excel Pivot Table - Top or Bottom Sum
Filter by Report Filter3:31
Filter your Microsoft Excel Pivot Table - Report Filter
PRO PIVOT TABLE TIP: Shortcuts to filters1:36
Filter your Microsoft Excel Pivot Table - Shortcuts
PRO PIVOT TABLE TIP: Keep or hide selected items0:57
Filter your Microsoft Excel Pivot Table - Keep or Hide selected items
PRO PIVOT TABLE TIP: Filter by Text wildcards * and ?3:19
Filter your Microsoft Excel Pivot Table - Wildcards
PRO PIVOT TABLE TIP: Filter by multiple fields1:00
Filter your Microsoft Excel Pivot Table - Multiple Fields
PRO PIVOT TABLE TIP: Apply multiple filters1:45
Filter your Microsoft Excel Pivot Table - Apply multiple filters
PRO PIVOT TABLE TIP: Filter by multiple values1:06
Filter your Microsoft Excel Pivot Table - Multiple values
PRO PIVOT TABLE TIP: Include new items in manual filter1:50
Filter your Microsoft Excel Pivot Table - Include new Items
PRO PIVOT TABLE TIP: Clear filters with one click1:30
Filter your Microsoft Excel Pivot Table - Clear Filters
PRO PIVOT TABLE TIP: Add a filter for the column items0:33
Filter your Microsoft Excel Pivot Table - Add a filter in the Column Items
CASE STUDY ~ ACCOUNTING: Top 5 Expenses report2:22
Filter your Microsoft Excel Pivot Table - Top 5 Expense Report
CASE STUDY ~ FINANCIAL: Top 25% of Channel Partners2:11
Filter your Microsoft Excel Pivot Table - Top 25% of Channel Partners
FILTERING
HOMEWORK: FILTERING0:14

WORKBOOKS0:02
Dear Student,

Each tutorial comes with an Excel workbook which you can download at the start of each chapter and keep on your desktop to practice forever!

These workbooks are in a finished form with the Pivot Table already created for you, as I show you during the video.

It is recommended that you follow along by creating a new Pivot Table simply by clicking in the data within the Data_Table sheet of each workbook and going to Insert > Pivot Table > New Worksheet.

You can then follow along as I go through the instructions in each tutorial.

By re-creating the Pivot Table from the beginning, this is the best way to learn and enhance your Excel knowledge!

Thank You,

JOHN MICHALOUDIS

YOUR PIVOT TABLE INSTRUCTOR
Insert a Slicer3:54
Slicer your Microsoft Excel Pivot Table - Insert a Slicer
Slicer Styles2:18
Slicer your Microsoft Excel Pivot Table - Styles
Creating a custom style5:30
Slicer your Microsoft Excel Pivot Table - Custom Styles
Copy a custom style into a new workbook1:33
Slicer your Microsoft Excel Pivot Table - Custom Styles in new workbooks
Slicer Settings4:42
Slicer your Microsoft Excel Pivot Table - Settings
Slicer Size & Properties2:56
Slicer your Microsoft Excel Pivot Table - Size & Properties
Slicer Connections for multiple pivot tables3:16
Slicer your Microsoft Excel Pivot Table - Slicer Connections for multiple Pivot Tables
PRO PIVOT TABLE TIP: Different ways to filter a Slicer1:22
Slicer your Microsoft Excel Pivot Table - Different ways to Filter a Slicer
PRO PIVOT TABLE TIP: Use one slicer for two pivot tables1:19
Slicer your Microsoft Excel Pivot Table - Use one Slicer for 2 Pivot Tables
PRO PIVOT TABLE TIP: Lock the workbook but not the slicer1:25
Slicer your Microsoft Excel Pivot Table - Lock the workbook but not the Slicer
PRO PIVOT TABLE TIP: Interactive employee photos with Slicers! FUN!9:20
Slicer your Microsoft Excel Pivot Table - Interactive employee photos
CASE STUDY ~ ACCOUNTING: Select a Monthly P&L report with a Slicer4:13
Slicer your Microsoft Excel Pivot Table - Select a Monthly Profit & Loss Report
CASE STUDY ~ FINANCIAL: Base, Best & Worst case Forecast5:02
Slicer your Microsoft Excel Pivot Table - Base, Best & Worst case forecasts
SLICERS
Course Review0:47
I really hope you found this course valuable, but either way, please leave a review and share your experience.

Tell me what you think! Write a review when you can. I’m also available for questions - send me a direct message anytime.

Cheers,

JOHN MICHALOUDIS
HOMEWORK: SLICERS0:14

WORKBOOKS0:02
Dear Student,

Each tutorial comes with an Excel workbook which you can download at the start of each chapter and keep on your desktop to practice forever!

These workbooks are in a finished form with the Pivot Table already created for you, as I show you during the video.

It is recommended that you follow along by creating a new Pivot Table simply by clicking in the data within the Data_Table sheet of each workbook and going to Insert > Pivot Table > New Worksheet.

You can then follow along as I go through the instructions in each tutorial.

By re-creating the Pivot Table from the beginning, this is the best way to learn and enhance your Excel knowledge!

Thank You,

JOHN MICHALOUDIS

YOUR PIVOT TABLE INSTRUCTOR
Creating a Calculated Field3:58
Insert a Calculated Field in your Microsoft Excel Pivot Table - Create a Calculated Field
Use an existing Calculated Field in a new calculation2:16
Insert a Calculated Field in your Microsoft Excel Pivot Table - New Calculations
Editing a Calculated Field1:56
Insert a Calculated Field in your Microsoft Excel Pivot Table - Editing
Excel formulas & Calculated Fields3:07
Insert a Calculated Field in your Microsoft Excel Pivot Table - Excel Formulas allowed
Creating a Calculated Item4:05
Insert a Calculated Item in your Microsoft Excel Pivot Table - Creating
Use an existing Calculated Item in a new calculation1:36
Insert a Calculated Item in your Microsoft Excel Pivot Table - New calculation
Editing a Calculated Item2:18
Insert a Calculated Item in your Microsoft Excel Pivot Table - Editing
Excel formulas & Calculated Items1:50
Insert a Calculated Item in your Microsoft Excel Pivot Table - Excel Formulas
Calculated Item on Column Labels2:07
Insert a Calculated Item in your Microsoft Excel Pivot Table - Column Labels
Shortcomings of Calculated Items2:04
Insert a Calculated Item in your Microsoft Excel Pivot Table - Shortcomings
PRO PIVOT TABLE TIP: Solve Order for Calculated Items4:04
Insert a Calculated Item in your Microsoft Excel Pivot Table - Solve Order
PRO PIVOT TABLE TIP: List Calculated Field & Item formulas1:05
Insert a Calculated Field in your Microsoft Excel Pivot Table - Lists
PRO PIVOT TABLE TIP: Remove a Calculated Field temporarily0:52
Insert a Calculated Field in your Microsoft Excel Pivot Table - Remove
PRO PIVOT TABLE TIP: Order of operations1:49
Insert a Calculated Field in your Microsoft Excel Pivot Table - Order of Operations
CASE STUDY ~ ACCOUNTING: Creating a P&L Pivot Table Report8:18
Insert a Calculated Field in your Microsoft Excel Pivot Table - Create a Profit & Loss Pivot Table report
CASE STUDY ~ FINANCIAL: Actuals v Plan with Calculated Fields6:36
Insert a Calculated Field in your Microsoft Excel Pivot Table - Actual v Plan report
CALCULATED FIELDS & ITEMS
HOMEWORK: CALCULATED FIELDS0:14

WORKBOOKS0:02
Dear Student,

Each tutorial comes with an Excel workbook which you can download at the start of each chapter and keep on your desktop to practice forever!

These workbooks are in a finished form with the Pivot Table already created for you, as I show you during the video.

It is recommended that you follow along by creating a new Pivot Table simply by clicking in the data within the Data_Table sheet of each workbook and going to Insert > Pivot Table > New Worksheet.

You can then follow along as I go through the instructions in each tutorial.

By re-creating the Pivot Table from the beginning, this is the best way to learn and enhance your Excel knowledge!

Thank You,

JOHN MICHALOUDIS

YOUR PIVOT TABLE INSTRUCTOR
Insert a Pivot Chart3:17
Insert a Pivot Chart in your Microsoft Excel Pivot Table - Insert
Insert a Slicer with a Pivot Chart1:52
Insert a Pivot Chart in your Microsoft Excel Pivot Table - Slicers & Pivot Charts
Pivot Chart Designs3:48
Insert a Pivot Chart in your Microsoft Excel Pivot Table - Designs
Pivot Chart Layouts4:57
Insert a Pivot Chart in your Microsoft Excel Pivot Table - Layouts
Pivot Chart Formats5:50
Insert a Pivot Chart in your Microsoft Excel Pivot Table - Formats
Limitations of Pivot Charts & workarounds1:54
Insert a Pivot Chart in your Microsoft Excel Pivot Table - Limitations
Saving a Pivot Chart template1:28
Insert a Pivot Chart in your Microsoft Excel Pivot Table - Saving a template
PRO PIVOT TABLE TIP: Shortcuts to formatting a Pivot Chart1:16
Insert a Pivot Chart in your Microsoft Excel Pivot Table - Shortcuts
PRO PIVOT TABLE TIP: Link chart title to a pivot cell0:58
Insert a Pivot Chart in your Microsoft Excel Pivot Table - Link Chart Title
PRO PIVOT TABLE TIP: Copying a second chart0:51
Insert a Pivot Chart in your Microsoft Excel Pivot Table - Chart copy
PRO PIVOT TABLE TIP: Put a chart on a separate page with F110:40
Insert a Pivot Chart in your Microsoft Excel Pivot Table - F11 Chart creator
PRO PIVOT TABLE TIP: Insert Pivot Chart straight from the data source0:51
Insert a Pivot Chart in your Microsoft Excel Pivot Table - Straight from your data source
PRO PIVOT TABLE TIP: Paste Pivot Chart to your email as a picture1:05
Insert a Pivot Chart in your Microsoft Excel Pivot Table - Paste as a picture
PRO PIVOT TABLE TIP: Paste Pivot Chart to PowerPoint & make live updates1:34
Insert a Pivot Chart in your Microsoft Excel Pivot Table - PowerPoint tips
PRO PIVOT TABLE TIP: Printing a Pivot Chart1:20
Insert a Pivot Chart in your Microsoft Excel Pivot Table - Printing
PRO PIVOT TABLE TIP: Include a Sparkline with your pivot table1:16
Insert a Pivot Chart in your Microsoft Excel Pivot Table - Include a Sparkline
PRO PIVOT TABLE TIP: Charts Do´s & Don'ts2:37
Insert a Pivot Chart in your Microsoft Excel Pivot Table - Chart Do's & Don'ts
PRO PIVOT TABLE TIP: Change Chart Type with Slicers! FUN!!!8:00
Insert a Pivot Chart in your Microsoft Excel Pivot Table - Change Chart type with Slicers
PRO PIVOT TABLE TIP: Workaround to creating an interactive Scatter graph2:20
Insert a Pivot Chart in your Microsoft Excel Pivot Table - Interactive Scatter Chart
CASE STUDY ~ ACCOUNTING: P&L Pivot Table report with Graphs8:14
Insert a Pivot Chart in your Microsoft Excel Pivot Table - Profit & Loss Pivot Table with Charts
CASE STUDY ~ FINANCIAL: Pivot Table Slicer & Chart Dashboard15:47
Insert a Pivot Chart in your Microsoft Excel Pivot Table - Slicer & Chart Excel Sales Dashboard
PIVOT CHARTS
Create a Pivot Table Dashboard

Requirements

Excel for Windows 2007, 2010, 2013, 2016, 2019, Office 365 and Excel for Mac 2011 and 2016
This course is for Excel Beginners, Intermediates or Advanced Users
No prior Microsoft Excel knowledge is required

Description

You’re Just Seconds Away From Leveraging Microsoft Excel, Pivot Tables, Power Pivot, Power Query & Microsoft Power BI That Will Make It Possible For YOU To:

Increase your Microsoft Excel & Pivot Table SKILLS and KNOWLEDGE within HOURS which will GET YOU NOTICED by Top Management & prospective Employers!
Become more PRODUCTIVE at using Excel which will SAVE YOU HOURS each Day & ELIMINATE STRESS at work!
Use Excel Pivot Tables with CONFIDENCE that will lead to greater opportunities like a HIGHER SALARY and PROMOTIONS!

----------------------------------------

Listen to a few of our satisfied students who have taken this TOP-RATED Microsoft Excel course and advanced their Excel skills in days:

"This course is tremendously comprehensive. The best part is that the course is served in small bite-sized pieces that are easily digested. A teaching course that doubles as a reference guide. Definitely worth your time and money" - James

"I was a Pivot Table novice when I started this course but with just a few lessons I was becoming more and more confident at using Pivot Tables. John's teaching style is engaging, his voice is clear and the videos are first class and very in-depth, as he covers ALL the Pivot Table features.

There are plenty of exercise files and real life homework activities to practice the skills learned. I can now say with confidence that I am an advanced Excel & Pivot Table user to my colleagues, boss and future employers.

Thanks John for this comprehensive course and I am forever indebted to you. Keep up the awesome work you do." - Sebastian

----------------------------------------

***** ADDED BONUS: This entire courses can be DOWNLOADED for offline viewing on the Udemy mobile app (Android & iOS)! *****

***** GET 5 MICROSOFT EXCEL COURSES FOR THE PRICE OF 1 *****

> UPDATED APRIL 2020: New Excel Pivot Tables Features For Excel 2019 & Office 365.

> BONUS EXCEL COURSE: 333 Excel Keyboard Shortcuts with Free PDF Cheat Sheet for Windows & Mac

> 7 COURSE BONUSES: Excel PDF Cheat Sheets, 101 Ready Made Excel Templates, plus MORE!!!
----------------------------------------

YOU GET THE FOLLOWING 5 COURSES WITH THIS EXCEL BUNDLE:

----------------------------------------

COURSE #1 - EXCEL PIVOT TABLES

----------------------------------------

If you want to get better at Excel and stand out from the crowd to get the promotions or pay-rises that you deserve, then you are in the right place!

This is the most comprehensive Excel Pivot Table online course ever made which has over 250 short and precise tutorials.

No matter if you are a Beginner or an Advanced user of Excel, you are sure to benefit from this course which goes through every single tool that is available in an Excel Pivot Table. The course is designed for Excel 2007, 2010, 2013, 2016, 2019 and Office 365.

In no time you will be able to analyze lots of data and tell a story in a quick and interactive way, learn how to build stunning Dashboards and get noticed by top management & prospective employers. The course is just over 10 hours long so you can become an awesome analyst and advanced Excel user within 1 week!

There are 17 different chapters so you can work on your weaknesses and enhance your strengths. Each chapter was designed to improve your Excel skills with extra time saving Tips and real life business Case Studies.

Here are the main topics that we will cover in this course:

EXCEL PIVOT TABLES COURSE:

CUSTOMIZE YOUR PIVOT TABLE
VALUE FIELD SETTINGS > SUMMARIZE VALUES BY
VALUE FIELD SETTINGS > SHOW VALUES AS
GROUPING
SORTING
FILTERING
SLICERS
CALCULATED FIELDS & ITEMS
PIVOT CHARTS
CONDITIONAL FORMATTING
GETPIVOTDATA Formula
MACROS
DATA MANAGEMENT
BONUS VIDEOS
NEW EXCEL 2013 PIVOT TABLE FEATURES
NEW EXCEL 2016 PIVOT TABLE FEATURES
NEW EXCEL 2019 & OFFICE 365 PIVOT TABLE FEATURES

----------------------------------------

COURSE #2 - EXCEL POWER PIVOT & DAX FORMULAS

----------------------------------------

Power Pivot is an Excel add-in that was first introduced in Excel 2010 by Microsoft. It allows you to harness the power of Business Intelligence right in Excel.

In a nutshell, Power Pivot allows you to use multiple data sources for analysis. So it is a Pivot Table on steroids, meaning it can handle more data and create more powerful calculations using Measures & DAX Formulas.

Power Pivot gives you the power to work with large sets of data that are OVER 1 millions rows!!!

You can import, consolidate and create relationships from your data and perform enhanced analysis. The beautiful thing with Power Pivot is it allows you to work on Big Data with NO limitations.

Imagine getting data from multiple sources like SQL Server, Oracle, XML, Excel, Microsoft Access and analyzing these all into one awesome Pivot Table!

This course will introduce you to the key concepts of getting started with Power Pivot and it's various features for enhanced calculations, so you will be confident & comfortable in using Power Pivot on your data.

Here are the main topics that we will cover in this course:

EXCEL POWER PIVOT & DAX COURSE:

IMPORT/LOAD DATA
TABLE RELATIONSHIPS
PIVOT TABLES & SLICERS
INTRO TO DAX FORMULAS
MEASURES & CALCULATED COLUMNS

----------------------------------------

COURSE #3 - EXCEL POWER QUERY

----------------------------------------

This is the Ultimate Microsoft Excel Data Cleansing course which has over 60 short and precise tutorials.

No matter if you are a Beginner or an Advanced user of Excel, you are sure to benefit from this course which goes through every single analytical & data cleansing tool that is available in Microsoft Excel.

The course is designed for Excel 2007, 2010, 2013, 2016 or 2019 and Office 365.

In no time you will be able to clean lots of data and report it in a quick and interactive way, learn how to work with various transformation Formulas, create consolidated monthly reports with the press of a button, WOW your boss with stunning Excel visuals and get noticed by top management & prospective employers!

The course is just over 4 hours long so you can become an awesome analyst and advanced Excel user within 1 day!

In the first part of the course you will learn the various "Data Cleansing" techniques using Power Query or Get & Transform - as its name changed in Excel 2019 and Office 365. We will show you how to:

EXCEL POWER QUERY - PART 1

Clean & transform lots of data quickly
Import data from various external sources, folders & Excel workbooks
Consolidate data with ease
Sort & Filter data
Merge data
Join data
Data shaping & flat files
Auto cleanup your data
M Functions

In the second part of the course you will learn "Data Cleansing" techniques using various Excel features such as:

EXCEL POWER QUERY - PART 2

Text Function
Logical and Lookup Functions
Text to Columns
Find & Remove Duplicates
Conditional Formatting
Find & Replace
Go to Special
Sort & Filter

----------------------------------------

COURSE #4 - MICROSOFT POWER BI

----------------------------------------

If you want to get better at Microsoft Power BI so you get a better paying job or just get answers & insights from your data FAST with Power BI Dashboards, then you are in the right place!

No matter if you are an Power BI Beginner or NEVER USED POWER BI before, you are sure to benefit from this quick course which goes through the MUST KNOW Power BI features.

You will be able to master Power BI straight away the following (in just 90 minutes) with the following Sections:

Introduction to Power BI
Creating a Power BI Dashboard
Advanced Power BI Dashboard with Real Live Data

----------------------------------------

COURSE #5 - 333 EXCEL KEYBOARD SHORTCUTS

----------------------------------------

This is the most comprehensive Excel Keyboard Shortcuts course ever made which has 333 short and precise video tutorials.

No matter if you are a Beginner or an Advanced user of Excel, you are sure to benefit from this course which goes through every single Excel shortcut that is available inside Microsoft Excel. The course is designed for Excel 2007, 2010, 2013, 2016, 2019 and Office 365.

If you learn only 5 Excel keyboard shortcuts and apply them each day, you will SAVE HOURS each week, which means you can go home early for once!

There are 15 different modules so you can work on your weaknesses and enhance your strengths as well as practice files, quizzes and a FREE PDF Cheat Sheet listing all 333 Excel Keyboard Shortcuts for Windows & Mac that you can print off and keep.

Here are the main keyboard shortcut topics that we will cover in this course:

333 EXCEL KEYBOARD SHORTCUTS VIDEO COURSE:

Cell Formatting
Drag & Drop
Formulas & Functions
Frequent shortcuts
Function Key
Making selections
Ribbon Tab
Cell Navigation
Inside Ribbon
Macros & VBA
Pivot Tables
Power BI
Power Pivot
Other Shortcuts

----------------------------------------

Look, if you are really serious about GETTING BETTER at excel and ADVANCING your Microsoft Excel level & skills...

…saving HOURS each day, DAYS each week and WEEKS each year and eliminating STRESS at work...

...If you want to improve your PROFESSIONAL DEVELOPMENT to achieve greater opportunities like PROMOTIONS, a HIGHER salary and KNOWLEDGE that you can take to another job…

...All whilst impressing your boss and STANDING OUT from your colleagues and peers...

...THEN THIS COURSE IS FOR YOU!

Now you have the opportunity to join your fellow professionals who are taking this course and enhancing their Microsoft Excel skills!

To enroll, click the ENROLL NOW button (risk-free for 30 days or your money back), because every hour you delay only delays your personal and professional progress...

----------------------------------------

>> Get LIFETIME Course access including over 250+ downloadable Excel workbooks, Quizzes, Assignments, 1-on-1 instructor SUPPORT and a 100% money-back guarantee! ***

>> Watch our PROMO VIDEO above and a few of our FREE VIDEO TUTORIALS to see for yourself just how beneficial this course is and how you too can become better at Excel ***

Who this course is for:

People who are in: Accounting, Finance, Management, Auditing, Admin & Support, Sales, IT, Consulting, Banking, Marketing, Business Owners, Engineering, Project Management, Students, Teachers plus MORE!
People who want to change career and apply for a new job
If you want to leverage Excel to stand out from the crowd, save hours each day, eliminate stress & get a promotion or pay-rise, then you are invited to join this course!

Pivot Tables, Power Pivot Tables, Power Query & Power BI

What you'll learn

Explore related topics

Course content

COURSE INTRODUCTION8 lectures • 8min

PIVOT TABLES: DESIGN & CUSTOMIZE YOUR PIVOT TABLE49 lectures • 1hr 24min

PIVOT TABLES: VALUE FIELD SETTINGS > SUMMARIZE VALUES BY15 lectures • 39min

PIVOT TABLES: VALUE FIELD SETTINGS > SHOW VALUES AS19 lectures • 49min

PIVOT TABLES: GROUPING19 lectures • 46min

PIVOT TABLES: SORTING11 lectures • 13min

PIVOT TABLES: FILTERING21 lectures • 43min

PIVOT TABLES: SLICERS (NEW FROM EXCEL 2010)16 lectures • 48min

PIVOT TABLES: CALCULATED FIELDS & ITEMS18 lectures • 48min

PIVOT TABLES: PIVOT CHARTS22 lectures • 1hr 10min

Requirements

Description

Who this course is for: