arrow_back
Data Analysis with Pivot Table
Pivot Example
Practice file
Arranging Data-Tabular Format
Practice file
Arranging Data-No Gaps in the data
Practice file
Arranging data-no subtotals in the data
Practice file
Arranging data-always use excel tables
Practice file
Arranging data-formatting
Practice file
Arranging data-remove spaces
Practice file
Arranging data-count the data first
Practice file
Create pivot table
Practice file
Field list- activate field list
Practice file
Field list-Move field list
Practice file
Field list-resize field list
Practice file
Field list- field list views options
Practice file
Field list-field list and areas
Practice file
Field list-renaming field
Practice file
Field list-duplicate field name
Practice file
Field list-adjust the column position
Practice file
Copy as picture
Practice file
Copy as values
Practice file
Copy as new pivot table
Practice file
Exploring subtotal options
Practice file
Exploring grand total options
Practice file
Exploring report layout options
Practice file
Exploring blank rows options
Practice file
Exploring pivot table styles
Practice file
Analyze tab
Practice file
Show details
Practice file
Slicers Introduction
Practice file
PT Connections1
Practice file
PT Connections2
Practice file
PT Connections3
Practice file
Add Search Box To A Slicer
Practice file
Create slicer to filter another slicer
Practice file
Protect worksheet, not the slicer
Practice file
Slicer Styles
Practice file
Slicer Settings
Practice file
Custom slicer for year and month
Practice file
Timeline
Practice file
CF in Pivot Table
Practice file
Pivot chart
Practice file
Defer layout update
Practice file
Getpivotdata Intro
Practice file
Custom Report
Practice file
Pivot Cache
Practice file
With Source Data
Without Source Data
DSD-Without Source Data
Save source data with file
Keep source data in another file
Use external data source
Clone
Sharing cache and clone
Add one blank row
Create copy of source
Old pivot wizard
Copy to a new workbook
Multiple range names
Grouping-Practice file
Count number of pivot caches
Clear pivot cache old items
Practice file
Refresh Pivot Table-Non macro
Practice file
Refresh Pivot Table-With macro
Practice file
Sort ascending or descending
Practice file
Sort an item row left to right
Practice file
Sort manually (drag, type, right click)
Practice file
Sort using a custom list
Practice file
Override a custom list sort
Practice file
Sort regions in ascending order
Practice file
Sort new items added
Practice file
Clear a sort
Practice file
Sort L to S grand totals
Practice file
Filter by dates
Practice file
Filter by text labels
Practice file
Filter by numerical text labels
Practice file
Value Filters
Practice file
Filter by report filter
Practice file
Keep or hide selected items
Practice file
Filter by wildcards
Practice file
Filter by multiple fields
Practice file
Apply multiple filters
Practice file
Filter by multiple values
Practice file
Include new items
Practice file
Clear multiple filters
Practice file
Add filters to the column
Practice file
Grp by month and months and years
Practice file
Group by months and quarters
Practice file
Group by quarters
Practice file
Group by quarters & years
Practice file
Group by years
Practice file
Grouping by half years
Practice file
Group by time
Practice file
Group by week
Practice file
Group by date
Practice file
Grouping by a custom date
Practice file
Errors when grouping by dates
Practice file
Display dates that have no data
Practice file
Group columns
Practice file
Group numbers vs text
Practice file
Group by text fields
Practice file
Group by sales ranges
Practice file
Calculated field
Practice file
A new calc field from an existing calc field
Practice file
Excel formulas in calculated fields
Practice file
Creating a calculated item
Practice file
Calculated item on column labels
Practice file
Cal Field vs Cal Item
Practice file
Create new cal. item using existing one
Practice file
Excel formulas and calculated items
Practice file
Solve order for calculated items
Practice file
List calc field and item formulas
Practice file
Order of operations
Practice file
Shortcomings of calculated items
Practice file 1,2,3
Practice file 4,5,6
Practice file 7
Practice file 8,9
VFS Intro
Practice file
VFS- Create multiple subtotals
Practice file
VFS - Count
Practice file
VFS - Average
Practice file
VFS- Maximum
Practice file
VFS- Minimum
Practice file
VFS- Product
Practice file
VFS- Count Numbers
Practice file
VFS - Show multiple grand totals
Practice file
VFS- See all pivot items
Practice file
VFS- Show a unique count
Practice file
Percentage of grand total
Practice file
Percentage of column total
Practice file
Percentage of row total
Practice file
Percentage of
Practice file
Percentage of parent row total
Practice file
Percentage of parent column total
Practice file
Percentage of parent total
Practice file
Difference from
Practice file
Percentage Difference from
Practice file
Running total in
Practice file
Percentage Running total in
Practice file
Rank smallest to largest
Practice file
Rank largest to smallest
Practice file
Index
Practice file
Data Cleaning Techniques
Change case using upper,proper,lower
Practice file
Remove spaces using TRIM
Practice file
Using LEN Function
Practice file
Extracting text, number, values
Practice file
Adding leading zeroes
Extracting numbers and names
Practice file
Extract single digits and abbreviations
Practice file
Converting symbols to values
Practice file
Find Replace Basic Examples
Practice file
Replace first hyphen
Practice file
Replace 2nd hyphen
Practice file
Wild Card Asterisk
Practice file
Wild Card Question mark
Practice file
Wild Card Tilde
Practice file