Learn Any Area of Excel using these 80 Links
Last week I asked, What is one area of Excel you want to learn more?
More than 250 of you responded to this question. Many of you shared your areas of interest thru comments, quite a few of you also emailed me personally.
So what next?
You told us what you want to learn, the next step is logical. We share some of the best tutorials & examples with you so that you can learn. In this post, we have presented more than 75 links, to help you learn your area of focus.
I have divided this in to 16 areas. In each area, we have identified (upto) 5 best links for you to learn more. I have also recommended 1 or 2 training programs that make you awesome in that area. Plus, if we found any excellent external resources, we have highlighted them as well.
So go ahead and learn Excel.
Using Excel 

Learn: 
Formulas 

Learn: 
Array Formulas 

Learn: 
Formatting 

Learn: 
Train: 
Conditional Formatting 

Learn: 
Train: 
Charting 

Learn: 
Train: More 
Advanced Charting 

Learn: 
Train: 
Tables 

Learn: 
Train: 
Pivot Tables & Charts 

Learn: 
Train: 
Validation 

Learn: 
Data Tables 

Learn: 
Solver 

Learn: 
Scenarios, What if analysis 

Learn: 
Statistical Analysis (regression, time series etc.) 

Learn: 
Dashboards 

Learn: 
More 
VBA (Macros) 

Learn: 
Train: 
Share your links
If you come across any good resource for learning Excel, please share it with us. I am always looking for ways to learn more. So go ahead and drop a comment.
Thanks to Hui
Special thanks to Hui, for compiling the survey results & some of the links.
 

Leave a Reply
Formula Forensics No. 005 – Zebras and CheckerBoards  Shortcut for Long Models 
23 Responses to “Learn Any Area of Excel using these 80 Links”
Very many thanks Chandoo. This is superb work. I had been struggling to create something similar with bookmarks for the past 2 weeks. It was slow going and not nearly as useful or definitive as this.
I am continually amazed by your commitment and generosity. For free, not only do you provide a fantastic facility, you now also give the wouldbe student a concise study plan for everything they could ever want.
Just so you know, it was the quality of your free material which gave me the confidence to sign up to your video classes  I immediately learnt several techniques just by watching you use Excel in the first lesson!
You are truly one in a million.
I completely agree with Leon, I just keep coming back for more,
Thanks a lot
BEAUTIFUL COMPILATION.... really appreciable job done. Thx so much fro sharing these links with all of us đź™‚
Fabulous job!!!
This will going to be One of the most visiting page for me for sure.
Already have forwarded to all of my friends groups.
Thanks a lot Chandoo & friends
Really nice work. Simply amazing to see all the things compiled at one place. Kudos to you..
This is really a nice work!
Please review my video also: http://www.youtube.com/watch?v=8Qii4eN9bwo
Excellent compilation Chandoo! And Hui!
Now we have a lot of reading to do!
Great work!
This really is pretty fantastic. Hats off
@All.. thank you so much for your love. I am glad you like this.
[...] If you want to learn Excel, but not pay, check out these 80 links. Tons of information, examples & awesome tricks to be [...]
Chandoo you are the man! I passed this out to my coworkers and now they finally know that you are the true Jedi behind my skills! You have a place to stay in California any time you visit!
[...] Here’s a fantastic post from Chandoo, a prolific Excel blogger that I follow: http://chandoo.org/wp/2011/12/12/learnexcelbytopic/ [...]
Hello Mr. Chandoo!
My Belated Xmas greetings & Advance Happy New Year â€“ 2012 to You! and all your family members & friends! Thus far, your journey is AWESOME! Wow! youâ€™re really a Special breed for a specific purpose!
With regards.
Hello Mr. Chandoo!
My Belated Xmas greetings & Advance Happy New Year â€“ 2012 to You! and all your family members & friends! Thus far, your journey is AWESOME! Wow! youâ€™re really a Special breed for a specific purpose! I wanna give you smart picks for your New year Jackpot!
With regards.
Lottomaniac649:)
[...] Learn Any Area of Excel – 80 Links for you 12,045 [...]
[...] For Excel, I suggest going thru our archives, category pages on Excel, Charting, Quick Tips, or the Learn any area of Excel [...]
[...] Los que hayan leĂdo hasta el final, se llevan de regalo, un recurso muy chulo para aprender excel [...]
Google Translate: Those who have read to the end, take a gift, a very cool resource to learn excel
Best ever I had seen !
Favolus
Many thanks for Chandoo. I am trying to translate your free examples to Chinese. and shared with my Friends!
Chandoo your wor is simply amazing.Thanks a ton for it!
Great post đź™‚ thanks
just found this site, still looking for time to explore it.huh.....
Excellent, very thorough, going to my favorites.