# Archive for January, 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.

Continue »

## 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.

Continue »

## Worksheet Properties via a Menu

Published on Jan 25, 2011 in Excel Howtos, hacks, Huis, Posts by Hui

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.

Continue »

## 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.

Continue »

## 220 Excel Tips, Tutorials, Templates & Resources for You [Celebrating 20k RSS Members]

Published on Jan 20, 2011 in Charts and Graphs, Learn 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]
Recommended Resources [5 tips]

Continue »

## Find the Average of Closest 2 Numbers out of 3 [formula challenge]

Published on Jan 19, 2011 in Excel Howtos

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

Continue »

## Excel Links – My First International Excel Workshop Edition

Published on Jan 17, 2011 in excel links

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.

Continue »

## Happy Birthday Hui, An Excel Dashboard to prove you are awesome!

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.

Continue »

## Join Excel School & Become Awesome in Excel

Published on Jan 12, 2011 in Learn Excel, products

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.

Continue »

## How to Embed Youtube videos in to Excel Workbooks?

Published on Jan 11, 2011 in Excel Howtos

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.

Continue »

## Using Array Formulas to check if a list is sorted.

Published on Jan 7, 2011 in Excel Howtos

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

Continue »

## Do you want to Learn Excel? Consider Joining Excel School

Published on Jan 6, 2011 in Learn Excel, products

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.

Continue »

## How to Filter Odd or Even Rows only? [Quick Tips]

Published on Jan 5, 2011 in Excel Howtos

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.

Continue »