Monthly Archives: September 2013

How to copy visible cells only?? – GO TO SPECIAL: visible cells only

Have you run into a situation that you wanted to copy a table, like the one below, to a new worksheet. However the Table “expanded” automatically… All the information from the hidden rows and columns reappears.  What??? A simple trick … Continue reading

Rate this:

Posted in Excel Tips | Tagged | Leave a comment

Another use of F4 – Repeat LAST action

Excel tips: F4 to repeat LAST action As mentioned in my previous post, F4 is my favorite keyboard buddy.  It helps you quickly shift between relative reference and absolute reference when building formula; it also helps to repeat your last … Continue reading

Rate this:

Posted in Excel Tips, Shortcut | Tagged | Leave a comment

How to calculate number of days, months, or years from one date to another date – DATEDIF function

如何計算兩個日子之間有多少年/月/日? Recently, I got enquired about function for calculating number of days from one date to another date.  DATEDIF is on the top of my mind.  :) Interestingly this function is not commonly known probably because it won’t show up … Continue reading

Rate this:

Posted in Formula | Tagged | 9 Comments

Excel Topics Preview

Learning Excel is a series of trial and error.  Sometimes it succeeds,  most of the time it fails. 🙂 Whenever I learn something new, I will test it again and again in order to make sure I understand the usage. … Continue reading

Rate this:

Posted in General | Leave a comment

How to switch between Absolute and Relative reference? F4

如何快速轉換公式中的絶對參照及相對參照? To kick off my first blog, I would like to introduce my buddy on keyboard to you – F4 To me, it helps 1)      Switch between Relative and Absolute reference easily when typing formula 2)      Repeat last action Let’s … Continue reading

Rate this:

Posted in Excel Tips, Formula, Shortcut | Tagged | 1 Comment

Excel Journey

“A good teacher teaches; a great teacher inspires.” Long time ago, I had a chance to sit in a class called “Decision Making with Computer” when my excel knowledge was limited to “table drawing” and basic + – * /.  … Continue reading

Rate this:

Posted in General | Leave a comment