All articles with 'downloads' Tag

Last Friday, we have learned about an interesting formula – IFERROR Formula using which you can easily handle errors in Excel workbooks.

Quite a few people reading that page asked, “Wow, this is good. But how can I take a sheet full of =IF(ISERROR(…)….) formulas and convert them to =IFERROR()”

There is a different set of folks who asked “Wow, this is good. But quite a few of my colleagues use Excel 2003 and they see a bunch of #NAME errors when I send them an excel workbook with IFERROR formulas. Any help?!?”

I am pleased to announce that I wrote 2 simple macros, iferror2iserror() and iserror2iferror() that would scan formulas in a bunch of selected cells and convert them from IFERROR to ISERROR and vice-a-versa.

We have a new series on chandoo.org. – Excel Challenges. From now, every 1-2 months, I will post an interesting Excel Challenge. These are tricky problems for which elegant solutions should be found. To keep the challenges exciting, we will have a small prize for a winner (if more people answer correctly, we pick one randomly)

Excel Challenge #1 – Find Overlaps in Machine Schedule Dates

We have an Excel Table, with the following data (snapshot above). You need to write formulas to display Ok or Not Ok in the adjacent column based on the following criteria:

1. Display Ok if the scheduling dates for that row do not overlap with remaining scheduling dates for that machine
2. Display Not Ok otherwise.

I have a quick announcement for you.
As you may know, we have re-opened registrations for our 2nd batch of Financial Modeling School on Feb 23rd. We will be closing the doors for new students tonight at 11:59 pacific time. Thank you so much for supporting this program enthusiastically.

If you wish to join Financial Modeling School, click here.

Our of curiosity and fun I asked you “how long have you been using Excel?”. I was overwhelmed by the response we got to this simple question. More than 437 people responded with their comments, stories and enthusiastic responses. Thank you so much.

It would taken me more time to make the charts and understand the data. But thanks to Hui, who volunteered to tabulate all the survey data in a simple CSV.

Shown above is a chart I came up with based on the data. Read the rest of the post to understand the survey results and view more charts. Also, you can download the excel workbooks and original data set to play.

The folks at Washington Post made an interesting chart to understand whether winning a Grammy award makes any difference to album sales. Go ahead and browse it if you have not already seen it. Go, I will wait.

Are you impressed?

I really liked this chart. This is what I liked about the chart,

• It tells a story.
• It is an ego chart. We would all instantly search for our favorite artists and learn about how Grammy award changed their album sales.
• It is a simple chart. No clutter, no gaudy colors, just a bunch of lines and the story is out there.
• It lets you play.

In fact, I liked the chart so much that I wanted to make it in Excel.. You can see a snapshot of what I came up with above. Read the rest of this article to learn more.

We are opening Financial Modeling School for 2nd batch of classes on 23rd February. It feels very exciting to re-run this successful program. I want to share a few details about the program so that those of you interested to join can know more about it.

Please read this short post to learn 10 things about the financial modeling school program.

Transferring data regularly between Excel and Word for the production of Word based forms or reports cab be tedious if it involves much more than a few numbers.
This post looks at a technique for automating this process.

In the second part of our series on project finance using Excel, Paramdeep tells us how to model “interest during construction” in real estate and construction type of projects. We take a case of hospital construction and learn how to calculate the IDC using circular references.

You can also download both blank and completed model so that you can test the skills.

It is not too sunny here, but I am going to put on my business man hat. At the end of each month, I ask myself if my business (chandoo.org that is) has performed better or worse. One simple way is to look at previous month’s numbers and then I know how good the latest […]

This is a guest post written by Paramdeep from Pristine. Chandoo.org runs Financial Modeling School program in partnership with Pristine Careers. Visit Financial Modeling School to learn more and sign-up for our newsletter.

Greetings!

It’s been long time since we interacted on Chandoo.org. Actually I was very busy teaching the 105 awesome students for financial modeling in Excel. We all worked together to create some easy and some complex financial models. I found the journey to be quite exciting and enriching (From the feedback that I got, my students too didn’t find it bad either 😉 )

During the interaction, I found that a lot of students were looking for financial modeling around the project financing as well. So we thought why not introduce financial modeling for project finance.

In this post I will speak about some of the key aspects of a project finance model and why it can be different from modeling a normal company.

Last week we saw a really cool holiday request form made by Theodor. This week, we will learn how to combine conditional formatting and data validation to create an awesome data entry form. First see a demo to understand what I mean: How to create such a data entry form? Very simple, just grab a […]

Way back in November, I received this email from Tom, a senior researcher at the Center for Learning Innovation in Australia.

What a noble cause, I thought. So I wrote back to him and invited him to share his files along with a guest article. Tom acted quick and emailed me his article and Excel workbooks by Thanksgiving day. I was too lazy and got lost in the flow of things. But now, I am very very glad to feature his work.

There are so many valuable tricks, ideas and powerful concepts buried in his workbook. I encourage everyone to play with his file (you need to enable macros) so that you can learn a thing or two. If you are a teacher, feel free to use the files to make your classroom teaching even more awesome.

Theodor, one of our readers, first emailed me in December asking a question. But he also made a promise to share some of his techniques with us thru Guest posts. Naturally, I was too happy and invited him to share a file or two so that I can use them for articles here.

Later during Christmas holidays, he sent me this beautiful Holiday Request Form made using Excel.

I have an exciting news & massive post for you.

Chandoo.org reaches 20,156 RSS Subscriber mark on Jan 19, 2011As of Jan 19, 2011, our little blog has registered our 20,000th RSS Subscriber. While this is not a huge achievement or anything, It certainly calls for celebration. I am so happy to see our mission to make people awesome in Excel is reaching out to more people everyday. Thank you.

To celebrate this milestone, I am doing a massive post with 220 Excel tips, tricks, tutorials & templates.

Formulas [52 tips]
Formatting & Conditional Formatting [36 tips]
Charting [60 tips]
Tables & Pivot Tables [15 tips]
Using Excel [47 tips]
Free Downloads [5 tips]
Recommended Resources [5 tips]

Some of you know our guest author and Excel ninja Hui. Yesterday was his birthday. And I wanted to create nice birthday gift for him. So I took a database dump of our forums data and created a dashboard.

Read rest of this post to see the dashboard & download workbook.