How to insert a blank column in pivot table?

How to insert a blank column in pivot table?

We all know pivot table functionality is a powerful & useful feature. But it comes with some quirks. For example, we cant insert a blank row or column inside pivot tables.

So today let me share a few ideas on how you can insert a blank column.

But first let’s try inserting a column

Imagine you are looking at a pivot table like above.

And you want to insert a column or row. Go ahead and try it.

Continue »

Excel Links – PASS BA 2015 Edition

PASS BA conference - 2015In about 3 days, I am leaving to USA for participating in PASS Business Analytics conference – 2015. It is an annual event for people in analytics profession. This is the first time I am attending & speaking at the event. I am so excited for many reasons.

  • I will be meeting many Excel bloggers, authors & internet friends for the first time
  • I will be meeting many of you (readers, listeners, followers & customers of Chandoo.org) too
  • I will be speaking at an awesome conference
  • I will be visiting San Francisco for the first time in life
  • I will be meeting a few college friends too

All this excitement means, I have too much going on. But that shouldn’t leave you out . So here are a few awesome Excel links for you. Check out and learn.

Continue »

CP033: There is an Easter egg in this podcast!!!

CP033: There is an Easter egg in this podcast!!!

http://traffic.libsyn.com/chandoo/CP033.mp3Podcast: Play in new window | DownloadSubscribe: iTunes | Android | RSSIn the 33rd session of Chandoo.org podcast, let’s turn the mic to our listeners and hear their tips. What is in this session? This session has 2 things. A surprise Easter egg (an Excel tip hidden in the podcast audio) Collection of Excel tips recorded […]

Continue »

CP032: Rules for making legendary column charts

CP032: Rules for making legendary column charts

In the 32nd session of Chandoo.org podcast, let’s make legendary column charts.

What is in this session?

Column charts are everywhere. As analysts, we are expected to create flawless, strikingly beautiful & insightful column charts all the time. Do you know the simple rules that can help you create legendary column charts?

That is our topic for this podcast session.

In this podcast, you will learn

  • Few personal announcements
  • Rule 0: Start at zero
  • Rule 1: Sort the chart
  • Rule 2: Slap a title on it
  • Rule 3: Axis + grid-lines vs. Lables
  • Rule 4: Moderate formatting
  • Conclusions
Continue »

Use apply names to create readable formulas [quick tip]

Use apply names to create readable formulas [quick tip]

We all know that using named ranges is a good practice. So you went ahead and created names for every value in your complex workbook. But now, what about those formulas which still refer to cells by their addresses? Here is a quick tip to make your formulas readable by replacing cell addresses with the names in one go.

Use Apply Names feature.

Continue »

Conditionally Format Chart Backgrounds

Conditionally Format Chart Backgrounds

Learn two techniques to conditionally format the background of a chart based on some external value.

Continue »

Formatting shortcuts for keyboard junkies

Formatting shortcuts for keyboard junkies

A lot of analysts swear strong allegiance to keyboard shortcuts. But when it comes to formatting a spreadsheet, these shortcuts go for a toss as formatting is a mouse-heavy activity.

But we can use a few simple & effective shortcuts to zip through various day to day formatting tasks. Let me share my favorite formatting shortcuts.

Continue »