- Official Excel support: Every formula and function is explained
- Official getting started guide
- thespreadsheetguru.com: Very good site. Also for VBA
- Excel-Easy.com
- INDEX / MATCH: One lookup to rule them all.
- INDEX / MATCH Examples: Seriously if I see one more VLookup i'm going to hit someone.
- XLOOKUP: Only works on newer Excel versions but can be used for quick lookps. Separare Index/Match is still superior in speed when pulling multiple values from the same row.
Should be the Preferred way to store data, if the count of entries is variable. You can Slice, Dice, and Reference them in a Structured way. Also they integrate perfectly with PivotTables.
Management friendly interactive tables and charts
Automate All the things.
- cpearson.com: is the most complete VBA Source I know. Sadly the Author passed away in 2018. Rest in Peace Chip!
- docs.microsoft.com: Official Object model reference for VBA. Always nice to have
- rubberduck-vba/Rubberduck: Super Handy VBE Addin that brings some Modern IDE Features to the VBE
That makes shit interesting
- thespreadsheetguru.com: The VBA Listobject
Was an add-in until Excel 2010, is now in the Data Tab. Query and Transform data from different sources. (Also used in PowerBI) I mainly use it to get data from one or multiple other workbooks. It basically generates Excel Tables (see above) and updates them. Very useful, for example if you have a changing data source and want to always display all the unique entries in a column. Also useful to transform data into a Pivot Table friendly format without changing the source data.
- support.office.com: Official Documentation
- docs.microsoft.com: PowerQuery M Language Reference
Interesting to Watch or Read