Monthly Archives: November 2016

Free Excel Dashboard Webinars by MYNDA TREACY is back

Posted on November 29, 2016 by

If you have been following my blog for more than three months, you should have read this before.  If you wonder why I am reposting it again and again (Yes, this is the 3rd time I write about Mynda’s Excel … Continue reading →

Rate this:

Posted in General | Tagged , | Leave a comment

Be cautious when using SUMIF(s)

Posted on November 20, 2016 by

SUMIF is a handy but helpful function.  The syntax is simple: =SUMIF(range,criteria,[sum range] What it does is quite straight forward indeed.  In the example above, it instructs Excel to look into the range (A2:A7), look for the matching criteria, which … Continue reading →

Rate this:

Posted in Excel Tips, Formula | 5 Comments

Move a chart object with arrow keys

Posted on November 12, 2016 by

If you do chart in Excel, you may have encountered this: You clicked on a chart object, tried to move it just a little bit to the right by pressing Right Arrow key a few times… Instead of the chart being moved … Continue reading →

Rate this:

Posted in Excel Tips | Tagged , | 2 Comments

The powerful Power Query and the interesting TechNet Virtual Labs

Posted on November 5, 2016 by

As you may be aware of, I haven’t written a real blogpost recently.  I was super busy at work in the past month.  No surprise.  There are moments Excel won’t help me much at work, especially when bosses like PowerPoint (and PDF) … Continue reading →

Rate this:

Posted in General | Tagged , | Leave a comment