All articles with 'Learn Excel' Tag

This week’s poll is dead simple. Just tell me since how many years you are using Excel. I will go first: I have first started using Excel in year 2003 to keep track of my MBA entrance exam preparation. It helped me a lot in recording practice test scores, listing all the mistakes I made […]

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 […]

Sometime in November, I got an interesting E-mail from a gentleman named Guru. The title said “Excel Workshop in Maldives”. In the email, Guru introduced himself and asked me if I can come to Maldives to conduct few Excel workshops for companies and individuals.

I usually neglect such mails as many times the actual training (or big consulting assignment etc.) will not happen. So I replied to him giving my number and asked him to call me. I was surprised to receive his call. After talking awhile, it was clear that Guru is tenacious and would not take No for an answer.

So we set things in motion and thanks to Guru’s perseverance, I ended up boarding a flight to Male on 22nd of January. This is a story of what happened next…,

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.

This is a guest article by Matt, who works as a Business Analyst with allrecipes.com. He shares with us how he is using Excel to become a rockstar business analyst. In his own words,

“At Allrecipes.com we use excel for a variety of purposes. Analyzing site trends, forecasting traffic, charts, dashboards, and slide shows; you name it, we use excel for it. That’s why Chandoo’s tips have been so helpful – because we use excel every day. Thanks to chandoo.org, I’ve developed a reputation as an “excel wizard” and even taught a 4 week excel training class!“

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.

In the final post of the Are You Trendy? series we will look at the use of Excel Charts and associated Trendlines for trend analysis and I will give you a free tool (Normally valued at $200, I wish) which will allow interactive assessment of a Charts Trendline Y value for any X value.

Does your data hold hidden secrets?
In Part 2 of Are You Trendy? we will examine the Excel functions that assist us in Trend Analysis.

The Properties button on the Developer Tab in Excel 2007/10 can be used to access a number of Worksheet properties normally only available through VBA and even a few which aren’t available through VBA.
Lets take them for a spin.

Often you may have a set of data and need to know what an intermediate or future value of that data may be.
This week we will investigate 3 methods of tackling this problem using Excel.
In this post we’ll look at manual forecasting.

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]

Today I am asking you a tricky formula question. This is asked by Ionel on the Introduction to VLOOKUP, OFFSET & MATCH Formulas post. The question is, I have data in three columns: A,B,C and I want to get the average of the closest two values out of three in each row. Could you help […]

Stage is almost set for my first international Excel workshop. That is right. I am doing a physical excel workshop on Intermediate & Advanced Excel at Maldives between January 23 and 27, 2011. I feel quite excited to do this.

While I derive immense pleasure and learn lots of new things by running Excel School, there is one nagging problem. It is an online program, so the scope of physical interaction with students is limited.

Doing a physical class is a great way to meet new people, gather material for new content, get ideas, learn new things and get challenged. And that is why I am looking forward to do my workshop in Maldives next week.

If you would like to join this workshop: Please call Mr. Guru Raj, Training Manager at IIPD, Malè. His number is +960 7625338. (Workshop agenda)

Because I will be busy with the workshop next week, I will not be able to post much on the blog. I have requested Hui, our guest author to keep you all engaged. So expect some delicious stuff from him while I am away.