Imagine you are in a life sustaining planet named Pearth, in another galaxy. One day you got to work, fired up Excel (hey, what else would you use? Excel is the best data software in any galaxy 🙂 ) and started working.

You came across a dataset that need sorting, but left to right – horizontally.

Now what? Do you turn your monitor sideways?

Its Easter time. At Chandoo.org, I have tradition of publishing Easter Egg hunts since 2009. This is the first time our Easter egg hunt is on Power BI. Changing times, eh?

We all know that VLOOKUP can find first match and return the results. But what if you want all the matches? Use this simple trick instead.

Let’s say you manage a fund or charity. You get money from various places and you use that money for various reasons. How do you tell the story of source vs. uses of funds? In this post, let’s review 14 charting options. Source vs. Use of funds – Sample Data for this problem Let’s say […]

Excel has hundreds of formulas. But as a new learner or user, you may want to just focus on top 10 formulas to get the most out of it. Assuming you already know the basics (check out Beginner Excel page if you are complete newbie), here is a list of top 10 Excel formulas for you.

If you want to tell the story of how your business / project / charity / thing is going on, then making a dashboard is the best way to go about it. Dashboards can combine heaps of data, insights and messages in to one concise format that fits on to a desktop or table or mobile screen.

But let’s be honest. Creating them in Excel is a lot of work. Even after spending hours on them, they might still look meh. So, let me share a trick to make your dashboards look snazzy (without compromising on insights per inch).

Create dashboard tiles, something like above.

Hiya folks… just a quick update on whats keeping me busy this year, with a bonus Excel tip at the end. Take a sip of your favorite brew and read on.