Monthly Archives: November 2019

Be cautious when using XLOOKUP

Posted on November 30, 2019 by MF

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

Create in-cell chart with Conditional Formatting in #Excel

Posted on November 24, 2019 by MF

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

Posted on November 19, 2019 by MF

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?

Posted on November 9, 2019 by MF

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