Author Archives: MF

Save a Read Only copy

Posted on April 19, 2018

When we have created a wonderful #Excel template that is to be shared with others, we don’t want users to distort, if not destroy, the template someday.  Nevertheless we would like to leave as much “flexibility” as possible to users … Continue reading →

Rate this:

Posted in Excel Tips | Tagged , | Leave a comment

Hide and Seek – External Links in #Excel

Posted on April 12, 2018

The haunted External Links that won’t go away… Have you ever bothered by this never-go-away warning message? You’d searched all worksheets (visible or hidden and very hidden too) in order to locate the external links and remove them.  Somehow, you … Continue reading →

Rate this:

Posted in Excel Tips | Tagged | Leave a comment

Hide and Seek – #Excel Worksheet

Posted on April 5, 2018

How to unhide a very hidden worksheet? Situation: You see in the formula bar that the cell is referred to a worksheet called “VeryHidden”.  However you don’t see it on the sheet tab. Naturally you right-click on a sheet tab … Continue reading →

Rate this:

Posted in Excel Tips | Tagged , | 2 Comments

April #Excel Fool

Posted on April 1, 2018

Wanna have fun with your colleagues who get too serious in #Excel on April Fool?  How about playing Hide and Seek? You may refer to my blogposts below for some ideas: Hide and Seek – #Excel Workbook Hide and Seek … Continue reading →

Rate this:

Posted in General | Tagged | Leave a comment

Hide and Seek – #Excel Workbook

Posted on March 29, 2018

Have you ever had this experience with #Excel?  Someone sent you a workbook that is empty!  What I mean empty here is not that there is no content in the workbook.  You know that there are lots of data in … Continue reading →

Rate this:

Posted in Excel Tips | Tagged , | 1 Comment

Hide and Seek – Cell Content

Posted on March 22, 2018

Don’t be shy!  Let silly things continue!  Let’s Hide and Seek with #Excel again! 🙂 Case 1 Case 2 Case 3 You may download a Sample File – Hide and Seek Cell Content for the above cases. If you know the … Continue reading →

Rate this:

Posted in Format | Tagged , , , , | 1 Comment

Hide and Seek – Column A

Posted on March 15, 2018

Cannot unhide column A? I know… it sounds another silly thing in #Excel.  But I do believe many novice users have had this experience before.  If you were one of them, you would know how frustrating that would be.  I … Continue reading →

Rate this:

Posted in Excel Tips | Tagged , , | 4 Comments

Hide and Seek – Cell border

Posted on March 8, 2018

Making cell border in #Excel should be something real basic.  However some people may have found it frustrating / confusing to play Hide and Seek with borders just hoping that they will be displayed in the way they want it. … Continue reading →

Rate this:

Posted in Format | Tagged | Leave a comment

Has Space or NoSpace in worksheet name?

Posted on March 1, 2018

Have you received workbook from others that carries underscore _ as if a space in their worksheet names?  Did you wonder why people use underscore when we can actually use space in worksheet name? Well… did you know… long long time ago, #Excel … Continue reading →

Rate this:

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

The missing link of HYPERLINK function in #Excel help

Posted on February 17, 2018

I seldom use the HYPERLINK function in #Excel.   Normally I insert hyperlink by CTRL+K, then setting the reference I want the link to go to.   That is super easy (or quick and dirty)! Note: You may go to Insert tab on ribbon … Continue reading →

Rate this:

Posted in Formula | Tagged | 2 Comments

#Excel Dashboard Course and Free Webinars by Mynda Treacy is closing soon

Posted on February 13, 2018

Just a quick reminder that registration for the awesome Excel Dashboard and Power BI courses, by Mynda Treacy closes on Thursday February 15, 8pm in Los Angeles, to be exact. With demand for Data Visualization skills and Excel data analysis jobs … Continue reading →

Rate this:

Posted in General | Tagged | Leave a comment

#Excel Humor #13 – CEO(2)

Posted on February 3, 2018

Are you a CEO?

Rate this:

Posted in General | Tagged | 2 Comments

20% off Excel and Power BI Dashboard Courses

Posted on January 31, 2018

Mynda Treacy’s popular Excel and Power BI Dashboard courses are back Dashboard reports, are no longer a buzz word, they’re a standard reporting tool for all kinds of industries and they’re an in-demand skill for Excel users everywhere. In fact, IBM project … Continue reading →

Rate this:

Posted in General | Tagged , , , | Leave a comment

The making of an interactive CV in #Excel

Posted on January 27, 2018

What to do with Linked Picture to create something interesting in #Excel? How about an Interactive CV to show off your Excel skills!? First, why? Once upon a time when I updated my CV, I was thinking… Everyone states something … Continue reading →

Rate this:

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

How to lookup an image in #Excel

Posted on January 20, 2018

Lookup an image using “Linked Picture” in #Excel Perhaps you have used VLOOKUP to return a value from a table very often.  However you cannot use VLOOKUP to return an image…  So how the above can be done?  You will … Continue reading →

Rate this:

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

#Excel Online Survey… Never heard about that!?

Posted on January 14, 2018

How to create an online survey with #Excel? Did you know that we can conduct online survey by using Excel?  Yes, you heard me right.  I said: Excel!  I am not talking about setting up questionnaire in Excel and then … Continue reading →

Rate this:

Posted in Excel Tips | Tagged , | Leave a comment

Season’s Greetings 2017

Posted on December 23, 2017

Ho…Ho…Ho… Merry Christmas! Wish you and your beloved ones a Merry Christmas and a Happy New Year of 2018! The above is made of #Excel of course… You may download a copy Seasons Greetings 2017 if you like it. 🙂

Rate this:

Posted in General | Tagged | 2 Comments

#,##0, k or #,##0.0, k ? Why not both?

Posted on December 16, 2017

Conditional Custom Formatting in #Excel Got the following question: This gives me £28.8 K (if 28800 is input) and £28.0 K if 28000 is input. I was rather hoping that if there was no decimal after the thousand, ie £28 … Continue reading →

Rate this:

Posted in Excel Tips | Tagged , , | 6 Comments

Get a list of pending tasks and sort by due dates

Posted on December 3, 2017

A common task – Get and sort a list of tasks that are not yet due according to due dates Got the following question: Suppose on column A I have entries and on column B i have due dates for … Continue reading →

Rate this:

Posted in Excel Tips | Tagged , | Leave a comment

Learn Excel Dashboard skills before end of 2017

Posted on December 2, 2017

Can’t believe it is already December.  Is learning Excel Dashboard one of your 2017 new year resolutions, that has not yet accomplished? If so, here’s a good news for you: Mynda Treacy’s popular FREE Excel Dashboard Webinars are opened for the … Continue reading →

Rate this:

Posted in General | Tagged | Leave a comment