Use pivot chart to create a dynamic chart

How to filter data horizontally

How to merge sheets with the same name

How to merge multiple worksheets into a worksheet

How to split a workbook into multiple files

Split Books by Sheet

More features in AutoFilter

More features in Remove Duplicates

How to create a Form in spreadsheet

Use subtotal feature to do statistic

How to insert calculated fields in PivotTable

Refresh pivotTable and change data source

Use data check method to quickly find difference items

Quickly locate and view data

How to set the calculated field of the pivot table

Learn pivot table from the beginning