Learn Any Area of Excel using these 80 Links

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: Excel Formatting Tips How to use Excel Paste Special Features? Excel for Beginners [videos] Excel Keyboard Shortcuts Learn how to use Excel Ribbon [guide]	Train: • Excel School Online Training Program• Excel Formula Crash Course by Chandoo

Formulas
Learn: Introduction to Excel Formulas How to use IF Excel formula? Introduction to VLOOKUP Formula & more 15 Every Day Excel Formulas for you Excel Formula Examples, Tutorials & Downloads	Train: • Excel Formula Crash Course by Chandoo• Excel Formula e-book More • Imposing INDEX formula [Excel Hero]

Array Formulas
Learn: Introduction to SUMPRODUCT Formula Advanced SUMPRODUCT Formula Examples Introduction to SUMIFS Formula Array Formula Examples, Tutorials & More More articles on SUMPRODUCT Formula	Train: • Excel Formula Crash Course by Chandoo• Excel School Online Training Program More • Single Cell Array Formulas [About.com]• Multi-cell Array Formulas [About.com]

Formatting
Learn: How to Use Tables to Speed up Formatting of your Data Excel 2007 Productivity Tips & Secrets Custom Cell Formatting How to Make Better Excel Sheets More articles on Formatting Excel Workbooks	Train: • Excel School Online Training Program

Conditional Formatting
Learn: Excel Conditional Formatting Basics 5 Tips to become a Conditional Formatting Rock star Compare 2 lists using Conditional Formatting How to use Conditional Formatting in Excel 2010? More articles on Conditional Formatting	Train: • Excel School Online Training Program

Charting
Learn: How to select right chart for your data? Picking colors for your charts 73 Beautiful Excel Chart Templates Budget vs. Actual Charts – 14 Alternatives More articles on Charting	Train: • Excel School Online Training Program More • Excel Charting [Jon Peltier]

Advanced Charting
Learn: Show one chart from many – Dynamic Charts in Excel Waterfall charts in Excel In cell Panel Charts Dynamic Charts to Impress your Boss More on Dynamic charting	Train: • Excel School Online Training Program More • Advanced Charting [Excel Hero]

Tables
Learn: Introduction to Excel Tables Another Reason to use Excel Tables Dynamic Data Validation using Tables Dynamic Charts using Tables	Train: • Excel School Online Training Program

Pivot Tables & Charts
Learn: Introduction to Excel Pivot Tables Working with Pivot Tables [video] How to use Pivot Table Report Filters? Top 5 Pivot Table Tricks More on Excel Pivot Tables	Train: • Excel School Online Training Program More • Excel Pivot Tables [Contextures]• Pivot Table Fundamentals & More [Ozgrid]

Validation
Learn: How to add a Drop-down list in Excel? Copy validations from one cell to another Mix VLOOKUP with validation Advanced Data Validation Techniques

Data Tables
Learn: Introduction to Data Tables & Monte Carlo Simulations Analyzing Data using Data Tables

Solver
Learn: Introduction to Excel Solver Using Solver to assign items to Buckets Introduction to Excel’s Goal Seek functionality

Scenarios, What if analysis
Learn: Scenario Analysis for a Project Introduction to Data Tables & Monte Carlo Simulations Using Slicers to Switch Scenarios Displaying & Selecting a Scenario using VBA [Modeling in Excel]

Statistical Analysis (regression, time series etc.)
Learn: Trend lines & Forecasting in Excel – Part 1 Trend lines & Forecasting in Excel – Part 2 Trend lines & Forecasting in Excel – Part 3 Shuffling a list in Excel Introduction to Excel’s Random Functions

Dashboards
Learn: KPI Dashboards in Excel Sales Dashboards in Excel 33 Resources for Learning Dashboards Interactive Dashboards using Hyperlinks Sales Analysis Charts & Dashboards in Excel	Train: • Excel School Online Training Program• VBA Classes from Chandoo.org More • Dashboard Spy

VBA (Macros)
Learn: Introduction Excel VBA (Macros) – 5 part tutorial Introduction to Programming Get Stock Quotes in to Excel Converting Formulas using VBA More articles on VBA & Macros	Train: • VBA Classes from Chandoo.org More • VBA & Excel Macros [Excel Hero]

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.