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
If you are a person who has to make a lot of presentations (by choice or by force) then you can relate to the ordeal. I mean the time that it takes to format a presentation is crazy. And all of that goes in vain if you get to hear this from your boss: “This is not good, do it again”. All that time sucking pain in the ass effort has to be repeated.
I am going to share with you some personal customization techniques that I have made in PowerPoint that help me work a hell lot faster while formatting / creating a presentation. They are simple to implement and quick to learn..Read More
This is a one odd problem that I was asked that how can we find occurrence of a word in a sentence. A simple formula can do it..
Let’s see howRead More
The word ‘Class Interval‘ takes me back to the math class in school. Trust me, I had a tough time understanding Class Intervals and Frequency Distribution jargons. Several years later (now) when I finally believe I have understood its meaning and application, I want to keep it really simple for you and talk about 3 different ways to create it in Excel
All English and no Jargons.. promise!Read More
Quite often we have to get rid of background patches in the images that we use in our presentations. Let’s take an example of Goodly logo with a white background patch visible when placed on a grey box. Is there a way to remove that patch and have a clean logo?
Of course there is and I am going to be sharing 2 ways to do it..Read More
In Part 2 of Infograhic Charts, I’ll share with you to create this interesting infograhic in Excel. Here we have a single human icon, which dynamically gets filled depending on the value chosen in the drop down
Here is how it is created..Read More