Friends and supporters of Chandoo.org,
I am very happy to tell you about another great way to learn Excel & stay awesome
That is right. As part our mission to make you awesome in Excel, this year I will be adding a podcast.Continue »
I have a quick announcement for you.
Only few hours left to join Power Pivot course…
As you may know, I have opened enrollments for our Power Pivot course few days ago. The aim of this course is to make you awesome in Excel, Advanced Excel, Dashboards, Power Pivot & Advanced Power Pivot.
We will be closing the doors of advanced Power Pivot & Bundled options at midnight, today – 11:59 PM, Pacific time, Friday, 21st of February.
If you want to join us, click here and enroll now.Continue »
Today lets take a stroll outside what Excel can do and make something fancy, fun and may be useful.
Nowadays, many newspapers, websites and magazines are featuring info-graphics. An info-graphic is a collection of shiny, colorful & data-full charts (or often pieces of text.) In many of these info-graphics, you can see threaded-donut charts. Not sure what that is..? It is not same as the blasphemy of spoiling a soft, sweet, supple donut with a piece of string. No one should be excused for an offense like that.
What I am talking about is shown aboveContinue »
Let me interrupt the flow of awesome Excel stuff to share about our ongoing Power Pivot class enrollments.
We opened the class last Monday (10th of February) and every day lots of people are joining the army of awesome Power Pivot analysts.Continue »
Gantt charts are a very popular way to visually depict project plans. Today, let us learn how to use Excel to make quick & easy Project Plan Gantt Chart.
This is what we will be creating.Continue »
Today lets talk about how to build world-class dashboards.
What is a dashboard?
Dashboard reports allow managers to get high-level overview of the business and help them make quick decisions. A dashboard is usually a one page report that contains critical information for decision support.
How to make dashboards?
Excel is an excellent tool to make powerful dashboards that can provide analysis, insight and alert managers in timely manner. But creating a dashboard takes a lot of skill & practice. That is where a resource like Chandoo.org comes handy. In this site you can find more than 200 different dashboard examples, tutorials, samples and downloads – all designed to make you awesome.
Read on to learn more…Continue »
Dynamic dropdowns are a handy way to get your users to make choices based on what they’ve previously chosen, while steering them away from making invalid choices. Today we’re going to look at one that easily handles multiple levels, and we’ll take a look at what could go wrong. Let’s see one in action, shall […]Continue »