Learn how to completely automate (100%) your reports with Microsoft Excel Pivot Tables and some simple tweaks/tricks. If you prepare frequent reports, such as daily sales, or daily margin report, you do not have to create and update the reports every day at all. You do not even need advanced business intelligence tools. You can keep it simple, and nice and easy by automating you existing Pivot Table.
Download the file here:
Note: If you would like to learn in detail, how to calculate all income statement variances and the impact they have on sales, gross profit and ebitda, both in $ and %, and how to explain performance vs budget and prior periods, click here for a detailed video course (at a special price for readers of this post) showing exactly how this is done. 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 files.
Would you like to work with me to get one on one training, or to solve your specific workplace challenges, book your 15 minute consultation here: https://calendly.com/learnaf
For fully automated reporting using a Pivot Table, you need a few things to be automated within the Pivot Table: 1) Pivot Table Data Range (to expand or shrink with changes in Source Data) 2) Calculations within the Pivot Table (such as calculation of Gross profit and profit Margin) 3) The Sorting Order for data in the Pivot Table 4) Pivot Table format to stay consistent with changes in source data 5) The Pivot Table should be able to Auto Refresh when new data is updated. This video covers all of these topics, while we work together with source data in the file provided.
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.
Connect:
https://www.instagram.com/learnaccountingfinance
Home
https://www.tiktok.com/@learnaccountingfinance
Subscribe: http://www.youtube.com/c/LearnAccountingFinance?sub_confirmation=1
.
Learn Accounting Finance 
I receive a “Reference isnt valid” error when i attempt to change the table range to the “Data1”.
any suggestions?
LikeLike
Hi Stephen. Please check the offset formula is entered correctly with counta for colums and rows. The columns and rows selected should reflect the first column and row where data begins. Also when defining the name, check that the scope is “workbook” and not any specific sheet. Thanks.
LikeLike