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
Taking a total of cells in Excel is what everyone knows how to do it. But that simple Sum Function can be used in many intriguing ways and for various purposes
Today I have 10 such tricks for you! Check out how many are new for you!Read More
I mean how cool is that if you could just filter the data by cell selection instead of relentlessly checking and un-checking options in the the filter drop down
Well today’s blog post is going to make your life a hell lot easy!Read More
A while ago, Chandoo wrote me an email, stating that we have won the Visualization Contest that was held in June this year! His email caused sweaty palms, spike in heart rate and obviously extreme elation!Read More
This post is an advanced application of the previously written posts on
If you have not read the above 2 posts I strongly recommend reading them before you dive into thisRead More
While applying VLOOKUP on large data (let’s say 100k rows or more) you often get beaten down by extremely slow spreadsheets or even sometimes by this sweet notification..
Yeah I know we say all types expletives.. #$%k me!, Oh Jeez..
One of the other ways to speedup is to use PowerPivot (which is heavenly!!) but lets say for some reason you still have not made a transition to PowerBI suite in that case let’s together explore this little trick..
The incredible part is that it is insanely simple!Read More