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.
4 Responses to “How windy is Wellington? – Using Power Query to gather wind data from web”
Breaking - Wind jokes at Chandoo
Kiwis sniffing for clues about blog post reason
It's confirmed: Wellington is windier than Uranus.
Acompanhando e aguardando ansiosamente a segunda parte.
[]s.
[Google translate]: Accompanying and eagerly awaiting the second part
hi chandoo,
i've tried using power query, however i face a rather weird problem. when i click on 'from web' option, the URL window does not show option for basic and advanced. thus i'm unable to form parameters in URL. how i can resolve this issue?