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.
5 Responses to “Show more of your workbook on screens [quick tip]”
In 2013 you can also add to the QAT the hidden command "Toggle Full Screen View".
Instead of using the shortcut CTRL+F1, I prefer just to double-click one of the tab names (ie double-click the "Home" text on the Home tab) to enable the Ribbon Outline view. To return to the normal Ribbon state, just double-click your mouse again!
press Ctrl+Shift+F1, you will get a full screen
Instead of Ctrl + F1, I use Ctrl + Shift + F1 (Excel 2016)
Alt W E sequence for full screen
ESC to get back