Microsoft has released a preview version of Office 2024 LTSC. Here’s how to get it, what’s in the preview and why not to bother with the preview software. Office 2024 is the next fixed price or perpetual license version of Microsoft Office that will be released later this year. The
Here’s what Microsoft has confirmed for the new version of Office. Strictly speaking two new Microsoft Office, a consumer version Office 2024 and Office LTSC 2024. The next single payment “perpetual licence” version of Office will be Office 2024 (for consumers) or the very similar Office LTSC 2024 (for volume
Grouping in Excel lets you collapse or expand sections of a sheet so you can see the ‘big picture’ but still drill-down to how totals were made. Another use for grouping is hiding rows or columns from view. You can organize and manage data more effectively by grouping together rows
Switch from the new Aptos default font in Outlook to another font that you prefer and is has better readability in Outlook desktop (Windows or Mac) and Outlook (new). Personally I’ve tried to like Aptos fonts but after a few months they still offend my eyes, especially in emails. It’s
Here’s a combined ‘one-click’ way to force an update to both Windows and Microsoft Office at the same time. Normally Windows and Office both update themselves automatically and in the background so you don’t have to worry about it. But there are times when you need to ensure both are
You can do incredible things in Excel but here’s something truly amazing. Someone has made a 16-bit computer chip (CPU) emulation entirely in Excel. We have links to the source code and fascinating video that explains it all. @Inkbox has recreated the basic logic of a CPU to make a
According to Microsoft, AutoSave is the ‘greatest feature of all time’. That’s ‘over the top’ even for Microsoft and it only highlights the self-serving limitations of the current Autosave feature in Office. “Autosave is the greatest feature of all time and you can use it across your M365 apps. That’s
Excel users are rightly interested in Lambda() a very powerful addition to Excel. Lambda lets you create user-defined functions without VBA. No need for .xlsm files with all the security concerns they entail. A long formula can be written once then referenced anywhere in the workbook by a short name of
Change Case options in Word, like many Word features goes beyond the obvious choices from the basic shortcut. There’s up to five choices on the ribbon with a keyboard shortcut to reach it. Alter the upper/lower case of words, phrases or more. ‘change case’ can become ‘Change Case’ or ‘CHANGE
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
Microsoft’s Word Comments feature has popped up in the news again over the break, this time to embarrass Milo Yiannopoulos, a former Brietbart commentator. Mr Yiannopoulos is in a legal battle with his publisher over a proposed book and some of the court papers are now public. What’s catching attention
