All articles with 'Learn Excel' Tag

Details about our Financial Modeling Class

Published on Jul 18, 2011 in Financial Modeling

Hi there,

Do you know that Chandoo.org run an online training program on Financial Modeling & Project Finance Modeling?

So far, we have trained more than 200 students thru this program and now, I am excited to announce that from July 27th, you can join this course again.

Read this short post to understand how our program can benefit you.

Continue »

Create Dynamic Hyperlinks in Excel [Video]

Published on Jul 14, 2011 in Excel Howtos, Learn Excel
Create Dynamic Hyperlinks in Excel [Video]

During one my recent training programs, a participant asked an interesting question.

I have a list of values. I would like to place a hyperlink in my workbook that would always take me to the last value in the list.

Something like shown aside.

Click on the image to learn how this is done.

Continue »

NPV() function to calculate Present Value

Published on Jul 5, 2011 in Financial Modeling, Learn Excel
NPV() function to calculate Present Value

Today, let us learn how to use NPV() function in Excel & create a simple financial model.

If you are dealing with cash and valuations, you are bound to have come across the NPV function. If you don’t know the assumptions behind the same, I bet it could cost you your job!

Let’s take a simple project – You buy a MSFT stock for USD 100. You receive a dividend of USD 10 in the first year, USD 20 in the second year, USD 40 in the third year and then you sell it out for USD 140. If you could have alternatively put this money in bank at 10% interest rate, have you gained anything?

How do you model this in excel? In this tutorial we understand how you can use NPV to do this analysis and what kind of pitfalls you can land into!!

Continue »

Winners of the Sales Analysis Chart Contest + One more Giveaway

Published on Jul 1, 2011 in blogging, Charts and Graphs
Winners of the Sales Analysis Chart Contest + One more Giveaway

Our Sales Analysis Chart Contest is over and the winner is….,

Oh, wait!

I have decided to award the prize to 2 contestants. Each of them will get an Amazon Kindle Reading Device.

The winners are,

Continue »

Sales Analysis Charts in Excel – 78 Alternatives

Published on Jun 30, 2011 in Charts and Graphs, Excel Challenges, Learn Excel
Sales Analysis Charts in Excel – 78 Alternatives

Recently, I ran a contest asking you to analyze a bunch of sales data and present your results in charts. We received a total of 78 charts from 45 people. The contest entries had a mind-boggling variety of excel charts, techniques and ideas. It took me a while to go thru all the files and compile the results. Thanks for your patience. In this post, you can find all the charts along with my comments & links to download files.

Continue »

Excel Links – Updates on Singapore Workshop Edition

Published on Jun 27, 2011 in excel links

It has been a while since we had an Excel Links post. So here we are.

First, I want to update you about our Singapore Workshop.

As you know, we have opened the registrations for this workshop last week. If you are in Singapore and want to attend an Excel & Financial Modeling Workshop, Please consider joining us on July 8- 10. For details & enrollment, visit Singapore Bootcamp page.

Apart from the Singapore workshop, I was busy last week conducting live training at CapGemini, in their Hyderabad office on Excel & Dashboards. It was a very good experience. I learned a lot about practical challenges people face when doing sales reports etc. using Excel.

Continue »

Analyse Data like a Super Hero

Published on Jun 20, 2011 in Excel Howtos, Huis, Learn Excel, Posts by Hui
Analyse Data like a Super Hero

Can I automate 500 Columns of Data Analysis without VBA?

Absolutely!

Excel super function – Data Table to the rescue.

After reading this post, you will be able to process data like a Data Analysis Super Hero !

Continue »

Register for our Excel & Financial Modeling Bootcamp in Singapore [Details inside]

Published on Jun 16, 2011 in Financial Modeling, Training Programs
Register for our Excel & Financial Modeling Bootcamp in Singapore [Details inside]

Hello Friends & Readers,

Our Singapore Excel & Financial Modeling Boot-camp is ready for your consideration.

We will be conducting it from July 8th to 10th.

Please read this short page to know details about the program and how to enroll.

Who is this boot-camp for?

