All articles in 'Learn Excel' Category

2013 Calendar – Excel Template [Downloads]

Published on Dec 26, 2012 in Learn Excel
2013 Calendar – Excel Template [Downloads]

Here is a New year gift to all our readers – free 2013 Excel Calendar 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 »

Excel Links – Lets meet in Chennai this Sunday edition

Published on Nov 26, 2012 in excel links

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 young graduates awesome in it, I will not be able to write much on the blog. But don’t worry. We have some great articles coming up from Hui & other […]

Continue »

Please help me design our new product: Vitamin XL

Published on Oct 19, 2012 in Learn Excel, products
Please help me design our new product: Vitamin XL

Hello friends, fans & well wishers of Chandoo.org,

I am happy to announce about our new product – Vitamin XL, a membership program for you. I want to make sure that Vitamin XL offers you the best possible features & value. I need your help in designing this product. Please read this short article and give me your feedback.
What is Vitamin XL?
Just like vitamins you give you strength and health, Vitamin XL ups your Excel mojo, gives you new ideas & powers. Here is what I have in mind:

Vitamin XL is a membership program with 3 distinct benefits

  1. Excel Training
  2. Excel Resources
  3. Excel user community
Continue »

Excel Formatting Tips – Gangnam Style [open thread]

Published on Oct 5, 2012 in Learn Excel
Excel Formatting Tips – Gangnam Style [open thread]

Ever seen a glaring, over the top, wow-I-am-sooo-cool type of spreadsheet? Lets call them Gangnam spreadsheets!

Gangnam what?!?

If you have never heard about Gangnam style, do not worry. Just like you I too was living under a rock for about a week ago. Then I watched the awesome Gangnam style song. And now I am hooked. You can see it here.

What has all this got to do with Excel?
Oh I am coming to the point. One of the key ingredients of being awesome in Excel is,

To make our Excel workbooks communicate best by avoiding over the top formatting, unnecessary bells & whistles and focusing on what our users want.

But Excel being a feature rich software, it does have various so called Gangnam styles – superfluous 3d effects, formatting options, charting choices and as such.

Today, lets talk Excel formatting – Gangnam style

Continue »

18.2 Tips on Rounding numbers using Excel Formulas

Published on Sep 28, 2012 in Excel Howtos, Learn Excel
18.2 Tips on Rounding numbers using Excel Formulas

Lets talk round numbers today.I have 18.2 tips for you on round numbers.

We can use a variety of formulas to round numbers in Excel depending on the situation. We have ROUND, ROUNDUP, ROUNDDOWN, MROUND, INT, TRUNC, CEILING, FLOOR, FIXED, EVEN, ODD and few more. To know how to use all these formulas and how to round numbers based on any criteria, just read on.

Continue »

Introducing Excel School + Excel Hero Academy Bundle

Published on Sep 25, 2012 in Learn Excel, products

Hello friends & Chandoo.org readers,

I am super-excited to announce an my first joint Excel course with none other than Excel Hero – Daniel Ferry. For the the first time, you get basic, intermediate, advanced & super-advanced Excel + VBA course in one neat package.

I am happy to present Excel School + Excel Hero Academy course bundle for your consideration.

What is this course bundle & How it can help you?

Simply put, this course package is designed to make you 2x awesome in Excel, VBA & Dashboards. Please watch below video to understand how our course can help you.

Excel School plus EHA bundle Introduction

Continue »

OFFSET formula – Explained

Published on Sep 17, 2012 in Learn Excel
OFFSET formula – Explained

Today, lets learn OFFSET formula.
OFFSET formula gives us reference to a range, from a given starting point with given height and width in cells.

OFFSET formula syntax
OFFSET formula looks like this:
=OFFSET(starting point, rows to move, columns to move, height, width)

Starting point: This is a cell or range from which you want to offset
Rows & columns to move: How many rows & columns you want to move the starting point. Both of these can be positive, negative or zero. More on this below.
Height & width: This is the size of range you want to return. For ex. 4,3 would give you a range with 4 cells tall & 3 cells wide.

Read on…,

Continue »

Excel Links – Going to Togo Edition

