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!
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:
Post a Comment