Monthly Archives: July 2015

SUM Time in the end of text strings

Posted on July 25, 2015 by

Did you encounter a task like this?  I did.  Actually it is not as difficult as you may expect.  It could be done in just a minute IF the data is not too bad, like the one shown above. I … Continue reading →

Rate this:

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

Ctrl+A can be more convenient than you think of…

Posted on July 18, 2015 by

If you think Ctrl+A does merely Select All, then you are likely not using it frequently.  Let’s me take you through how to boost your efficiency working with Excel with Ctrl+A under different situations.

Rate this:

Posted in Excel Tips | Tagged | 6 Comments

=SUM(‘???’!C3) Is it a valid formula?? No. It is magical indeed!

Posted on July 11, 2015 by

This is about using wildcards in referencing cells on other worksheets. If you know the basic rule about naming a worksheet, you should know that we cannot use ? or * in any part of a worksheet’s name.  So there … Continue reading →

Rate this:

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

Excel 2016 is coming! Is your company ready for this?

Posted on July 4, 2015 by

If you Google “Excel 2016 preview”, you will find many previews and comments for Excel 2016 on the Internet. I have not tried Excel 2016. Indeed, I have not yet tried Excel 2013 either, although I keep an eye on … Continue reading →

Rate this:

Posted in General | 2 Comments