This boot-camp is aimed at business analysts, financial analysts & managers, who use Excel all the time. If you are an Excel new-bie, this boot-camp is not for you. Otherwise, you will enjoy this.

Continue »

Win Loss Chart from a Series of Win, Loss Data

Published on Jun 15, 2011 in Charts and Graphs
Win Loss Chart from a Series of Win, Loss Data

Last week, we learned how to create win-loss charts in Excel. In the comments, Dan said,

“Incidentally, the fastest way to do this would be using SFE, just reflect your data with 1 for a win, – 1 for a loss. There’s even an option to automatically invert negative numbers.”

Of course, we can use the beautiful Sparklines for Excel addin to do this and several other charts. But if you just have a series of Wins and Losses, like below, you can use a column chart to create win loss charts too.

Today, we will learn how to create a win loss chart from a set of win, loss data in Excel.

Continue »

Comparing Lists of Values in Excel using Array Formulas

Published on Jun 14, 2011 in Excel Howtos, Learn Excel
Comparing Lists of Values in Excel using Array Formulas

Last week, we had a home work on Calculating Donation Summaries using Excel Formulas. This is a good case where array formulas can help us. So today, we will learn how we can use Array Formulas to compare lists of values and calculate summaries. Towards the end of this post, you can see a video that explains the solution to Donation Summary Calculation problem.

Continue »

Amount Donated vs. Pledged [Excel Formula Homework]

Published on Jun 10, 2011 in Excel Challenges
Amount Donated vs. Pledged [Excel Formula Homework]

We have some home work folks! Today, lets test your Excel formula skills by giving some data related to a fund.

The problem:
You manage a fund for a non-profit. You have donors who pledge certain amount at the start of the year. As you go thru the year, the donors donate money to your fund. At the end of the year, you have a table like above. And you need to summarize the fund’s performance by calculating various statistics.

Go

Continue »

How to create a Win-Loss Chart in Excel? [Tutorial & Template]

Published on Jun 9, 2011 in Charts and Graphs
How to create a Win-Loss Chart in Excel? [Tutorial & Template]

Win Loss Charts are an interesting way to show a range of outcomes. Lets say, you have data like this:

win, win, win, loss, loss, win, win, loss, loss, win

The Win Loss chart would look like this:

Win Loss Charts in Excel - Template & Tutorial

Today, we will learn, how to create Win Loss Charts in Excel.

We will learn how to create Win Loss charts using Conditional Formatting and using In-cell Charts.

Continue »

10 Excel Formula Myths – Busted!

Published on Jun 7, 2011 in Learn Excel
10 Excel Formula Myths – Busted!

Many of us start using Excel to keep track of something. And along way, we realize that Excel has a powerful feature called formulas, using which we can automate a lot of things. BOOM! Before we realize, we are in the thick of VLOOKUPs and SUMIFs.

But, along way, we also pick up a few bad habits or believe a few myths. Today, lets bust 10 Excel formula myths that we hear often.

Read this post to learn what these myths and why you should not trust them.

Continue »

Do you want to attend an Excel Workshop in Singapore? [Survey]

Published on Jun 3, 2011 in Financial Modeling, Training Programs
Do you want to attend an Excel Workshop in Singapore? [Survey]

I have happy news for you.

Paramdeep (from Financial Modeling School) and I am going to organize an Excel Workshop in Singapore during first (or second) week of July.

We want to know if you are interested in this. So please take a few minutes and go thru this small post.

Who is this workshop for?

If you are a financial or business analyst, this workshop is for you. We will be discussing various Excel & Financial Modeling topics during the 12 hour workshop (spread across 2-3 days)

Continue »

Switch Scenarios Dynamically using Slicers

Published on Jun 1, 2011 in Pivot Tables & Charts
Switch Scenarios Dynamically using Slicers

Slicers are my new favorite feature in Excel. Introduced in Excel 2010, Slicers are like visual filters.

Now, we can use slicers creatively to make an interactive scenario manager in Excel, as you can see below. We will learn how to create this in Excel in today’s post.

Continue »