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.
👉 Download the 230 Excel Workbooks: https://www.myexcelonline.com/107-90.html
👉 Get 30+ Excel & Office Courses & support for ONLY $1💵: https://www.myexcelonline.com/107-186.html
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
https://www.myexcelonline.com/
#MsExcel #PivotTables