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
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
I am going to start writing about slicers assuming that you don’t know about them at all and then graduate you to more complex nitty gritties of slicers.
Slicers happen to be one of the most interactive and simple to use features in excel. Let’s begin with the basic question..Read More
I thought of recording a quick video for a random chat and show you around my workplace. Since we may or may not have met, just wanted to say a quick HI 😉Read More
With the default sorting option you can sort the data (text, numbers, dates etc..) in ascending/ descending or alphabetical order but what if you want to have your own sorting criteria?
In that case Custom Sorting comes to rescue, this little trick can help you save countless hours of manual work
Let’s check it outRead More