All articles with 'Learn Excel' Tag

Multiplying 24ft 9inches with 6ft 3inches using Excel

Published on Apr 14, 2014 in Excel Howtos
Multiplying 24ft 9inches with 6ft 3inches using Excel

Imagine you are a carpenter and you are tasked with laying wooden floor at Gill Bates’ house. Now Gill B has a very big house and he wants to make sure you do a good job. So instead of asking you to lay the floor for entire house, he asks you to finish flooring in the guest bedroom first. Here are the dimensions of that guest bedroom.

  • Width: 6ft 3inches
  • Length: 24ft 9inches
  • Size of individual wooden floor board: 2ft x 4inches

And here is the big question you are facing.

What?!? the guest bedroom width is only 6ft 3inches?

But over the years of chiseling and polishing you have learned to keep quiet and do your work.

So the real question you have is, How many wooden floor boards should you buy?

Of course, you want to find the answer using Excel. Why else would a carpenter read this blog?

Continue »

Excel for iPad – Demo & Introduction [video]

Published on Apr 11, 2014 in Excel on iPad
Excel for iPad – Demo & Introduction [video]

Recently Microsoft has launched Excel app for iPad. Being an Excel addict, I could hardly wait to test it. And this is what we get.

Excel App for iPad – What is it?

Several years after iPad launch, Microsoft finally created apps for Word, Power Point, One Note & Excel. The Excel app is a miniature version of Excel on your iPad. It is capable of displaying almost all Excel workbooks with ease. You can even create your own workbooks using the app.

Continue »

Visualize state to state migration data and you could win an iPad or Galaxy Tab [Datavis Contest 2014]

Published on Apr 9, 2014 in Excel Challenges
Visualize state to state migration data and you could win an iPad or Galaxy Tab [Datavis Contest 2014]

Time for another dashboard contest. Sit straight, set aside your appointments and get number-crunching.

Analyze state to state migration data between 2012 & 2010 and present your results in a dashboard (or charts) and you could walk away with glory, fame & and an iPad.

If all of this sounds tempting, read on.

The contest

  1. Download dataset for the contest [mirror]
  2. Analyze the data and create a dashboard or set of charts (see rules below)
  3. Submit your workbook by 20th of April (Sunday), 2014.
  4. If readers at chandoo.org and our panel of judges love your work, you get one of the cool prizes.
Continue »

Calculate maximum change [homework]

Published on Mar 21, 2014 in Formula Challenges
Calculate maximum change [homework]

Today, lets see how good your formula skills are.

Calculate maximum change

Can you calculate what is the maximum change in product sales between 2 months for above data?

Continue »

Free Invoice Template using Excel – Download

Published on Mar 19, 2014 in excel apps, Learn Excel
Free Invoice Template using Excel – Download

Anyone running a small business knows the oozing bits of joy when you hear a customer saying, “Can you send me an invoice?”

While creating an invoice is an easy task, if you want something that is professional looking, easy to manage and works well, then you are stuck.

That is where Excel really shines. By using an invoice template, you can quickly create and send invoices.

Today I want to share one such template with you all. Why? Because we are awesome like that.

Continue »

CP002: VTALKUP – 5 Excel lookup functions demystified + 4 Resources for you

Published on Mar 13, 2014 in Chandoo.org Podcast Sessions
CP002: VTALKUP – 5 Excel lookup functions demystified + 4 Resources for you

In the second session of Chandoo.org Podcast, We will be learning how to use 5 Excel lookup functions.

What is in this session?
In this session, we tackle one of the most important areas of Excel. The lookup functions.

You will learn,

  • Why lookup functions are necessary
  • 5 Important lookup functions in Excel – VLOOKUP, HLOOKUP, LOOKUP, MATCH & INDEX
  • When & how to use each of these 5 functions?
  • Extreme scenarios:
    • What happens when the value you are looking up is not there?
    • What if too many items match the lookup value?
    • What if you have too many conditions in the lookup criteria?
  • Using IFERROR function
  • Re-cap of the new powers you acquired
  • 4 Resources for you to learn lookup functions better
