Excel
- Add a Power Query icon to the quick access toolbar
- Cap percentages
- Checkboxes in cells
- Common VBA
- Common VBA functions
- CONCAT
- Copy Formulas without changing the cell references
- Create a Bullet Graph
- Data comparison take 1
- Data comparison take 2
- Data comparison take 3
- Data comparison take 4
- DAYS
- Delete Styles with VBA
- Dropdown lists
- Excel Quick Tips
- Filter rows with zeros
- FORMULATEXT
- IFNA
- IFS
- ISFORMULA
- Link a personal macro to the Excel ribbon
- Macro absolute and relative references
- Mailto and Teams links
- MAXIFS and MINIFS
- Numbers with leading zeros in CSV files
- NUMBERVALUE
- Quickly highlight unique or duplicate values
- Quickly select differences in a list
- Refresh Power Query
- SHEET
- SWITCH
- TEXTJOIN
- Two way lookups
- VSTACK