Office 2021 is the personal and small business ‘perpetual licence’, non-subscription version of Microsoft Office. For Windows and Mac.
Office LTSC (Long Term Servicing Channel) is the volume licence ‘perpetual licence’, non-subscription version of Microsoft Office for organizations, companies and governments. Also for Windows and Mac.
The features in Office 2021 and Office LTSC are very similar, if not the same.
Excel 365’s PowerQuery has many wonderful features but occasionally there are common needs that it can’t easily handle. One of those surprising complexities is removing older duplicates but retaining most recent row for each. We’ll explain the simplest solution then why it works. Here’s some sample data on the left and the most recent purchase […]
Microsoft PowerPoint’s Cameo lets you put a live camera feed into your slides. The camera feed can be moved, resized, cropped, and styled just like any other image. Designer in PowerPoint can also be used to add flair to slides that use cameo. Cameo is already in Windows and Mac and now also in Powerpoint […]
One of the most commonly used and confusing Excel functions is much better in Excel 365 and Excel 2021. Vlookup() has a new, better and easier replacement Xlookup(). It’s a truly good and useful addition to Excel, some might call it a godsend. Xlookup is available in Excel 365 for Windows/Mac/Apple/Android plus Excel 2021 for […]
A British medical office has made a right mess of selecting trainee anesthetists by the misuse of Excel. Let’s look at what happened and some ways you can avoid similar mistakes. As told in The Register, the UK Anesthetic National Recruitment Office (ANRO) had the job of selecting candidates from across seven regions to get […]
Safe Mode is a special way for Office apps to run when things aren’t working properly. Here’s how to use Safe Mode, if Office doesn’t offer it automatically, and what Safe Mode does differently. Safe Mode is useful in situations where you cannot open files in normal mode because the app is crashing, or you […]
