Five most popular posts on the blog of Excel in 2011

AppId is over the quota

It's still January. There's still time to share the most popular posts on the Excel blog in 2011.  Thanks for reading them!

Can't remember all those Excel keyboard shortcuts? Now you don't have to!
There are a lot shortcuts in Excel of keyword. You can scroll through a long list of them on Office.com, or you can download quick reference cards from our blog and pin them to your corkboard. There are cards for keyboard shortcuts with the CTRL keys, keyboard shortcuts with function keysand Miscellaneous shortcuts.Staying on budget might be easier than you think
The end of January marks the beginning of procrastination for preparing your taxes. This Excel budget template could help.A capital idea: changing case in Excel (video)
Unlike Word, Excel does not have a change case button for magically switching between uppercase, lowercase, and proper case. But you can use functions to covert text from one case to another, or even a macro. Watch these videos by MVP Bill Jelen to learn about the different techniques. Excel table or Pivot Table?
In Excel there are tables and then there are Pivot Tables. This post explains what each does and when to use one or the other. How to do percentages in Excel
In sorting through the search terms people use to find information, we always find lots of variations on the word "percentages." This post walks you through how to calculate percentages in Excel. (And it points you to videos that offer quick refreshers on the underlying math.)

When we looked back to see which post received the most comments, it not all that surprising.  It what the one when we got to hear from all of you:

Your call: what would you like US to post about on the Excel blog?

As start this new year we (ok, it started four weeks ago), we want to hear what you'd like US to write.  So leave a comment and we'll do our best to write a post to answer it.

View the original article here