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.














7 Responses to “Build models & dashboards faster with Watch Window”
yes, I use watches in excel vb
Dear Chandoo,
This is a quite useful for myself. I highly appreciate your efforts for acquainting us with this value adding and time saving tip.
I'll admit it, I never saw this feature before. I was familiar with using Watch Window in VB, but not in workbook. I'll definitely use this in future when building dashboards!
it was always great reading your blog, one thing that i want to know, which tool you are using to create such gif image?
it was also a nice post,,,,,, sir
Hello Sir,
Really very nice post. I didn't use this features in past. But now going to use it..
Thanks a lot for every time come up with something new..
Thanks
Very Nice post sir.
Every Time posting something new.. Thanks a lot