Monthly Archives: June 2017

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

Posted on June 27, 2017 by

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

Posted on June 24, 2017 by

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 | 2 Comments

Excel Humor #10 – WannaCry moments in Excel

Posted on June 17, 2017 by

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

Rate this:

Posted in General | Tagged | Leave a comment

The amazing SUMPRODUCT

Posted on June 3, 2017 by

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