Excel Tips

• 08 Sep 2020 »Faster Array Formulas
• 30 Nov 2018 »Add line break with ALT+ENTER
• 27 Nov 2018 »Using cut-paste to update references
• 26 Nov 2018 »COMING SOON... Calculation Profiling Deep Dive
• 25 Nov 2018 »Copy a worksheet to update its formulas
• 24 Nov 2018 »Extracting text with LEFT, RIGHT, MID
• 23 Nov 2018 »CONCATENATE and &
• 22 Nov 2018 »Logical Functions
• 21 Nov 2018 »Use Data Validation as a dropdown
• 20 Nov 2018 »Find all cells in array formula
• 19 Nov 2018 »Blanks and Charts
• 18 Nov 2018 »Removing duplicates
• 17 Nov 2018 »Horizontal sorting
• 16 Nov 2018 »Using ROW() to create a counter
• 15 Nov 2018 »Creating a moving average using INDEX:INDEX
• 14 Nov 2018 »Dealing with text as number errors
• 13 Nov 2018 »Improving the speed of array formulas
• 12 Nov 2018 »Dangers within a filtered list
• 11 Nov 2018 »Using the `AGGREGATE` function
• 10 Nov 2018 »Using the `IFERROR` function