There are 16 free training skills of how to use office suite for Data Analysis
How to filter data horizontally
01:34
How to filter data horizontally
How to merge sheets with the same name
01:43
How to merge sheets with the same name
How to merge multiple worksheets into a worksheet
01:28
How to merge multiple worksheets into a worksheet
How to split a workbook into multiple files
01:39
How to split a workbook into multiple files
Split Books by Sheet
01:09
Split Books by Sheet
More features in AutoFilter
02:39
More features in AutoFilter
More features in Remove Duplicates
03:14
More features in Remove Duplicates
How to create a Form in spreadsheet
01:26
How to create a Form in spreadsheet
Use subtotal feature to do statistic
04:35
Use subtotal feature to do statistic
How to insert calculated fields in PivotTable
01:06
How to insert calculated fields in PivotTable
Refresh pivotTable and change data source
01:28
Refresh pivotTable and change data source
Use data check method to quickly find difference items
01:40
Use data check method to quickly find difference items
Quickly locate and view data
03:46
Quickly locate and view data
How to set the calculated field of the pivot table
01:49
How to set the calculated field of the pivot table
Learn pivot table from the beginning
04:27
Learn pivot table from the beginning
Quickly filter classified data
01:41
Quickly filter classified data