Monthly Archives: August 2016

Excel Humor #6 – Probably the shortest and the best Excel Proficiency Test

Posted on August 27, 2016 by MF

Definition of Advanced Excel user varies according to expectation.  Someone thinks advanced users should know all the VBA, Pivot Tables and be able to write super long formula.  Someone considers oneself “Advanced” for knowing the basic of VLOOKUP.   On … Continue reading →

Rate this:

Posted in General | Tagged | 2 Comments

Insert or move a field into Pivot table without drag and drop

Posted on August 20, 2016 by MF

If you do Pivot Table, the following won’t be a stranger to you as you must do a lot drag and drop to pivot. But did you know that you may insert a field name and / or  swap the … Continue reading →

Rate this:

Posted in Excel Tips | Tagged | 2 Comments

Writing a long formula in steps

Posted on August 13, 2016 by MF

Writing a long formula is not easy, even for an advanced Excel user.  What I mean long is  a formula with many nested FUNCTIONS within a single formula.  The difficulty I am talking about is not related to whether you understand the … Continue reading →

Rate this:

Posted in Formula | Tagged , , , , , | Leave a comment

Transform boring Excel reports into Business Intelligence 

Posted on August 6, 2016 by MF

Dashboard Course by MYNDA TREACY is now open Last week, I shared the news about the free Excel Dashboard Webinars by Mynda.  I hope you did find a time to join the webinars. If you haven’t watched the Webinars and … Continue reading →

Rate this:

Posted in General | Tagged , | Leave a comment

Excel Humor #5 – Are you relying on Excel too much?

Posted on August 6, 2016 by MF

Are you an Excel Dependency? Do you use Excel even for simple maths?  Sometimes I do. 🙂  

Rate this:

Posted in General | Tagged | Leave a comment