Continue »

CP 001: Chandoo.org Podcast First Episode – Introduction, What to expect, Show formalities & Special gift

Published on Mar 6, 2014 in Chandoo.org Podcast Sessions
CP 001: Chandoo.org Podcast First Episode – Introduction, What to expect, Show formalities & Special gift

Chandoo.org Podcast is here….

Friends, fans & supporters of Chandoo.org,

I am so happy to add another dimension to our website. Chandoo.org podcast is finally here. You can listen to the inaugural episode by using the audio player above.

Continue »

Chandoo.org Podcast: Launching on March 6th

Published on Mar 4, 2014 in Learn Excel
Chandoo.org Podcast: Launching on March 6th

Hi folks,

I am super-excited to tell you that Chandoo.org Podcast will be launching on 6th of March (Thursday). First episode is already recorded and I am getting ready for the big launch.

Name of the podcast

Last week I asked you what should we call our podcast. And I got more than 250 suggestions (150+ thru comments another 100 thru email). While the suggestions ranged from funny (chanpoo, addict.xls) to word plays (Excelent cast, Lord of the cells, Speaking Cells) to outright brilliant (XL.AM remember AM radio?). Some of the suggestions were crazy too: Word on the sheet, YouChandooIt, Didasko.xlsx – greek word “to impart knowledge”.

Thanks everyone for the ideas and suggestions.

A majority of you suggested that we call it Chandoo.org Podcast. This keeps the name generic, sticks to our brand and sets us apart. So that is what we will call it.

The full name of the show is Chandoo.org Podcast – Become Awesome in Data Analysis, Charting, Dashboards & VBA using Excel

And our first episode will be launched on Thursday, 6th of March.

Continue »

Can you extract first name & last name from email address? [Formula Challenge]

Published on Feb 27, 2014 in Excel Challenges
Can you extract first name & last name from email address? [Formula Challenge]

Today lets rescue John Doe from John_doe@email.com.

Extract first & last name from email address

Given an email address in the format

firstnameany_non-alphabet.characterslastname@email.com

You need to extract first name & last name using formulas.

Continue »

What should we call our Podcast?

Published on Feb 24, 2014 in Learn Excel
What should we call our Podcast?

Friends and supporters of Chandoo.org,

I am very happy to tell you about another great way to learn Excel & stay awesome

Chandoo.org podcast

That is right. As part our mission to make you awesome in Excel, this year I will be adding a podcast.

Continue »

I won’t eat donut with a thread inside, but lets make one anyway!

Published on Feb 20, 2014 in Charts and Graphs
I won’t eat donut with a thread inside, but lets make one anyway!

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 above

Continue »

Quick and easy Gantt chart using Excel [templates]

Published on Feb 18, 2014 in Charts and Graphs, Learn Excel
Quick and easy Gantt chart using Excel [templates]

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 »

What is your favorite Excel book? [open thread]

Published on Feb 7, 2014 in Learn Excel
What is your favorite Excel book? [open thread]

Today lets talk about Excel books. The question is simple.

What is your favorite Excel book? Please share your answers using comments.

My favorite books are..,

Continue »

How to select a random sample from all your data [trick]

Published on Jan 31, 2014 in Excel Howtos
How to select a random sample from all your data [trick]

The other day, I got a text message (SMS) from one of our readers. It read,

So today, let us learn a very easy trick to select random sample from your data.

Continue »

Did Jeff just chart?

Did Jeff just chart?

How do you segment customers by revenue easily in Excel, so that you can see which customer groups to focus on. Find out, and download this handy template.

In this charting example, Jeff, our guest author, occasional charter and Excel wizard shows us how to segment customers based on revenue and depict the result using Excel charts.

Continue »