There are 16 free training courses of how to use office suite for Data Analysis
Use pivot chart to create a dynamic chart
04:49Learn pivot table from the beginning
04:27Use subtotal feature to do statistic
04:35How to filter data horizontally
01:34How to merge multiple worksheets into a worksheet
01:28Split Books by Sheet
01:09Use data check method to quickly find difference items
01:40Quickly locate and view data
03:46Quickly filter classified data
01:41How can we use the data validation feature
02:46How to merge sheets with the same name
01:43How to split a workbook into multiple files
01:39More features in AutoFilter
02:39More features in Remove Duplicates
03:14How to create a Form in spreadsheet
01:26How to insert calculated fields in PivotTable
01:06Relate tags of office software Data Analysis
Moreexport datatable to excel in vb net windows application stock price analysis excel ms excel data entry form import data from web to excel excel data filter shortcut create data model in excel create a word mail merge with excel data covariance analysis excel convert json data to excel construct a boxplot for a data set