Published on Sep 4, 2012 in excel links

After a long time, I am writing one more Excel links post. First let me share a quick personal update.

I am invited to Lome, Togo to spend a day at Ecobank – CFO conference in 3rd week of September. I will be conducting a one day masterclass on Advanced Excel & Dashboard Reporting. I am excited about this trip as I have never been to any African country. I will post some pics and tell you how it went once I am done with the conference.

Moving on to Excel Links for today,

Continue »

Growing a Money Mustache using Excel [for fun]

Published on Aug 22, 2012 in Charts and Graphs, Learn Excel
Growing a Money Mustache using Excel [for fun]

Mustache and Excel?!? Sounds as unlikely as 3D pie charts & Peltier. But I have a story to tell. So grab a cup of coffee and follow me.

Today, lets talk about how to construct a dynamic chart that can show us how much progress we have made against a financial goal (in this case, accumulating a big chunk of money). I call this growing mustache chart, inspired from the wonderful Mr. Money Mustache.

Continue »

Making your dashboards interactive [Dashboard Essentials]

Published on Aug 2, 2012 in Charts and Graphs, Excel Howtos, Learn Excel
Making your dashboards interactive [Dashboard Essentials]

Everyone likes to be in control. Even my 2 year old daughter jumps with joy when she lays her hands on TV remote. She pushes the buttons and assumes it is working. It is another story that we rarely watch TV at home.

By adding an element of control, we can make our dashboard reports fun. Interactive elements like form controls, slicers etc. invite users to play with your dashboard, get involved and understand data by asking questions. That is why I recommend making dashboards interactive.

Today lets understand how you can make dashboards interactive.

Continue »

Welcome to Chandoo.org – A short introduction to our site

Published on Jul 27, 2012 in blogging, Learn Excel
Welcome to Chandoo.org – A short introduction to our site

Welcome to Chandoo.org. Thank you so much for taking time to visit us.

Over the last few weeks, we have quite a few new members to the site. Its good time I said hello and introduced this site to you.

PS: If you have been following chandoo.org for a while, you can still find useful information in this post. So read on.

Continue »

How do you explain Excel to a small kid? [poll]

Published on Jul 13, 2012 in Learn Excel
How do you explain Excel to a small kid? [poll]

When I was in Perth, I visited Hui’s house one day. Lovely, Hui’s daughter (who is about 14) asked Hui how he knew me. So Hui told that we both share a passion for Excel and that;s how we got to know each other. Then she asked, What is Excel?

At this point, we both tried to explain what Excel is to her in a few ways with no success. Later Hui came up with a brilliant explanation.

He said, Excel has lots of small calculators all interconnected, so that you can do any sort of calculation.

So here is a challenge for you. How would you explain Excel to a small kid (computer literate, but not yet in college).

Continue »

Find the last date of an activity

Published on Jul 3, 2012 in Formula Forensics, Learn Excel
Find the last date of an activity

We know that using VLOOKUP, we can find a value corresponding to a given item. For example Sales of x. But what if you have multiple sales for each item and you want the last value?

Today lets understand how to find the last date of an activity, given data like above.

Like everything else in Excel, there are multiple ways to finding last date. If cats can use computers, they would hate Excel. You see, Excel is overflowing with unlimited ways to skin a cat.

Continue »

How to make a Spoke Chart

How to make a Spoke Chart

Have you ever wanted to make your own Custom Chart type ?
MarnieB was asked by her boss to make a Spoke Chart !

This post will explain how you can make a custom Excel Spoke Chart and introduce you to techniques that can be used to make other custom chart types.

Continue »

Check if a list has duplicate numbers [Quick tip]

Published on Jun 28, 2012 in Excel Howtos, Learn Excel
Check if a list has duplicate numbers [Quick tip]

A while ago (well more than 3 years ago), I wrote about an array formula based technique to check if a list of values have any duplicates in them.

Today, lets learn a simpler formula to check if a list has duplicate numbers.

Assuming you have some numbers in a range B4:B10 as shown below, we can use MODE + COUNTIF formulas to check if there are any duplicate values in a list.

Continue »