Monthly Archives: February 2017

Last Chance for Power BI and Excel Dashboard courses by Mynda Treacy

Posted on February 28, 2017 by MF

  As an Excel user you’ve probably created the occasional report. You may even regularly create Excel Dashboard reports. After all, Dashboards are the most value-adding element for Excel users. However, if you’ve used Excel to build dashboards then you probably … Continue reading →

Rate this:

Posted in General | Tagged | Leave a comment

Want some pies?

Posted on February 25, 2017 by MF

First of all, this blogpost is about Pie Chart, but not about how to make a Pie Chart.  Indeed, I am not going to show the steps of making Pie Chart here.   Also I am not intended to discuss whether … Continue reading →

Rate this:

Posted in Chart | Tagged , , | 2 Comments

Copy and Paste can do so much…

Posted on February 18, 2017 by MF

Answer to the 5 little Tips (tests) – Part 5/5 The task: To sort the following dates in descending order.  Sound silly but… The first thing you would probably do is to go to Data tab and then click the Sort Z to A icon? … Continue reading →

Rate this:

Posted in Excel Tips | Tagged , , | 22 Comments

Go to Special + Copy and Paste do the magic

Posted on February 11, 2017 by MF

Answer to the 5 little Tips (tests) – Part 4/5 The task: To convert “1” to “Tick” in a table like the following one: Answer:  Copy and Paste with a simple trick … What? Not Find and Replace?  Yes, you may do it by using … Continue reading →

Rate this:

Posted in Excel Tips | Tagged , , | 4 Comments

Free webinar on Power BI by Mynda Treacy is coming soon

Posted on February 8, 2017 by MF

Have you heard about Power BI from Microsoft? Probably yes.  However I guess most people are not yet aware of this amazing BI tool from Microsoft that enables you to build stunning interactive dashboards and share them on any device. If you want … Continue reading →

Rate this:

Posted in General | Tagged , | Leave a comment

The 5-minute Excel Dashboard Challenge @ Bacon Bits

Posted on February 5, 2017 by MF

Have you ever thought of building an Excel Dashboard in 5 minutes?  Yes, only 5 minutes. That’s why it is a Challenge!   You may find the details of The 5-minute Excel Challenge at Bacon Bits. Honestly, I haven’t thought … Continue reading →

Rate this:

Posted in General | Tagged | 5 Comments

Paste special with simple mathematic operation + – * /

Posted on February 4, 2017 by MF

Answer to the 5 little Tips (tests) – Part 3/5 The task: Doing simple calculation (add, subtract, multiply, divide) without formula Answer:  Copy and Paste Special…

Rate this:

Posted in Excel Tips | Tagged | Leave a comment