This video is about how to make pivot table data range dynamic in excel. We can automatically add and refresh data in the pivot table by using offset and counta formula. This is very useful when we have to regularly update pivot table data because changing data source and refreshing might be a boring process when we change the source data. Watch video till the end and be able to create a dynamic pivot table range.

свернуть