Monthly Archives: November 2019

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