# Excel for Cyber # External Tools - (Useful, Opinionated, Unorganized) - [Solve 300+ daily tasks in Excel with Ablebits Ultimate Suite](https://www.ablebits.com/excel-suite/index-2022.php) - [Download Fuzzy Lookup Add-In for Excel from Official Microsoft Download Center](https://www.microsoft.com/en-us/download/details.aspx?id=15011) - [Load the Analysis ToolPak in Excel](https://support.microsoft.com/en-us/office/load-the-analysis-toolpak-in-excel-6a63e598-cd6d-42e3-9317-6b40ba1a66b4) - [Find the right app | Microsoft AppSource](https://appsource.microsoft.com/en-us/product/office/wa200001792?tab=overview) # Techniques in Excel Excel Tools - Power Query - Functions - - [Excel functions (by category) - Microsoft Support](https://support.microsoft.com/en-us/office/excel-functions-by-category-5f91f4e9-7b42-46d2-9bd1-63f26a86c0eb) 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) ![Untitled](Excel%20for%20Cyber/Untitled.png) - Power Query - SQL Joins, Merging, Lookups - Formulas - [Create conditional formulas - Microsoft Support](https://support.microsoft.com/en-us/office/create-conditional-formulas-ca916c57-abd8-4b44-997c-c309b7307831) - INDEX - [5 Excel INDEX Function Secrets • My Online Training Hub](https://www.myonlinetraininghub.com/5-excel-index-function-secrets) - MATCH - [MATCH function - Microsoft Support](https://support.microsoft.com/en-us/office/match-function-e8dffd45-c762-47d6-bf89-533f4a37673a) - 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.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/](https://www.ablebits.com/office-addins-blog/if-vlookup-excel/) - [Look up values with VLOOKUP, INDEX, or MATCH - Microsoft Support](https://support.microsoft.com/en-us/office/look-up-values-with-vlookup-index-or-match-68297403-7c3c-4150-9e3c-4d348188976b) - [5 easy ways to VLOOKUP and return multiple values](https://www.get-digital-help.com/how-to-return-multiple-values-using-vlookup-in-excel/) - FILTER - [FILTER function - Microsoft Support](https://support.microsoft.com/en-us/office/filter-function-f4f7cb66-82eb-4767-8f7c-4877ad80c759) - [Excel FILTER function - dynamic filtering with formulas](https://www.ablebits.com/office-addins-blog/excel-filter-function/) - TEXTJOIN - [Excel VLookup Return Multiple Values in One Cell Separated by a Comma](https://powerspreadsheets.com/vlookup-values-cell-comma/) - [https://www.simonsezit.com/article/textjoin-excel/](https://www.simonsezit.com/article/textjoin-excel/) - [TEXTJOIN function - Microsoft Support](https://support.microsoft.com/en-us/office/textjoin-function-357b449a-ec91-49d0-80c3-0e8fc845691c) - SEARCH - [Cell contains specific text - Excel formula | Exceljet](https://exceljet.net/formulas/cell-contains-specific-text)