All articles in 'Learn Excel' Category

What is the coolest thing you made with Excel? [weekend poll]

Published on Jul 3, 2015 in Learn Excel

It is almost weekend. I am sure most of you have plans (if you are USA, wish you happy 4th of July). As for me, I am going on a 80KM (50 mile) bicycle trip to a nearby lake to watch birds on Saturday morning. On Sunday, we (kids & I) are planning to make a scrapbook from our Australian experiences.

So let me keep this nice & simple.

What is the coolest thing you made with Excel?

Go ahead and share your answers in the comments area.

Continue »

15 Quick & powerful ways to analyze business data

Published on Jul 1, 2015 in Analytics, Charts and Graphs, Learn Excel
15 Quick & powerful ways to analyze business data

Here is a situation all too familiar.

You are looking at a spreadsheet full of data. You need to analyze and tell a story about it. You have little time. You don’t know where to start.

Today let me share 15 quick, simple & very powerful ways to analyze business data. Ready? Let’s get started.

Continue »

Introduction to Slicers – What are they, how to use them, tips, advanced techniques & interactive reports using Excel Slicers

Published on Jun 24, 2015 in Learn Excel, Pivot Tables & Charts
Introduction to Slicers – What are they, how to use them, tips, advanced techniques & interactive reports using Excel Slicers

Slicers are one of my favorite feature in Excel. And here is a quick demo to show why they are my favorite.

Slicers – what are they?

Slicers are visual filters. Using a slicer, you can filter your data (or pivot table, pivot chart) by clicking on the type of data you want.

For example, let’s say you are looking at sales by customer profession in a pivot report. And you want to see how the sales are for a particular region. There are 2 options for you do drill down to an individual region level.

  1. Add region as report filter and filter for the region you want.
  2. Add a slicer on region and click on the region you want.

With a report filter (or any other filter), you will have to click several times to pick one store. With slicers, it is a matter of simple click.

Read more to learn all about slicers

Continue »

Use Paste Special to multiply (or add, divide etc.) a range with a variable [quick tip]

Published on Jun 16, 2015 in Excel Howtos, Learn Excel
Use Paste Special to multiply (or add, divide etc.) a range with a variable [quick tip]

Here is a fun way to use Paste Special to quickly multiply everything in a range with 1.1 (why 1.1? Well, imagine you have a report with everything in US $s and your boss wants to see the numbers in Australian $s…)

Since your report has different formulas for each cell, you can’t multiply first cell with a rate variable and drag it down. You have to manually edit each formula and add *rate at the end of it.

Oh wait…, you can use Paste Special.

Continue »

How to insert a blank column in pivot table?

Published on Apr 16, 2015 in Excel Howtos, Learn Excel
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

Published on Apr 14, 2015 in excel links

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 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 »

Formatting shortcuts for keyboard junkies

Published on Mar 17, 2015 in Charts and Graphs, Keyboard Shortcuts, Learn Excel
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 »

Share your favorite Excel tip & you could win Beats Headphones [Podcast Anniversary Celebrations]

Published on Mar 13, 2015 in Learn Excel

Yay, bring out the birthday hats, candles, cake & confetti. podcast is 1 year old.

In this one year, we had 31 sessions, 4 guest appearances, 390,000 downloads & lots of 5 star reviews. Thank you so much for making it a grand success so far.

To celebrate the occasion, I want to reward 3 lucky listeners of our podcast.

How to participate in this contest?

  1. Simple. Figure out what your favorite Excel tip is.
  2. Open your smart phone’s voice recorder app
    1. on iPhone use the Voice Memos app
    2. on Andriod use sVoice or voice recorder widgets
    3. If you cant find these apps, just Google record audio <your phone name>
  3. Record the tip (less than 3 mins duration)
  4. Please say your name at the end of recording.
  5. Send the audio file by email to
  6. Do so before end of day 16 March 2015 (Monday)

Once I collect all the tips, I will feature some of them in next episode of podcast.

Continue »

Please join 50 ways to analyze data course to become an awesome analyst

Published on Feb 11, 2015 in Charts and Graphs, Learn Excel, Training Programs

Hi friends & readers of

I am very happy to invite you to our newest online class, 50 ways to analyze your data. This program is aimed to make you an awesome analyst, training you on vital skills like data analysis, visualization of outputs, modeling business problems and finding best solutions.

