Learn how to create live, dynamic sorted lists in Excel using the powerful combination of Sort()/SortBy() and Filter() functions. In Excel 365 and Office 2021+ dynamic array formulas like FILTER() let you extract a subset of data — and by wrapping that result inside SORT(), you can instantly sort the filtered list in whatever order […]
Filter is another Excel 365 dynamic array formula that’s really useful and far better than similar options in earlier versions of Excel. Just like SORT() and SORTBY(), FILTER() refreshes automatically whenever the source values change. The older pull-down filter and sort choices don’t update properly. Dynamic Arrays also give you the choice to show the […]
In late 2018, Excel 365 got an important new feature, Dynamic Arrays . Here’s a simple way to use the feature to make your workbooks sort better and automatically. It also fixes a long-standing problem in Excel. We’re going to focus on a very simple and useful part of dynamic array that anyone can use; […]
The Word, Excel and PowerPoint apps for iPad are getting right-click menus when there’s a external mouse or trackpad connected. It’s a good move with more iPads being used with separate keyboard & mouse as a mini-PC. Sadly the new menus aren’t all they could be. Right-click (Microsoft calls a ‘secondary click’) on an image […]
The Office ‘all in one’ app, already available for iPhone and Android, is starting its arrival on Apple iPad. The app combines Word, Excel, PowerPoint and other goodies into a single app. The ‘all in one’ app, officially called just ‘Microsoft Office’ has started a limited preview. We’ll explain how to get it now, either […]
