How to automatically update a pivot table with new data, when for example new rows or columns are added to a pivot table? In this video, I show you how you can create a new Named range which is dynamic and changes to update the new information added. This is because it uses the Offset formula in Excel to continually keep updating the range of data. When the source data adds new columns or rows, the range expands. For the Pivot Table to update automatically, make sure the Data Source for the Pivot Table is linked to that dynamic range that you created using the Offset function.

Connect:
https://www.instagram.com/learnaccountingfinance
https://www.learnaccountingfinance.com
Subscribe: http://www.youtube.com/c/LearnAccountingFinance?sub_confirmation=1

Course Alert:
If you would like to learn in detail, how to calculate sales variances and the impact they have on sales $, profit $ and profit margin %, and how to explain performance vs budget and prior periods, click on the link for a detailed video course (at a special price). You will also learn how to analyse and present the results of the variances to management and will be able to download solved variance calculation Excel templates. https://varianceanalysis.thinkific.com/courses/sales-variance-and-profitability-analysis-price-mix-vol-live

Videos you may like:
Learn sales and profitability analysis in detail here: https://youtu.be/CNx1Xu3DWVY
Gross profit and gross profit margin explained: https://youtu.be/Px4pEhiTRdI
How calculate selling price and profits on Etsy: https://youtu.be/WsrdSr_IIhM
Standard Margin and Actual Margin - the Difference: https://youtu.be/p-Vbqh_j-ZY
How calculate selling price and profits on Etsy: https://youtu.be/WsrdSr_IIhM

Some Recommendations:
Are you a First Time or New Manager? Check this out: https://amzn.to/35qWzLc
Learn pivot table data crunching business skills here: https://amzn.to/3lgYB5E
Learn all about Excel in one place: https://amzn.to/3laCXQx
Learn what financial numbers really mean here: https://amzn.to/2HPYDUI
Accounting explained in 100 pages or Less: https://amzn.to/3rCProc
Note: At no extra cost to you, I may receive some commission if you purchase using the links above.

Hope you find the information in the video helpful. If you like to watch more videos in accounting, financial analysis and controller ship, videos that help you directly in doing your job, subscribe to my channel. If you liked the video, I would love if you could LIKE it and leave a comment. If you have any questions or feedback, again leave a comment. Lets stay connected at #learnaccountingfinance #shorts #dynamicrange #excelshortsvideo #exceltips