All articles with 'Learn Excel' Tag

What is VLOOKUP Formula & How to use it? [VLOOKUP WEEK]

Published on Nov 1, 2010 in Learn Excel
What is VLOOKUP Formula & How to use it? [VLOOKUP WEEK]

I often tell my excel school students that learning VLOOKUP formulas will change your basic approach towards data. You will suddenly feel that you have discovered a superman cape in your attic. It is that awesome.
What does VLOOKUP really do?

Imagine you have a list of data and you want answer a question like, “How many sales did Jimmy make?”

VLOOKUP is one of the formulas you can use in this situation. VLOOKUP searches a list for a value in left most column and returns corresponding value from adjacent columns.

Continue »

Celebrating the Lookup Formulas – VLOOKUP Week @ Chandoo.org

Published on Nov 1, 2010 in blogging, Learn Excel
Celebrating the Lookup Formulas – VLOOKUP Week @ Chandoo.org

Hi all,

Few weeks back, I had a mild internet outage. Since I didn’t know what to do, I turned to you for help and asked you to share “VLOOKUP tips” while I get my connection back.

Oh boy!, the response to that has been overwhelming. More than 50 comments were posted, each with unique, fabulous uses of VLOOKUP & Other lookup formulas.

VLOOKUP is such an important formula that, I cannot imagine preparing a dashboard, report or any other data intensive workbook without using it a few times. So, to celebrate the versatility and usefulness of this beautiful formula (and other lookup formulas) we are going to call this as VLOOKUP week @ chandoo.org.

Continue »

What is the last visible cell in your excel window? [Poll]

Published on Oct 29, 2010 in Learn Excel
What is the last visible cell in your excel window? [Poll]

This is a fun and quick poll.

I want to know what is the maximum number of cells you can see when you open Excel. Do this:

  1. Open Excel, Maximize the window if it is not.
  2. Just tell me the bottom right cell that you can see completely.
  3. Go have a good weekend :)
Continue »

Hiding Error Messages – Quick Tip

Published on Oct 28, 2010 in Excel Howtos
Hiding Error Messages – Quick Tip

I like to leave certain error messages in place because they can show you what your data is doing, but they look horrible when you print out reports. This will show you an alternative method for dealing with error messages.

Continue »

Financial Modeling School Closing in a Few Hours – Join Now!

Published on Oct 27, 2010 in Financial Modeling
Financial Modeling School Closing in a Few Hours – Join Now!

I have a quick announcement for you.

As you may know, I am running an Online Financial Modeling Training Program called as Financial Modeling School in collaboration with Pristine Education. We have opened registrations for first batch of this program on October 18th. Thank you very much for supporting this program wildly. In a few hours, I will be closing the registrations for Financial Modeling School.

Click here to sign up for Financial Modeling School

Continue »

How to make a Birthday Reminder in Excel ? [Video]

Published on Oct 26, 2010 in Excel Howtos

Learn how to create a birthday reminder worksheet in excel in this video post. You can also download a template to keep track of upcoming birthdays and anniversaries.

Continue »

Analyze Competition with Scatter Plots – A business chart example

Published on Oct 25, 2010 in Charts and Graphs
Analyze Competition with Scatter Plots – A business chart example

Analyzing competition is one of the key aspects of running a business. In this article, learn how to use Excel’s scatter plots to understand competition, like shown aside.

The inspiration for this comes from a recent article on Asymco analyzing mobile handset market (Apple iPhone, Nokia etc.) and how it has changed since 2007.

Read the rest of the post to learn how to create this type of chart in excel. Also, you can download the chart template. Go ahead.

Continue »

FREE Excel Financial Model for Analyzing an IPO – Download Today

Published on Oct 22, 2010 in Financial Modeling

Lets keep this quick and short, As some of you may know, There is a mega IPO (initial public offering) going on in India these days. It is for a company called Coal India Ltd. So my partners at Pristine Education thought, it would be cool to build a financial model analyzing the IPO. Click […]

Continue »

Excel Links – Happy Birthday Edition

Published on Oct 20, 2010 in excel links

First some personal matters. Today I am celebrating my 28th birthday. The last one year has been very good for us. We have been very busy parenting 2 hilarious and naughty twins, I moved back to India, quit my job and started a company. My business became a mild success crossing $100k revenues in 12 […]

Continue »

Learn an Excel Feature: Picture Links (or Camera Snapshots)

Published on Oct 19, 2010 in Excel Howtos, Learn Excel
Learn an Excel Feature: Picture Links (or Camera Snapshots)

Today I want to introduce a new excel feature to you, called as Picture link.

Well, picture links are not really new, they are called as camera snapshots in earlier versions. They provide a live snapshot of a range of cells to you in an image. So that you can move the image, resize it, position it wherever you want and when the source cells change, the picture gets updated, immediately.

Continue »

Financial Modeling School is now Open – Register today!

Published on Oct 18, 2010 in Financial Modeling

Hi all,

A very quick announcement. We have opened Financial Modeling School for registrations now. Click here to learn more about the program and sign-up.

You get $100 discount if you are one of the first 100 students to sign-up. So go ahead and enroll today.

Continue »

Are you a Solver Virgin? Watch this tutorial video …,

Published on Oct 15, 2010 in Featured, Learn Excel

Do you ever think about questions like this?
1) What is the maximum profit we can make?
2) What is the best way to schedule employees in shifts?
3) What the best combination of tasks we can finish in a given time?

You might have heard about Excel Solver tool while trying to find solutions to questions above. If you have never used Solver or have little idea about it, then this post and video are for you.

Continue »

Financial Modeling School Coming on Monday [Details Inside]

Published on Oct 14, 2010 in Financial Modeling, products
Financial Modeling School Coming on Monday [Details Inside]

Financial modeling is a no catwalk. You can not look pretty, wear ridiculous outfits and expect to find if a project is worth investing money in. That is why I am very happy to announce Financial Modeling School.

Please read this short post to learn more about the program.

Continue »

Insert Currency Symbols & Other Special Characters in Excel [Quick Tip]

Published on Oct 11, 2010 in Excel Howtos
Insert Currency Symbols & Other Special Characters in Excel [Quick Tip]

Often, we need to input special symbols like €£¥©½» in to our Excel sheets. Now, how do we do that? Simple, you can use Insert > Symbol to add several different kinds of symbols. See this animation to understand how you can add symbols to an excel cell. (the file is kind of big, so […]

Continue »

Finding 2nd Largest Item in a List that meets a Criteria [Excel Array Formulas]

Published on Oct 8, 2010 in Learn Excel
Finding 2nd Largest Item in a List that meets a Criteria [Excel Array Formulas]

Excel Array Formulas have subtle beauty and raw power. Today I want to share how you can use Excel Array Formulas to find-out the 2nd largest sale amount corresponding to a particular product.

Lets say you have sales data like this:
Now, we all know that, to get 2nd largest sale amount, we can use the LARGE() formula. Like this: =LARGE(RANGE,2)

But, how do we know what is the 2nd largest sale amount for the product “bricks”?

Continue »