Excel
- Copy Formulas without changing the cell references
- Create a Bullet Graph
- Data comparison take 3
- DAYS
- Dropdown lists
- Excel Quick Tips
- FORMULATEXT
- IFNA
- IFS
- Import incremental data
- Link a personal macro to the Excel ribbon
- MAXIFS and MINIFS
- Numbers with leading zeros in CSV files
- NUMBERVALUE
- Quickly highlight unique or duplicate values
- Quickly select differences in a list
- Running PeopleSoft queries from Excel links
- Running Xero reports from Excel links
- SHEET
- SWITCH
- TEXTJOIN
- Two way lookups
- VSTACK