Author Archives: MF

The missing link of HYPERLINK function in #Excel help

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

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)

Are you a CEO?

Rate this:

Posted in General | Tagged | 2 Comments

20% off Excel and Power BI Dashboard Courses

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

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

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

#Excel Online Survey… Never heard about that!?

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

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?

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

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

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

Turn REPLACE function into “INSERT” function Continue reading

Rate this:

Posted in Formula | Tagged , | Leave a comment

#Excel Humor #12 – Power Voice

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

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

How to turn “1st January, 2017” into #Excel recognizable date?

Quite a long time ago, I wrote a post to discuss a trick to format date with “st”, “nd”, “rd”, etc… In this post, I am going to discuss the reversed way: Turning an English written date with “Dst MMMM, … Continue reading

Rate this:

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

Repeat all item labels in Pivot Table (aka Fill in the blanks please)

Quite a long time ago, I wrote a post Fill in the blanks – quickly to talk about the tip to turn a human-reading-freindly table into an Excel-friendly table, as shown below: Have you ever thought about why we are doing … Continue reading

Rate this:

Posted in Excel Tips | Tagged | 3 Comments

Extract part of text string with delimiter(s)… and more with Text to Columns

In the previous post, we talked about the basic of Text to Columns and focused on “Fixed width”.  In this post, we will continue to talk about three magical things that Text to Columns could do with ease: Extract part … Continue reading

Rate this:

Posted in Excel Tips | Tagged | 8 Comments

Extract part of a text string using Text to Columns

There are many not-so-easily-understood terms in Excel. “Text to Columns” should be one of them.  Probably due to the name of it, Text to Columns is not a common tool for many Excel users.  But indeed, if you know what … Continue reading

Rate this:

Posted in Excel Tips | Tagged | Leave a comment

Free Excel Dashboard Webinars by MYNDA TREACY is back

If you have been following my blog for more than three months, you should have read this before.  If you wonder why I am reposting it again and again, the answer is simple: it is awesome.  You could learn awesome … Continue reading

Rate this:

Posted in General | Tagged , | Leave a comment

Data Validation to restrict user from inputting to future days

The situation We need to input certain data on a daily basis.  For example, daily sales.  That is supposed to be an easy and routine task for many people.  BUT… it happened that we still have a chance to input … Continue reading

Rate this:

Posted in Excel Tips | Tagged , | 2 Comments