All articles in 'Learn Excel' Category

We, adults can’t escape three things:

1. Deadlines
2. Demanding bosses (replace with customers or nagging spouses or naughty kids)
3. Taxes

While I can’t help you with demanding bosses or taxes, when it comes to deadlines, I have the right tool for you.

A tracker that highlights all overdue items so that you know where to focus your attention.

Let’s learn how to use awesome powers of Excel to find-out which items are due. You can apply these concepts to nail down over due invoices, pending project tasks or scheduling workforce.

Hi folks,

I am excited to announce Awesome August. It is a month-long effort to make you awesome in various aspects of Excel.

Awesome August… What is it?

For each and every day of August 2015, I am going to publish a new piece of content – an Excel tip, a formula technique, a charting solution or a productivity booster. 31 days – 31 pieces of awesome content.

Sounds Yummy? Participate in Awesome August:

There are 4 ways to participate in Awesome August

1. Sign-up to Chandoo.org newsletter. Get weekly emails with links to all the Awesome August content.
2. Comment & Win: Comment on any of the Awesome August posts. 31 random commenters will each get $31 Amazon gift-card.
3. Follow Awesome August in social media – on twitter, facebook, youtube and iTunes
4. Ask your friends & colleagues to participate. Send them to Chandoo.org/AwesomeAugust

On Wednesday (15th July), I ran my first ever webinar, on a topic called, “How to be a BETTER Analyst?” (here is the replay link, in case you missed it).  It was a huge success. More than 1,100 people attend the live webinar and hundreds more watched the replay. As part of the webinar, we had interactive Q&A. Viewers posted their questions and I replied to as many of them as I can.

After the webinar, I wanted to make sure I covered all the questions. So I downloaded the chat history. There were more than 700 messages in it. And I am not in the mood to read line by line to find-out the questions. A good portion of chat messages were not questions but stuff like ‘hello everyone, I am from Idaho’, ‘Wow, Chandoo has beard!”, “Enjoying a beer in Belgium while watching webinar” etc. So I wanted a quick way to flag the messages as question or not.

Analyst’s life is busy. We have to gather data, clean it up, analyze it, dig the stories buried in it, present them, convince our bosses about the truth, gather more evidence, run tests, simulations or scenarios, share more insights, grab a cup of coffee and start all over again with a different problem.

So today let me share with you 25 shortcuts, productivity hacks and tricks to help you be even more awesome.

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.

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.

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

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.

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.

In 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.

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.

Yay, bring out the birthday hats, candles, cake & confetti. Chandoo.org 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 hello@chandoo.org
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 Chandoo.org podcast.

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.

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.

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

As Chandoo.org 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