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
Line charts are used to depict trends across time. It is quite useful (and equally cool) to add a total bubble at the end of the line chart. Let’s see how that can be done
The other day I encountered (and solved 😎 ) a creative problem while making interdependent drop downs in a dashboard. If one Item has been chosen in the first list then it should not appear in the second list and vice versa !!
Check it out.. it is pretty cool !!
–> Let’s say we have six salesmenRead More
Today let’s talk about some real quick and amazing formatting tricks to make your data look more presentable and I have 5 of them for you here! Enjoy 🙂Read More
Let’s play a game today! Open your excel sheet and I will ask you to do some tasks, If you do it, you’ll get a point else I’ll get one. OK ready with your excel ? 😛Read More
Do you pray that your VLOOKUP formula should work ? 😯 Let me rescue you from the top 3 common mistakes while writing VLOOKUP function and save our prayers for more crucial things in life!! 😆Read More