Chandoo.org - Learn Excel, Power BI, Charting, Dashboards and VBA online

Latest Tips & Tutorials

My trip to Maldives…, [travelogue + bonus Excel tip]

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…,

Read This »

February 4, 2011

A Huge Collection of Spreadsheets for Teachers [What Excel Can Do]

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

I’ve been developing & have published spreadsheet applications for teachers for some time now. In particular, I have animations, adventure scenarios etc that can be used to create games for the classroom. I need to promote these so teachers eventually try these and use them. … Perhaps you could post some of these on your site.

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.

Read This »

February 3, 2011

How do Business Analysts use Excel [Guest Post from a Rock-star BA]

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!“

Read This »

February 2, 2011

Holiday Request Form in Excel [Awesome Ways our Readers are using Excel]

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.

Read This »

February 1, 2011

Are You Trendy ? (Part 3)

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.

Read This »

January 27, 2011

Are You Trendy? (Part 2)

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.

Read This »

January 26, 2011

Worksheet Properties via a Menu

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.

Read This »

January 25, 2011

Are You Trendy ?

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.

Read This »

January 24, 2011