Author Archives: MF

About MF

An Excel nerd who doesn’t work on Excel most of the time at current job...... 🤔 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.

Compare two #Excel workbooks for changes

In about 5 years ago when I was still using Excel 2010, I wrote a post Compare two documents for changes – Word and maybe Excel.  Lukas left a comment: In the Inquire Add-In you have the option to compare … Continue reading

Rate this:

Posted in Excel Tips | Tagged , | Leave a comment

What-If analysis in #Excel – Part 2

Basic of Two way Data Table This is an extension of the post What-If analysis in #Excel. If you do not know about Goal Seek or One-Way Data Table, you may read Start the new decade with Goal Seek in #Excel and What-If … Continue reading

Rate this:

Posted in Excel Tips | Tagged , | Leave a comment

Wanna boost your #Excel Dashboard skill?

Is learning Excel Dashboard one of your 2020 resolutions? If so, then you’re in for a treat because today I’m excited to tell you about Microsoft Excel MVP, Mynda Treacy’s highly acclaimed <Excel Dashboard Webinars> are open for limited time! … Continue reading

Rate this:

Posted in General | Tagged , | Leave a comment

What-If analysis in #Excel

Basic of One way Data Table This is an extension of the post Start the new decade with Goal Seek in #Excel.   In that post, we talked about using Goal Seek to find the initiate savings required to obtain a … Continue reading

Rate this:

Posted in Excel Tips | Tagged , | Leave a comment

#Excel Power Query solves a real life problem – Who eats what?

Interesting application of Power Query for real life problem – See how to transform table into different layout using Power Query I came across this Power Query Challenge from Computergaga and I found it really interesting as it seems that … Continue reading

Rate this:

Posted in Power Query | Tagged , , , , , | 7 Comments

Start the new decade with Goal Seek in #Excel

Happy New Year of 2020!  Wish you all an Excellent year decade ahead! 😉 Have you made your new year resolutions? Or you are relying on Excel to set your goals of the year? Did you know that Excel has … Continue reading

Rate this:

Posted in Excel Tips | Tagged , | Leave a comment

Free Template: Party Expense Calculator

Christmas has just passed while New Year is just around the corner.  Party must go on! As a token of appreciation for you visiting my blog, I am going to present you a free gift – Party Expense Calculator,  in … Continue reading

Rate this:

Posted in Template | Tagged , | Leave a comment

Insert Current Time or Today using #Excel functions or shortcuts

It’s not uncommon to insert a date stamp or time stamp on a spreadsheet.  We may use the following functions to get the results easily: =TODAY() ‘to get the date of today =NOW() ‘to get both the date of today … Continue reading

Rate this:

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

Create in-cell chart with Sparklines in #Excel

🎵🎤Do you wanna build the Sparklines? Sparklines is not a new feature of Excel.  It was introduced in Excel 2010.  Yes, almost a decade ago.  But I am quite sure it’s still something new to a lot of regular Excel … Continue reading

Rate this:

Posted in Excel Tips | Tagged | Leave a comment

Be cautious when using XLOOKUP

Can you spot the error in the above formula? It’s not about the new function of XLOOKUP.  It’s about inevitable human error… If you are an Excel fan, you should be aware of the exciting XLOOKUP function in Office 365.  … Continue reading

Rate this:

Posted in Formula | Tagged , , , | 4 Comments

Create in-cell chart with Conditional Formatting in #Excel

Have you ever seen an Excel sheet with in-cell bars to visualize the data like the ones below, and wonder how they are made? Believe it or not, you can do it in one less than a minute with Conditional … Continue reading

Rate this:

Posted in Excel Tips | Tagged | Leave a comment

Last Chance for Dashboard Course and Free Webinars

Just a quick reminder that registration for the awesome Excel Dashboard and Power BI courses by Microsoft Excel MVP, Mynda Treacy, closes on Thursday Nov 21, 8pm in Los Angeles, to be exact. With demand for Data Visualization skills and … Continue reading

Rate this:

Posted in General | Tagged , | Leave a comment

Are you tired with data dump Excel Report?

that takes you long to prepare; and is hard for report consumers to get insight… If you’ve ever felt like: “My Excel reports take way too long to update each month/week” “I spend hours collating and cleaning data, updating formulas … Continue reading

Rate this:

Posted in General | Tagged , | Leave a comment

The power of Dynamic Arrays in #Excel 365

… in creating dynamic drop-down with conditions Making a dynamic drop-down list is not difficult.  It may require multiple steps, helper formula and/or helper tables though.  And the number of helper tables depends on the complexity of the requirement.  I … Continue reading

Rate this:

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

Get a list of A to Z in #Excel

Have you ever tried to input “A” and then drag it down with a hope of getting a list of A to Z? If you tried (and without success), you may be wonder how I did it? You may find … Continue reading

Rate this:

Posted in Excel Tips | Tagged | Leave a comment

Add Data Labels for Total to Stacked Columns in #Excel

When we create stacked columns in Excel, we exclude Total from the data as it may give an extra stack that we don’t want.  However, we may want a data label for Total on the stacked columns, like the one … Continue reading

Rate this:

Posted in Chart | Tagged | Leave a comment

You think you know Copy and Paste in #Excel?

11 Excel Copy and Paste Tips and Tricks you should know Perhaps Ctrl+C and Ctrl+V are the pair of shortcuts you use on a daily basis.  And probably you learned that on the first day your learned Excel.  Nonetheless, do … Continue reading

Rate this:

Posted in Excel Tips | Tagged | Leave a comment

Suggestion: Adding a button for number formats in thousand/million/billion in #Excel

Did you know what you may submit your ideas to improve Excel through UserVoice? The recent HOT news in the Excel community – the new XLOOKUP function is also resulted from an idea submitted in UserVoice. While everyone is super exciting … Continue reading

Rate this:

Posted in General | Tagged | Leave a comment

CTRL A to Z – Learn 25 #Excel Shortcuts with demonstrations

Do you know how many keyboard shortcuts we have in Excel?  Honestly, I don’t know.  I just know the shortcuts that I need to use.  Believe it or not, from Ctrl+ A to Z, I use them all but M, … Continue reading

Rate this:

Posted in Shortcut | Tagged | Leave a comment

The proper way of copying worksheet in #Excel

It is not uncommon for people to copy entire worksheet to another sheet (be it on the same workbook, or another workbook, even a new workbook). Nevertheless, are we doing it the right way? Many people would do so by … Continue reading

Rate this:

Posted in Excel Tips | Tagged , | Leave a comment