Archive for January, 2011

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.

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.

Friends & Readers of Chandoo.org, I am excited to announce that Excel School, my online excel & dashboard training program is now available for your consideration. Please take a minute to read this post.

What is Excel School & Who Should join?

Excel School an online Excel & Dashboards training program. It is designed to make you awesome by teaching formulas, charting, formatting, data analysis & dashboards.

If you use Excel everyday and find my site useful & helpful, then this is a perfect program for you.

I have trained more than 700 students in this program so far and many of them have benefited tremendously. I am hoping you too will benefit from Excel School.

If you want to join Excel School, click here.

Often, while creating a complex model or dashboard, you may want to include additional training material in the workbook. So let us learn how to embed flash movies, Youtube videos etc. in to Excel workbooks.

To Embed Flash Movies, Youtube Videos in to Excel, follow these steps.

Today, we will learn an interesting array formula trick to test if a list is sorted or not. During last one week, I got 2 requests from different clients for some excel related work. Both of them had one thing in common. To test whether a list is sorted or not. So I got thinking, […]

As you may know, I run an online Excel training program called as Excel School. So far, I have conducted 3 batches of Excel School training and now on January 12th I am opening registrations again for new students.

In this post, I am going to share few important details about the program and give 3 FREE lessons to you. Read on, if you are interested to learn Excel.

Ashish sends out this SOS thru email, “I need your help in putting filters . Can we filter the cells on the basis of their even or odd character. i.e in the table of 1-1000, i wish to filter, 1,3,5,7,…”

An odd request, I must say. But nevertheless, possible in Excel.

Read this quick tip, If you want know how to filter odd or even rows only in a list of values.

Wish you a happy new year and Welcome back to Chandoo.org. So how did you celebrate the new year’s eve? We put the kids to sleep early and partied till 1. Next day, we took them to a park. The kids loved grass, trees and ran like wind. What about you? As for the new […]