Microsoft Office Tutorials and References
In Depth Information
How to Update Your Report Each Period
This chapter has discussed many details about how to create a
So briefly, let’s back up from the details and see where we are…
Our goal has been to create dashboards and other reports that we
can update easily and that are easy to read. This is what we’ve
Each period, you update your Excel database with new data, and
then you check it for errors. When the data is ready to report, you
open your first report, enter the new date, recalculate, and print.
Then you open the next report that uses your data; you enter the
new date, recalculate, and print. You do the same for the next
report, and the next.
It’s that easy.