Please click here to know more about this program & enroll.


What is this course?

50 Ways to analyze your data - an online course from to make you a better analyst

It is the age of big data. Alas, we need big insights. But finding even small insights buried in our data is a hard task. To find the stories hidden in your data, you need to follow a process like this:

  1. Collect & clean data
  2. Structure the data
  3. Model business problems
  4. Analyze the data (or solve the problem)
  5. Visualize results
  6. Find conclusions
  7. Add layers of complexity to the problem
  8. Build what-if scenarios
  9. Reach conclusions
  10. Take action

This is where the 50 ways to analyze your data course. In this program, we analyze 50 familiar, important and diverse business situations using several of the above steps.

My goal is to make you say “YES” every-time your boss asks “Can you analyze this data and tell me what is going on?”

Continue »

2 Must watch Excel webinars for you

Published on Feb 2, 2015 in Learn Excel, Training Programs

PASS BA 2015 - Excel webinars from Chandoo

Just a quick announcement.

As you may know, I will be speaking at PASS Business Analytics conference in Santa Clara this April (between 20th & 22nd). As a run up to the event, the good folks at PASS are conducting free webinars on various topics of Excel.

Here are 2 topics on which I am doing webinars. You can watch them and pick up some really cool Excel skills. Just click on below links to enjoy them.

  1. 5 Dashboard mistakes to avoid (watch it any time)
  2. Excel charting – productivity tips (live on February 3rd)

That is all for now. See you in the webinar.

Continue »

3 Course Meal of Excel Awesomeness for You

Published on Jan 21, 2015 in Learn Excel, Training Programs
3 Course Meal of Excel Awesomeness for You

If you are an Excel enthusiast, here is a feast for you.

Just a small glitch, it is a not feast you enjoy with mouth, it is a feast you consume with eyes, ears & mind.

It gives me immense pleasure to invite you to this feast.

Continue »

How can I help you become awesome this year?

Published on Jan 16, 2015 in Learn Excel

A little late to the party, but nevertheless right on track.

As starts another year of making you awesome, I want to take a few minutes of your time to understand how I can help you better this year?

Please answer this 1 question survey for me.
If you do not see the form below, please click here

Continue »

8 Reasons you must get better at Excel in 2015

Published on Jan 12, 2015 in Learn Excel
8 Reasons you must get better at Excel in 2015

This is a guest post by Sohail Anwar

Why do so many of us use Excel? Let’s trace it back to the ’80s when Microsoft hit gold by being the first out of the blocks with the widely available operating system that was somewhat dummy proof.

Suddenly everyone could aspire to launch ‘Nukes’ like a fresh faced Matthew Broderick in the film ‘War Games’. 

By the early 90’s Windows had become even more established relative to other Operating Systems, so much so that PC manufacturers were developing components around Windows’ capabilities and suddenly PCs were Windows machines. As big business began accepting the significance of computing, Microsoft started winning huge licensing contracts with all the major corporations in all sectors, but the Finance sector in particular, where Excel would be king, was having an exponential boom at this time. For big organisations, once you spent a fortune buying licences for the Operating System it only made sense to purchase the seamlessly integrated and carefully developed/tested apps to run on them; enter Excel, Word, PowerPoint and eventually Outlook. Fast forward to 2015 and we are firmly in the age of second generation corporate professionals who have developed much of their productivity skill sets around those particular Windows tools. While all the excellent tools have their place, Excel stands out and here are 8 reasons why you need to up your Excel game more than ever this year.

Continue »

Free 2015 Calendar, daily planner templates [download]

Published on Jan 2, 2015 in Learn Excel

Here is a New year gift to all our readers – free 2015 Excel Calendar & daily planner Template.


This calender has,

  • One page full calendar with notes, in 4 different color schemes
  • Daily event planner & tracker
  • 1 Mini calendar
  • Monthly calendar (prints to 12 pages)
  • Works for any year, just change year in Full tab.
Continue »

Best of – 2014

Published on Dec 31, 2014 in blogging, Learn Excel
Best of – 2014

2014 has been the busiest year since starting Wow, that is 11 years of breaking previous records. Thank you. In 2014, we published 128 posts (up 27% YoY), received 6,000+ comments (down 19%). Our forum had 8,700+ new members, 6,650 new threads and more than 42,000 posts in 2014. This year, I have also launched podcast. […]

Continue »