Easy-to-follow video tutorials help you learn software, creative, and business skills.Become a member
If you're working on a Tables Datasheet View it can be handy to see instant calculations at the bottom of my Table. I have opened my Orders Table, and up on the Home ribbon, about the middle, there is a stigma with the word Totals on it, I'll click on it and a new row appears at the bottom of my data. Note that it is not part of my Table; it stays at the bottom of my screen as I scroll. When I click in the cell at the bottom of each column a dropdown arrow appears, click on it and you'll see a number of choices appropriate to that type of data.
For our dates I can find the Average date of the order, the Count of how many orders there were, Maximum will give me the most recent date, Minimum would give me my earliest date. I'll choose Minimum-- and my first order was placed in January 10, 2006. The dropdown underneath the Customer column only allows me to Count how many orders there are, and there are 47. Underneath Product, I also only have those same choices. My Count is again, 47. Now under the Quantity it gets a little more interesting, when I drop down the arrow I can Sum up the number of bottles that I have sold, I can find the Average quantity in all my orders, again, I can Count how many orders that were, I can find my largest order or find my smallest order.
Standard Deviation and Variants are advanced statistics. Standard Deviation would find the median order and tells me how far off of that average each of my orders are and Variance squares that number. If I click on Minimum, and scroll through my data, it will also put in boldface any of the orders that have that quantity. What's also nice is that if I turn off my Totals and then turn again the settings that I had chosen previously still remain.
Having instant calculations at my fingertips prevents me from having to run Queries or create Reports in order to do basic statistical analysis.
Get unlimited access to all courses for just $25/month.Become a member
82 Video lessons · 90604 Viewers
80 Video lessons · 137950 Viewers
59 Video lessons · 56705 Viewers
52 Video lessons · 70316 Viewers
Access exercise files from a button right under the course name.
Search within course videos and transcripts, and jump right to the results.
Remove icons showing you already watched videos if you want to start over.
Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.
Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.