How to update and add new data to a PivotTable and keep reference updated - Excel & Google Sheets

Learn how to automatically update the cell reference in your PivotTable so that when you add new data to your source, the PivotTable automatically picks up those new rows. I describe two methods for how to do this in Excel and Google Sheets. The preferred method is to turn your source data into a table (if you are using Excel).

* Intro - 0:00
* Method 1: change data source to reference all columns - 1:46
* Doing method 1 in Google Sheets - 6:17
* Method 2: turn data into Excel table - 9:35

👉 Copy the Google Sheet: https://docs.google.com/spreadsheets/...
👉 Copy the Excel file: https://www.thekeycuts.com/wp-content...
👉 Subscribe to Dear Analyst: https://podcasts.apple.com/us/podcast...
👉 Original blog post for this podcast episode: https://www.thekeycuts.com/dear-analy...
👉 Excel for the Real World online class: https://skl.sh/2lsi6up