All articles with 'Learn Excel' Tag
Join Excel School & Become Awesome in Excel

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.
Continue »How to Embed Youtube videos in to Excel Workbooks?

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.

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
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]
![How to Filter Odd or Even Rows only? [Quick Tips]](https://chandoo.org/img/q/filtering-odd-or-even-rows-excel-howto-th.png)
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 »Excel Links – What are your plans for 2011?
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 […]
Continue »
This year has been hectic for Chandoo.org. We have posted 229 excel tips & articles this year. In addition, we had 6500+ comments & a lot of new pages on the website. We have also trained more than 700 students in Excel & Financial Modeling thru Excel School & Financial Modeling School programs.
In this post, I will share some of the best content on Chandoo.org in year 2010. Just read these posts to supercharge your excel skills.
Continue »11 Excel Trackers & Templates to help you Rock 2011

We are just a few days away from 2011. New year always brings hope, cheer, joy and revitalizes us. So naturally many of us embark on journeys with new goals, resolutions, things to do.
Naturally, Excel can help us better manage the new year. In this post, I am featuring 11 templates so that you can have a rocking 2011.
Continue »Use Filter By Selected Cell’s Value to save time [Quick Tips]
![Use Filter By Selected Cell’s Value to save time [Quick Tips]](https://img.chandoo.org/q/filter-by-selected-cells-value-excel-tip.png)
We are busy decorating the Christmas tree, making preparations for the holidays. But I have a very quick tip for you.
[Note: all these tips work in Excel 2007 or above]
Whenever you are working with huge lists of data, filtering & sorting is one simple way to analyze the data quickly.
You can quickly filter your data based on current cell’s value by right clicking and then selecting filter > filter by selected cell’s value.
Continue »How would you Visualize World Education Ranking Data [Homework + Video]
![How would you Visualize World Education Ranking Data [Homework + Video]](https://chandoo.org/img/vp/world-education-scores-excel-chart.png)
Here is a charting challenge to begin your Christmas week. Recently Guardian’s Data Blog released World Education Rankings data and a sample visualization. Now your challenge is to make your chart visualizing World Education Rankings data.
You can see the chart I have constructed above. Read the rest of the post to find out how I made this chart and download the workbook.
Post your submissions using comments.
Continue »![2011 Calendar – Excel Template [Downloads]](https://img.chandoo.org/c/2011-calendar-template-download.png)
Here is a 2011 new year gift to all our readers – a free 2011 calendar template.
(a little secret: just change the year in worksheet “Full” from 2011 to 2012 to get the next year’s calendar. It works all the way up to year 9999)
You can add notes to individual dates or complete month using the excel template very easily. There are 6 different calendar templates in the download file,
* 4 Yearly Calendar Templates with different color schemes.
* 1 Mini Calendar
* 1 Monthly Calendar (prints in 12 pages)
Go ahead and download the calendar files. Enjoy.
Continue »Do you use (or make) Excel Dashboards? Tell us about yourself to win a free training kit

(You can win my latest Excel Dashboard Training kit free, read this post to find out how.)
Over at Jorge’s ExcelCharts blog, he started a very good discussion on Excel Dashboards: Who needs them anyway?.
Jorge has very good experience designing, working on and teaching about dashboards. So he uses all that skill to gaze in to a crystal ball, to understand who needs excel dashboards and why. In this post, I build on his argument and ask you the big question – “If you make or use Excel Dashboards, who are you?”
Continue »6 Christmas Cards in Excel – Download and Spread Joy

Few days back, I have asked you to make a Christmas card in Excel (or any of your favorite festival’s card).
We got 6 entries for this contest. All the entries showed a lot of creativity to come up with beautiful cards using Excel. See the entries, download the excel files & find out who the winner is. Read the rest of this post.
Continue »Excel Links – Next Dashboard Contest Edition

Almost an year ago, we had a memorable dashboard contest on Sales Dashboards. We got 32 beautiful, outstanding, well crafted entries and it was a lot of fun learning new tricks & meeting new members of our community. I am planning to have one more dashboard contest and I need your help.
I need you to suggest a topic for the contest (optional: and give some sample data)
Just drop a comment with your suggestions (and point to source data if any). We will have a dashboard contest on one of those topics.
Read the rest of this post to get some useful Excel related links.
Continue »![Mutant Cell Modeling Problem [Homework]](https://chandoo.org/img/hw/mutation-of-cells-excel-formula-problem.png)
Today’s homework is inspired from an email I got from Simran, I have a mathematical problem, I do not know if it can be solved using excel. So, the question is what is the probability of selecting a mutant cell if the percentage of mutant in the whole population is 0.01 and each cell is […]
Continue »