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
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
The source of inspiration for this chart came when Shuttershock was charging me for downloading a similar infographic chart. I din’t buy, I am thrifty 😉 It helped me save a couple of bucks and also come up with a way to make an infographic chart in Excel
Let’s do this together! Shall we?Read More