Microsoft Excel is an extremely capable spreadsheet creation and management tool, made all the more powerful through the inclusion of many handy shortcuts and features. We wanted to share one for a common enough function that you are effectively sure to find a use for it: quickly adding up the values in a single column.
And just know, when we say quickly, we mean it.
Let’s say that you were trying to keep an inventory of all the desktop monitors you had in the office, not just keeping a total for each make and model of monitor, but how many you had cumulatively assembled.
Using Excel, you could easily keep track of which models you had in the office, and how many of them.
Simple, right?
Of course, to add them all up, many people might suggest that you would insert the formula =SUM(B1:B10) in Cell B11, but there’s an even simpler and faster way to accomplish the exact same thing.
This will immediately give you the sum of the values in the column above your selected cell.
In this case, you can easily see you are in possession of 43 assorted monitors.
We hope this tip helps make your life in the office that much easier. Be sure to check back to see what other tidbits of tech advice and information we have to share, or give us a call at (270) 282-4926 to find out more about our services.
About the author
I consider myself a very eclectic driven individual. I am an entrepreneur at heart and am addicted to self improvement. I enjoy creating my own objectives and path in life rather that be within my company or with my family. I live by the philosophy to always strive to be the best version of yourself. I love people and therefore I love the service industry. Success in life and in business is what I look for in every day!
Comments