Monthly Archives: April 2015

Keyboard shortcut tip – Filter by selection with Menu Key

Posted on April 25, 2015 by

You may have no idea about the shortcut key combinations above (the middle clip art is not a key combination, ok?!).  That’s normal, I guess.  Most of the time we talk about keyboard shortcuts, we think about Ctrl or Alt. … Continue reading →

Rate this:

Posted in Excel Tips, Shortcut | Tagged , , | 5 Comments

Do you know Menu Key??

Posted on April 18, 2015 by

This key is sitting on the keyboard forever.  I wonder how many people have ever pressed it?  Maybe you don’t even know where the key is on keyboard… do you? It is between “Windows” and “Ctrl”, just two keys below … Continue reading →

Rate this:

Posted in Excel Tips, Shortcut | Tagged | 2 Comments

Sum a range of number end with “k”

Posted on April 11, 2015 by

Does it sound familiar to you? If you are having this kind of issue all the time, you may want to continue reading this as I am going to show you three different approaches to fix the problem. Non-Formula approach Formula … Continue reading →

Rate this:

Posted in Excel Tips, Formula | Tagged , , , | 5 Comments