Monthly Archives: May 2018

Maintain a price book in #Excel with #PowerQuery

Feel the Power (Query) This is my first post devoting to my recent love for Excel – Power Query.  🙂 First, let me make myself clear.  I am still learning Power Query (indeed I am still learning Excel too).  The … Continue reading

Rate this:

Posted in Power Query | Tagged , , | 4 Comments

Create your own favorite keyboard shortcuts in #Excel without VBA

Make better use of the Quick Access Toolbar (QAT) We all know that shortcuts could save us lots of time when working with Excel.  Excel has many built-in shortcuts.   Ctrl+C, Ctrl+V should be the most popular and commonly used … Continue reading

Rate this:

Posted in Shortcut | Tagged , | 3 Comments

#Excel Humor #14 – Insert Table

I am having an incentive trip in Osaka… not sure if this is due to my Excel skills. 😛 So let’s have fun this week. 🙂   What would you say if you were the interviewer?  Leave it in comments.  … Continue reading

Rate this:

Posted in General | Tagged | 2 Comments

How to remove leading space in #Excel

When TRIM and CLEAN do not work… Is it something bothering you? To fix this problem, we need to understand where is the “leading space” coming come.  Before we jump to that, I want to show you two Excel functions … Continue reading

Rate this:

Posted in Formula | Tagged , , , , | 2 Comments