Interactive Pivot Table Calendar & Chart in Excel!
Can we make a calendar using Pivot Tables?!? Of course we can. Today let us learn a simple technique to create calendar style reports using Pivot tables. Thanks to Rob for inspiration Before making any progress, let me thank Rob from PowerPivotPro for the inspiration. Recently he wrote an article explaining how to use PowerPivot […]
One race, Every medalist ever – Interactive Excel Visualization
During London 2012 Olympics, Usain Bolt reached the 100mts finish line faster than anyone in just 9.63 seconds. Most of us would be still reading this paragraph before Mr. Bolt finished the race.
To put this in perspective, NY Times created a highly entertaining interactive visualization. Go ahead and check it out. I am sure you will love it.
So I wanted to create something similar in Excel. And here is what I came up with.
Visualize Excel salaries around world with these 66 Dashboards
Ladies & gentleman, put on your helmets. This is going to be mind-blowingly awesome.
See how many different ways are there to analyze Excel salary data. Look at these 66 fantastic, beautifully crafted dashboards and learn how to one up your dashboard awesomeness quotient.
Excel Links – Updates on Singapore Workshop Edition
It has been a while since we had an Excel Links post. So here we are.
First, I want to update you about our Singapore Workshop.
As you know, we have opened the registrations for this workshop last week. If you are in Singapore and want to attend an Excel & Financial Modeling Workshop, Please consider joining us on July 8- 10. For details & enrollment, visit Singapore Bootcamp page.
Apart from the Singapore workshop, I was busy last week conducting live training at CapGemini, in their Hyderabad office on Excel & Dashboards. It was a very good experience. I learned a lot about practical challenges people face when doing sales reports etc. using Excel.
Show Details On-demand in Excel [Tutorial + Training Program]
Yesterday, we have seen a beautiful example of how showing details (like distribution) on-demand can increase the effectiveness of your reports. Today, we will learn how to do the same in Excel.
220 Excel Tips, Tutorials, Templates & Resources for You [Celebrating 20k RSS Members]
I have an exciting news & massive post for you.
Chandoo.org reaches 20,156 RSS Subscriber mark on Jan 19, 2011As of Jan 19, 2011, our little blog has registered our 20,000th RSS Subscriber. While this is not a huge achievement or anything, It certainly calls for celebration. I am so happy to see our mission to make people awesome in Excel is reaching out to more people everyday. Thank you.
To celebrate this milestone, I am doing a massive post with 220 Excel tips, tricks, tutorials & templates.
Formulas [52 tips]
Formatting & Conditional Formatting [36 tips]
Charting [60 tips]
Tables & Pivot Tables [15 tips]
Using Excel [47 tips]
Free Downloads [5 tips]
Recommended Resources [5 tips]
A Technique for Analysing Large Tables of Data
Once you start using Excel to develop systems, budget, forecast and large tables of data you may come across the dilemma of “How do I know this is right” or “How do I truth check this”.
This post will add a tool to your arsenal to help you out.