When NOT to record a macro in Excel
Repetitive activity? Record a macro. Right? WRONG! Find out why…
Repetitive activity? Record a macro. Right? WRONG! Find out why…
This is a series of articles about people like me who deliver demos, conduct workshops and speak at keynotes. I will share what I have learnt about delivering high-impact demos
This article explains some confusing options in a “Special” Paste Special dialog. Estimated reading time 3min.
Everyone needs to reset formatting every once in a while. But do you know all the available methods? I was myself surprised when I started writing this article! Estimated reading
Earlier we saw how to create a Power View based dashboard. How to show this in PowerPoint? A better question is – WHY show it using PowerPoint? Estimated reading time
In this article, we will explore more benefits of using Power View in comparison with Pivot Table. Estimated reading time 12 min
In the previous article, we saw how to draw many pie charts quickly using Power View. Let us try that using Pivot Table. Estimated reading time 4 min
This is not just a catchy title. It actually happens. Read on to find out the secret. Requires Excel 2013 Professional Edition. Estimated reading time 4 min Practice 5 min
OneNote linked notes are easy to create. But how do you manage these linked notes later? Here is an easy way to do it. Estimated reading time 3 min
Yes. You use Pivot Tables everyday. Now it is time to find out the real power and nuances. 5.5 hours video, exercises, samples, Q&A.
Learn Power BI using the concepts you already know in Excel. Fast transition, in-depth coverage and immediately usable.
