Excel 365 for Windows is getting another option for importing data into PowerQuery, from a dynamic array. In many cases the original data source could be imported, sorted and filtered in many different ways. Importing a existing dynamic array is a useful extra trick for us Excel nerds. We can think of three uses right […]
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 […]
Your first look at Office 2021 for Mac with Word, Excel, PowerPoint and Outlook, which is now out in public preview, showing off some of the new features. There’s only a Mac Office 2021 preview, no Office 2021 for Windows preview. Perhaps because there’s a few more innovations in a comparison of Office 2019 to […]
A public preview of the next perpetual licence Microsoft Office is now available. Called Office LTSC (Long Term Servicing Channel) it’s for volume customers only. Here are the options and how to get the preview. Office LTSC is the clumsily named non-subscription version of Office for organizations with volume licence agreement. See Office LTSC, first […]
Here’s a first peek at Office LTSC for Word, Excel, PowerPoint, Outlook, Access, Publisher and OneNote which is now out in public preview showing off some of the new features. Office LTSC in it’s current preview is underwhelming, to put it mildly. But that’s what Microsoft is aiming for. Office LTSC (Long Term Servicing Channel) for […]
