I do consulting and training on MS Excel, Business Intelligence Dashboards,
Business Plans / Financial Models and PowerPoint Presentations
I am putting together everything about Excel and PowerPoint Presentations
that I have learnt (and still learning) on this blog
The reason why I call this as a Threshold Chart is because the lower point can only be equal to the threshold and not exceed it!
Although I am using Asset Depreciation Data for this chart but a threshold chart can be applied to multiple places. I’ll talk about its applications in a bit more detail in a while… but first the chartRead More
I am sure you would have worked with the text boxes in Word or PowerPoint or even Excel but the trick I am going to share with you will make the text boxes dynamic.. in simple terms the text can change as per the situation
The applications of this technique in Dashboards, Charts and Visualizations is pretty helpfulRead More
Last week I received an email and this is what it said..
This mail got me thinking of writing something exclusively on (how tos about) Dashboards. Just out of curiosity, I additionally reached out to a few people and asked them their biggest challenge for making quick and smart dashboard.
2 major responses popped up!
So now I understand the problem. In this post I am going to solve both these problems and teach you to make simple and yet powerful dashboards in just 15 mins. And the good part is that the concept will apply on most data setsRead More
Very often while making a complex dashboard you would find yourself using multiple slicers to slice and dice the data in multiple ways. But the only drawback could be managing space to fit all of them on the screen!
Let’s see a smart work around for thatRead More
Yesterday I wrote a pretty comprehensive post on creating slicers in Pivot Tables. Taking our understanding on slicers a bit further, I today want to talk about formatting slicers.
Now even the default design of the slicers look pretty catchy but when you see the insane possibilities of customizing the looks of the slicer, default formatting becomes a no – no
In this post I am going to talk in detail about