Master Excel Pivot Tables, Excel Slicers and Interactive Excel Dashboards - FULL COURSE!

This Free Microsoft Excel online course shows you how to use Excel & Pivot Tables in Microsoft Excel 2010, 2013, 2016, 2019 and Office 365! A must watch free Microsoft Excel training for any level.

0:00:00 - SET UP & CUSTOMIZE YOUR PIVOT TABLE
Tabular Format
No Gaps in your data
Formatting
Excel Tables
Clean Your Data Set
Inserting
Field List
Areas
Drill down
Sort Field List
Show more
Defer Layout Update
Pivot Cache
Refresh
Refresh All
Refresh External Data
Import from Access
Change Data Source
Clear Filters & Pivot
Select & format
Move
0:50:58 Styles
Customise a Style
Use a custom style
Subtotals
Grand Totals
Report Layouts
Blank Rows
Classic Pivot Table
Expand & Collapse buttons
Move & Remove Fields
Show/Hide Field List
Show/Hide Field Headers
Change Count to Sum
Number format
Field name format
Predetermined number format
Sum views
Indent rows
Change the layout
Format errors
Format empty cells
Keep column widths upon refresh
Automatic Refresh a Pivot Table
Printing
Show report filter

1:30:34 - SUMMARIZE VALUES BY
Subtotals
Count
Average
Maximum
Minimum
Product
1:44:06 Count Numbers
Std Dev
Varp
Grand Totals
Shortcuts
See all Items
Show a distinct count

2:10:12 - SHOW VALUES AS
% of Grand Total
% of Column Total
% of Row Total
% Of
% of Parent Row Total
% of Parent Column Total
% of Parent Total
2:28:38 Difference From
% Difference From
Running Total in
% Running Total in
Rank Smallest to Largest
Rank Largest to Smallest
Index
Shortcuts
% of Revenue
Actual v Plan Variances

2:59:19 - GROUP BY
Date
Months
Quarters & Years
Sales ranges
Text fields
Time
Shortcuts
Half Years
Date that starts on a Monday
Custom date
3:19:39 Fiscal Years & Quarters
Errors
Group 2 pivot tables
Fixing the issue of count
Display dates that have no data
Quarterly Comparative Report
Min & Max Bank Balance

3:45:41 - SORT BY:
Largest/Smallest
Item Row
Manually
Custom List
Override a Custom List
From A-Z
New items
Clear Sort
Largest/Smallest Grand Totals

3:58:50 - FILTER BY
Dates
Labels - Text
Labels - Numerical Text
Values
Top 10 Items
Top %
Top Sum
Report Filter
Shortcuts
Keep or hide items
4:26:28 Text wildcards * and ?
Multiple fields
Multiple filters
Multiple values
Include new items
Clear filters
Add a filter
Top 5 Expenses report
Top 25% of Channel Partners

4:42:28 - SLICERS
Insert
Styles
Custom style
Copy into a new workbook
Settings
Size & Properties
5:03:37 Connect Slicers to multiple Pivot Tables
Filter
1 slicer for 2 pivot tables
Lock the workbook but not the slicer
Interactive employee photos
Select a Monthly P&L Report
Base, Best & Worst case Forecast

5:29:46 - CALCULATED FIELDS & ITEMS
Calculated Field
Use an existing Field in a new calc
Editing a Field
Excel formulas & Fields
Calculated Item
Use an existing Item in a new calc
Editing an Item
Excel formulas & Items
Column Labels
Shortcomings
5:55:14 Solve Order
List formulas
Remove temporarily
Order of operations
P&L Pivot Table Report
Actual v Plan Report

6:18:04 - PIVOT CHARTS
Insert
Slicers
Designs
Layouts
Formats
Limitations
Saving a template
Shortcuts
Link chart title
Copying
Chart on a separate page
Insert from data source
6:46:08 Paste to your email
Paste to PowerPoint
Printing
Sparkline
Charts Do´s & Don'ts
Change Chart Type
Interactive Scatter chart
P&L Pivot Table Report
7:12:47 Pivot Table Slicer Dashboard

7:28:37 - CONDITIONAL FORMATTING
Intro
Values
Text labels
Date labels
Top & Bottom
Data Bar, Color Scale, Icon Set
Cells that contain
7:45:35 Top or Bottom values
Above/below average
Use a formula
Use selected cells
Format multiple fields
Control with Slicers
Show text in a Pivot Table
Blank cells
Accounts Receivable Report
Cond Format your Sales results

8:12:51 - GETPIVOTDATA
Intro
Custom report
Reference Dates
Data validation
Shortfalls
Grand Totals
Live Forecasting
Channel Analysis

