Author Archives: MF

Quick Tip – #Excel AutoSum

Posted on April 13, 2019

While SUMMING data is probably the most common task in Excel, I am surprised that many people are not aware of this Excel feature – AutoSum.  It is super handy especially when you know the shortcut of it, which is … Continue reading →

Rate this:

Posted in Excel Tips | Tagged | Leave a comment

#Excel Add current selection to filter. What it does?

Posted on April 7, 2019

Get multiple filter criteria with Excel Auto-Filter This post is in response to the following Mr.Excel video where Mr. Excel Bill Jelen solved the problem with Advanced Filter. Indeed I got a similar question from a colleague recently for filtering … Continue reading →

Rate this:

Posted in Excel Tips | Tagged | Leave a comment

#Excel Flash Fill in action with 16 examples

Posted on March 31, 2019

Flash Fill was introduced in Excel 2013.  After 6 years, it is still a hidden gem of modern Excel that most regular Excel users do not even know its existence.  Whenever I show to my colleagues what Flash Fill is … Continue reading →

Rate this:

Posted in Excel Tips | Tagged | 2 Comments

Birthday Treat Calculator

Posted on March 16, 2019

A powerful tool for a silly thing.  Why not?  🙂 Long time ago, I wrote a blog post How much do I need to pay? which was not really related to Excel but calculation of a random daily event.   … Continue reading →

Rate this:

Posted in General | Tagged | Leave a comment

Extract FirstLast names in CamelCase with #Excel formula

Posted on March 10, 2019

In the previous blog post, we see how Flash Fill extracts First Name and Last Name from an email address in a format shown above.  I’ve also recorded a video for that post. Flash Fill is so smart to detect … Continue reading →

Rate this:

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

Turn CSV data into insight like a pro with Excel 2016

Posted on March 3, 2019

Many people are not aware of how easy-to-use and powerful modern Excel is. I mean Excel 2016 or later. In this post, I will show you how to turn CSV data into insight in a just a couple of minutes like a pro. Techniques used: Flash Fill, Quick Analysis and two new chart types (Histogram and Pareto). Continue reading →

Rate this:

Posted in Excel in Action | Tagged , , , | 2 Comments

My second #Excel Video on YouTube

Posted on February 23, 2019

Glad to share with you my second video here.   This video is about how to plot a compelling to compare Actual vs. Budget, Target and Last Year data.  The written instruction is available in previous post – A compelling chart in three … Continue reading →

Rate this:

Posted in General | Tagged | 2 Comments

A compelling chart in three minutes…

Posted on February 17, 2019

In business world, we often compare actual sales to various benchmarks such as budget, target, and last year. In this post, I am going to show you step-by-step how to make a compelling chart for this purpose. This is basically a simplified version of bullet chart, and is super-easy to create. I hope you find it useful and relevant. Continue reading →

Rate this:

Posted in Chart | Tagged | Leave a comment

My first #Excel video on YouTube

Posted on February 9, 2019

Kung Hey Fat Choi!  This week is Chinese New Year.  I wish you a fruitful, healthy, and rewarding Year of Pig! I have almost one week off for CNY holiday.  I have cleaned my PC and spared 50G+ space in … Continue reading →

Rate this:

Posted in General | 2 Comments

Did you know… there are many nice Excel Templates readily available?

Posted on February 3, 2019

Did you know that there are many nice Excel Templates readily for usage? Next time when you start a New workbook, browse or even search for a template that suits your need. Or you may start from a template. Why re-invent a wheel? Continue reading →

Rate this:

Posted in Excel Tips, Template | Leave a comment

Learn something amazing from Mynda’s #Excel Dashboard webinars

Posted on February 3, 2019

Free Excel Dashboard Webinars We don’t know what we don’t know.  The best way is to learn something new is to explore the web (or world), and/or learn from experts. Sometimes we just don’t know, or even don’t expect what … Continue reading →

Rate this:

Posted in General | Tagged , | Leave a comment

Hard-coded range expands automatically with #Excel Table

Posted on January 26, 2019

The INDIRECT trick of using Structured Reference in Conditional Formatting   Is it a feature or a bug? This is an extension of the previous post, in which we discussed the use of INDIRECT trick to deal with Excel Table in Conditional … Continue reading →

Rate this:

Posted in Excel Tips | Tagged , , | 1 Comment

The INDIRECT trick of using Structured Reference in Conditional Formatting

Posted on January 19, 2019

When setting up conditions for Conditional Formatting in Excel, have you ever tried to set a formula that refers to a Excel Table, but failed?

First of all, why we want to refer to Excel Table in Conditional Formatting? There is one simple answer: To accept new data automatically. 
To use Structure Reference in Conditional Formatting, we need an INDIRECT approach which is discussed here. Continue reading →

Rate this:

Posted in Excel Tips | Tagged , , , | 2 Comments

Highlight weekends and holidays using Conditional Formatting in #Excel Part 2

Posted on January 13, 2019

Conditional Formatting with formula could be tricky (or difficult), especially when the data layout is bad because you have to very clear and careful on the “applied to” range and the absolute/relative references set in the formula. Otherwise, it won’t work and can be quite confusing, if not frustrating. 😛

In this post, I will talk about a case that you will see how empty rows in a data set would complicate the process in setting up conditional formatting. And then I will show three different approaches to tackle the issues. Hope you find it helpful. Continue reading →

Rate this:

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

Highlight weekends and holidays using Conditional Formatting in #Excel

Posted on January 6, 2019

In this post, I will show you step by step how to set up conditional formatting to highlight weekends and public holidays with Excel. The key is to set the formula right. Having a proper layout will make the whole thing more easier, which will be discussed in the next post. Continue reading →

Rate this:

Posted in Format | Tagged , , , | 3 Comments

[Share] Introduction of #Power Query M code by ExcelIsfun

Posted on January 1, 2019

Happy New Year!  Wish you all an Excel-lent year of 2019! As an Excel nerd, I’d like to spend my holidays on learning Excel… haha… I know I am abnormal.  ;p  My recent love of Excel is Power Query (M) … Continue reading →

Rate this:

Posted in Power Query | Tagged | Leave a comment

Highlighting Top X values with Icon Set in #Excel

Posted on December 22, 2018

This post is a continuation of the previous one – Highlighting Top X values with Conditional Formatting in #Excel So I will go straight to the point.  For background information, please read the previous post. 🙂 To insert Icon Set Select … Continue reading →

Rate this:

Posted in Excel Tips | Tagged , | Leave a comment

Highlighting Top X values with Conditional Formatting in #Excel

Posted on December 15, 2018

Well… think this topic is too simple?  How about doing this with a dropdown menu to make the Top X a dynamic one? with Icon Set? You may download a Sample File to follow along. Let’s start with the basics … Continue reading →

Rate this:

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

Customize Alt 1 to 4 to become the favorite #Excel shortcuts of your own

Posted on December 8, 2018

When talking about keyboard shortcuts, there is always discussion on what’s the most time-saving shortcuts, what are the top X shortcuts you should learn, what is the most frequently used shortcuts, etc… Just to name a few, Ctrl+S to save, … Continue reading →

Rate this:

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

Using Skip blanks in Paste Special

Posted on December 2, 2018

What the Skip blanks does? Have you ever had this question?  From my experience, 99.9% users (I work with) have no idea what it is or even are not aware of that option in Paste Special. Are you one of … Continue reading →

Rate this:

Posted in Excel Tips | Tagged | Leave a comment