Monthly Archives: June 2017

Are you ready to turn boring Excel reports to Business Intelligence?

Well, I know.  You may have read similar topics before in my blog.   You are now seeing it again because the awesome Excel Dashboard Course by Mynda Treacy is now open.  What’s more exciting?   Mynda puts her popular courses “Excel … Continue reading

Rate this:

Posted in General | Tagged , , | Leave a comment

The basic of Form Controls

Want to work like an Excel Pro?  Learn more about Form Controls. Have you seen someone using Check box, Option Buttons, Scroll Bars on their worksheets and be impressed?  You may wonder how they made it and think that is … Continue reading

Rate this:

Posted in Excel Tips | Tagged | Leave a comment

Excel Humor #10 – WannaCry moments in Excel

      There must been many others.  Please share in comments. 🙂

Rate this:

Posted in General | Tagged | Leave a comment

The amazing SUMPRODUCT

Advanced use of SUMPRODUCT for multi-conditional SUM In the previous posts, we talked about the basic of SUMPRODUCT, the behaviors of logical  values (i.e. TRUE/FALSE) when they are put into basic mathematics operations.  These set the foundation to understand the … Continue reading

Rate this:

Posted in Formula | Tagged , | 2 Comments