8:46:44 - MACROS
Developer
Refresh a Pivot Table
Date Filter
Different views
Top 10
Add macro to QAT

9:07:12 - REDUCE FILE MEMORY BY:
Copying
Deleting
Binary Workbook
Source in MS Access
Compatibility Issues
OneDrive

9:17:14 - BONUS VIDEOS
Sales Forecasting
Consolidate data
Frequency distribution
Break Even Model
Several slicer custom styles
9:33:16 Interactive Dashboard for Balance Sheets
Monthly Sales Manager Report
Reconciling customer payments
Pivot Power Add-in

9:58:47 - NEW EXCEL 2013 FEATURES
Cosmetic changes
Recommended Pivot Tables
Distinct Count
Timeline Slicers
Data Models

10:16:10 - NEW EXCEL 2016 FEATURES
Group Periods
Multi-Select Slicer items
Expand and Collapse fields
3D Maps

10:21:38 - NEW EXCEL 2019 & OFFICE 365 FEATURES
Which is your Excel version?
Default Pivot Table Layout
Automatic Relationship detection
Automatic Time Grouping

Cheers,

JOHN MICHALOUDIS
#MsExcel #PivotTables

[TheConanwarrior]

I was relunctant to start due to the videos lengh, but I'm glad I did. What a course! After completing the course I can say this is the most comprehensive Pivot table course out there. Thank you so much

[hanisaeed]

Dear Sir, i can't express my thanks for your generosity and kindness for sharing this huge efforts. Hope you all the best and success.

[kamranahmad]

I can't imagine how much hard-work you have done for making this video even some professionals don't give a single "penny" from their skill for free and you gave even workbooks for practice. Respect man!!! Respect!!!....Thanks a lot:)))
#pivotchamp

[bluesage]

AMAZING COURSE!!! The topic coverage is so impressive, it is like an encyclopedia. It's already enough to make it super valuable. But no, you've also have an explanation style, which is clearly structured and simple and calm. No excitement, no special effects, no entertainment. Just no nonsense explanation. Loved it!!! Thank you so much. I will come back here again and again

[harrisakuffoamon]

Oh my goodness, this is one of the best tutorials I have ever watched. Thank you 😊

[szaybhattacharya]

you have done an unrepayable job to humanity.GOD BLESS YOU.

[mayowafakolujo]

This is amazing. Thanks for being a blessing to the world. God increase and expand your territory.

[sargonkheedo]

Without any doubt one of the BEST training to learn Pivot.... just GREAT!!!

[NagendraMurari]

Thank you so much for this wonderful tutorial. I was just a beginner and new to my role and your video has been a huge help for me. I was able to generate reports for individuals and present it in to them and drive them.

[funniesbyhs]

What an course, i was searching for Pivot many channels, but didn't find any full course, after seeing an 10+ hrs course, i think i have to watched this, and after watching, i am 100% fully Satisfied as each and every corner of the topic is Cleared. I support your Hard Work, and i Share you this video as much as possible..Thanx Sir a lot.. LOVE FROM INDIA.🙏🙏🙏🙏🙏i

[n.arunkumar]

The thought to teach others is great; You have done it for free of cost. We appreciate and thank for your efforts and kindness.

[katiejones]

I am only an hour in and I have learned a few things I didn't know. I'm giving myself a week to go through it. I start a new job on Monday and I need a refresher. Thank you SO MUCH for this amazing resource!!!

[prateekgupta]

Such a amazing course for free. I can't imagine your hardwork inside this course😇

[zahoorsarbandi]

Today I completed the PT course. Really amazing & full explanation of PT. Only a single video can make you master of PT. A very wonderful and generous job particularly sharing of Workbooks which helped a lot in understanding of lectures. Thank you very very much sir.

[sunsunny]

I am just surprised about the lenght of video. Recently i have enrolled tonthis channel. Very clear and understandable video. Just started to watch but I am satisfied already. Thank you so much

[mohdjuned]

I am from 🇮🇳 India,
This video is very useful 👌for us.
Thanks sir 🙏

[shaileshjaisawal]

what i use a appreciation word, i think no words for your hard work . Really I cant believe this is free for all . you are inspiring us to do work like you have done . thank so much for giving this wonderful tutorial. 🙏🙏🙏👍

[samibaghdan]

Actually I became addicted to your Videos and Excel .. Thank you

[arvindbilwal]

Blockbuster Tutorial Ever on Excel ....

[rewfar]

Thanks John it's of great help for newbies like me who rely on books and other stuff which take lot of our time. This would be blessing in disguise👌👌👌