Chandoo.org - Learn Excel, Power BI, Charting, Dashboards and VBA online

Latest Tips & Tutorials

How the tax burden has changed over the years – Excellent chart by NYTimes & Redoing it in Excel

If I need some charting inspiration, I always visit New York Times. Their interactive visualizations are some of the best you can find anywhere. Clear, beautifully crafted and powerful. Long time readers of Chandoo.org knew that I like to learn from visualizations in NY Times & redo them using Excel.

Today let me present you one such chart. This is based on an interactive visualization prepared by NY Times explaining how the tax burden has changed over years for various income groups.

Take a look at tax burden chart – Excel implementation
Tax burden over years chart - recreated in Excel

Read on to learn how to create this chart using Excel.

Read This »

December 6, 2012

Formula Forensics No. 032 – Creating Dynamic Charts with Non-Contiguous Data

There are many web pages devoted to Excel Charts and there are many web pages devoted to Creating Dynamic Ranges, but a lot of these suffer when the data is poorly organised or non-contiguous.

Today we look at a Technique for Creating Dynamic Charts with Non-Contiguous Data.

Read This »

December 4, 2012

Become Awesome in Excel while saving money

Hi Folks,

The moment you are waiting for is here. Our 2012 Holiday SALE is now on.

If you are ready, Just visit Holiday SALE page.

To know more read on…,

What is on sale?

Two of our most popular, awesome & valuable courses are on sale.

Excel School & Dashboards program – Save $30
Excel School, VBA & Dashboards program – Save $50

Our customers from India save Rs 1,200 & Rs 2,000 respectively.

Read This »

December 3, 2012

Chandoo.org Holiday SALE, Starts on Monday – 3rd December!

Here is a quick announcement folks!

Many of you asked me whether we are going to have a holiday sale at Chandoo.org this year. Of course we have a sale!

Details of Chandoo.org Holiday Sale – 2012

Dates of the sale – 3rd & 4th December, 2012 (Monday, Tuesday)

What is on sale?

This year, you can save up to $50 on our best selling training courses.

Course: Excel School Dashboards program
- Discount: $30
Course: Excel School + VBA + Dashboards program
- Discount: $50

Read This »

November 30, 2012

Macros for Automatically Implementing Modeling Best Practices

In the first part on our Modeling Best Practices series, we learned 5 best practices to follow. This article shows how to automatically implement the best practices using macros.

Read This »

November 29, 2012

Extract data using Advanced Filter and VBA

In this post we will learn how to use the Advanced Filter option using VBA to allow us to filter our data on a separate sheet. This has been requested by a lot of our readers and here is how we will use them.

Read This »

November 27, 2012

Excel Links – Lets meet in Chennai this Sunday edition

Hi readers… I am in Chennai this week, conducting in-house training at Renault Nissan on Advanced Excel. As I am busy teaching Excel & making

Read This »

November 26, 2012

Financial Ratios – Cappuccino or Latte?

A Quick Question for you!
Don the hat of a financial wiz today. What I have for you are the financials of two companies: Cappuccino and Latte – Two dot com companies (Sometimes they also make revenues ;-))

Which is better – Cappuccino or Latte? ( Hint: It’s a trick question! 😉 )

It may seem obvious that Latte is performing better (Higher the revenue, the better the performance!). Sometimes a single source of data does not speak the full story!

Read This »

November 21, 2012