Author Archives: MF

Unknown's avatar

About MF

An Excel nerd who just transition into a role related to data analytics at current company......😊 Recently in love with Power Query and Power BI.😍 Keep learning new Excel and Power BI stuffs and be amazed by all the new discoveries.

April #Excel Fool

Posted on April 1, 2018 by MF

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 blog posts below for some ideas: Hide and Seek – #Excel Workbook Hide and … Continue reading →

Rate this:

Posted in General | Tagged , | Leave a comment

Hide and Seek – #Excel Workbook

Posted on March 29, 2018 by MF

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 by MF

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 by MF

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 by MF

Making cell border in #Excel should be something really 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. For example, … Continue reading →

Rate this:

Posted in Format | Tagged , | Leave a comment

Has Space or NoSpace in worksheet name?

Posted on March 1, 2018 by MF

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 by MF

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 | 6 Comments

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

Posted on February 13, 2018 by MF

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 by MF

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 by MF

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 by MF

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 , , , , , , | 5 Comments

How to lookup an image in #Excel

Posted on January 20, 2018 by MF

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 , , | 20 Comments

#Excel Online Survey… Never heard about that!?

Posted on January 14, 2018 by MF

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 by MF

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 by MF

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 by MF

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 by MF

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

Insert a text string into a specific position of another text string in #Excel

Posted on November 25, 2017 by MF

Turn REPLACE function into “INSERT” function Continue reading →

Rate this:

Posted in Formula | Tagged , | 5 Comments

#Excel Humor #12 – Power Voice

Posted on November 18, 2017 by MF

Did you experience the Power Voice for #Excel?   Like this post if you did.   😛

Rate this:

Posted in General | Tagged | Leave a comment

Data transformation with Power Query

Posted on November 11, 2017 by MF

Transform date input as “Excel-unrecognized” text string into date (number) usable by #Excel This is a continuation of the previous post – How to turn “1st January, 2017” into #Excel recognizable date?   …using Get & Transform (better known as #PowerQuery). Note: … Continue reading →

Rate this:

Posted in Power Query | Tagged , | Leave a comment