Category: Excel Habits

The new Dynamic Array functions are now in Office 365 Excel!  I have been playing around with some of them namely FILTER, UNIQUE and SORT which are awesome! Excel MVPs have helped us all with a ton of videos and …

Taking the new Dynamic Array functions out for a spin Read More »

Tagged with: , , , , ,

A few years ago I picked up on this gem of a tip of Dick Kusleika in his blog at his The Daily Dose of Excel site on using the Table Name prefix of “tbl”.  If you are not dropping …

Using a Table Name prefix for productivity Read More »

Tagged with: , , , ,