Thursday, January 14, 2016

Little Known Tricks…

Some little-known Excel tricks (for keyboard or mouse) are Totally Cool, and if you have never run into the topic of this week’s blog, I am sure you will agree that it is a potential Crowd Pleaser!

Let’s say that you have 14 columns of data for which you want to calculate the Sums. “Piece of Cake”, you say!  Well, you’re right, it won’t take more than a couple of minutes to set up and accomplish.  But what if you want to do it with Style and Panache?  Here is what you do: Simply select the Entire Block of data, and press Alt + = on your keyboard. Ala Kazam! The sums for All of your columns will instantly appear like magic in the row below your data.

Some More Fun
You can do even more Magic by once again selecting the entire range of data and choosing Average, Count, Max, or Min from the AutoSum icon on your toolbar. The calculations will, once again, Instantly Appear for all columns of data!


There are, of course, several different ways of achieving the same results in Excel. The Key is to do it with Speed and Flair! After all, you want to be one of the Cool Kids, right? Give these tricks a try, and listen to everyone go Oooh and Aaaah…

No comments: