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 other day I was gazing at a business metric (a line chart) and I felt the need to just select a part of the line chart and focus on what happened during that time frame.
So I fired up some geeky stuff in Excel and created a chart to do that exact thing! Let’s jump right into it! Interested ?Read More
Typical technical (Excel) interview happens like this
Alright Alright.. guess the next question
Today, I am going to take your VLOOKUP skills and make them more robust. Take a look at a short video [10 mins]Read More
Here are my top 5 charting hacks that have saved me a ton of time. They are incredibly simple and equally powerful!Read More
When I got bored with the old scroll-bar and their tricks, I thought of inventing a new one on my own. In this post I am going to share everything (including pros and cons), about making a customized scroll-bar in Excel.
Caution : This is a meaty post.
Recommendation : Sit with a latte and enjoy! 😀Read More
Line charts are most often drawn for time series analysis and it would be interesting to divide our line chart into phases. In this tutorial, I am going to show you how can you divide the line chart into phases.Read More