Excel for Cyber
External Tools - (Useful, Opinionated, Unorganized)
- Solve 300+ daily tasks in Excel with Ablebits Ultimate Suite
- Download Fuzzy Lookup Add-In for Excel from Official Microsoft Download Center
- Load the Analysis ToolPak in Excel
- Find the right app | Microsoft AppSource
Techniques in Excel
Excel Tools
- Power Query
- Functions -
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
- SEARCH