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 post is about the RAND and the RANDBETWEEN functions of Excel and how can we play with these to
There will be a lot more things that you can generate randomly after you read this post. Let’s get going!Read More
Recently in a casual web browsing (a.k.a time wasting) session I came across an article on how the Indian Tech Start-Ups are bleeding money. The article also accompanied some basic data on revenues and losses.
Chandeep speaking to himself : “I should try making a cool graph / visualization from it”
The next day, a friend of mine was spamming (read sharing on) my facebook wall the same post
Chandeep speaking to himself again : “I should definitely try making a cool graph / visualization from it”
I got to work!Read More
Today we have a guest in the house. Please welcome, Puneet Gogia from ExcelChamps and he is going to teach us, 5 methods to remove duplicates in Excel.
Enters Puneet –
While working with large data sets, duplicate values are always a problem
No matter what, you will always get some duplicate values in your data. But the good news is, in Excel, you can find them, highlight them, and delete them in no time. Today, I will show you 5 effortless methods to figure out duplicates value in Excel.
So let’s get started.Read More
When you create a chart with multiple data points, showing data labels for all the values can make the chart quite cluttered and busy. What you can do instead is add or remove data labels of the chart with a click
Let’s see how can we make this work..Read More
Last week one our readers asked me to share the most important financial modeling shortcuts that I think can tremendously increase the efficiency and accuracy while making financial models
Although I was just asked to share 10 shortcuts but I thought of making a video (to discuss about 30 shortcuts) and show you where and how exactly do I use these shortcuts to speed up my work while creating financial models
Just to make the learning structured, I divided the shortcuts in 4 main phases of financial modeling
Let’s dive right into this… and this is not just restricted to financial modelers, there are a lot of tips and tricks that a regular excel user can also pick upRead More