What is the coolest Excel trick you have learned this year?

We are almost at the end of 2013. Time to review how much more awesome we became this year. Today let me ask you a very simple question.

What is the coolest Excel trick you have learned this year?

Go ahead and post your answers using comments.

I will go first:

As my life revolves around Excel, not a week goes by when I don’t learn something new. That said, 3 of the most impressive tricks I have learned this year are,

• Calculating sum of top 3 values in a filtered list.
• Transposing a table of formulas quickly using copy-paste.
• Shading above or below lines in Excel charts

For me the coolest trick has to be the transposing one. This, shared by Joey (a commenter on Chandoo.org) shows how to solve a tricky problem with smart thinking.

What about you?

Go ahead and tell me what is the coolest Excel trick you have learned all this year.

We have 18 more days in this year and I am really hoping to learn few more awesome tricks. I am all ears to hear what you have to say.

Go!