External Tools - (Useful, Opinionated, Unorganized)
Techniques in Excel
Excel Tools
- Power Query
Essential Tasks
- Pivot - pivot table, pivot charts
calculate, summarize, and analyze data that lets you see comparisons, patterns, and trends in your data
- Unpivot -
- Take multiple columns with same value types → flatten into two rows
- “Flatten” into a row
- Crosstab → tabular (unpivot)
- Power Query
- SQL Joins, Merging, Lookups
- Formulas
- Create conditional formulas - Microsoft Support
- INDEX
- MATCH
- INDEX MATCH & VLOOKUP
- https://www.appsloveworld.com/excel-formula/100/30/check-if-key-value-pair-exists-and-return-them-in-the-row-next-to-the-match
- https://www.ablebits.com/office-addins-blog/if-vlookup-excel/
- Look up values with VLOOKUP, INDEX, or MATCH - Microsoft Support
- 5 easy ways to VLOOKUP and return multiple values
- FILTER
- TEXTJOIN
- Excel VLookup Return Multiple Values in One Cell Separated by a Comma
- https://www.simonsezit.com/article/textjoin-excel/
- TEXTJOIN function - Microsoft Support
- SEARCH