Monthly Archives: June 2016

UPPER, lower, Proper

I am wondering why these functions are not available in Word, but Excel? Don’t make me wrong.  I like these functions.  Nevertheless I am not a big fan (nor a small fan) of using Excel as word processor.  Whenever possible, … Continue reading

Rate this:

Posted in Formula | Tagged , , | 10 Comments

RIGHT. I LEFT. In the MID of…

Obviously this post is about the most popular text related functions in Excel.  Meanwhile, it is also a message from me… Yes, you are RIGH! I LEFT my ex-company and have landed on a new job which is much more … Continue reading

Rate this:

Posted in Formula | Tagged , , | Leave a comment

Custom List is so good

  Did you know… you can create a list of Month and Day of Week by drag and drop?  You probably knew it on the first week of your Excel journey…  But did you know that, Excel may also give … Continue reading

Rate this:

Posted in Excel Tips | Tagged | 3 Comments

Open sesame with Alt+↓

Alt+↓ is absolutely one of my frequently used shortcuts when using Excel. What it does?  “Open sesame” under four common circumstances. 🙂 When you are at the bottom of a column   Alt+↓ displays the list of items on the column. … Continue reading

Rate this:

Posted in Shortcut | Tagged | Leave a comment