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.
Easy and better lists with Excel 365’s Filter()
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 […]
Better live sorting in Excel 365
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; […]
Who is suing Microsoft for millions over Office licencing?
Here’s an interesting switch, a UK company is suing Microsoft over their licencing rules for Office. Usually it’s Microsoft suing others about licences, not the other way around. ValueLicensing is claiming UK₤270 million (US$370m ) in damages from Microsoft for trying to squeeze out the second-hand licence market. Organizations that upgrade their software licences, are […]
Simple Indexing in Microsoft Word
We’re going to talk about creating indexes in Microsoft Word. ‘Real’ books often have an index at the back which Word can create for you. An index is a list of terms or topics that can be found within the document. Microsoft Word has the ‘fixings’ to make an index and automatic options to take […]
A risk of spam filters – you might miss a real prize!
Aggressive spam filters can stop you getting messages you really want to get. One Australian author found that out the hard way when she almost missed out on a genuine $150,000 prize. The email notifying her of the valuable and prestigious prize ended up in her Junk Email folder. The problem of spam filters ‘false […]
The case of the missing file extension
You’ve received a document, but when you try to open it, the file stubbornly won’t appear! We explain how to fix it. Our editor-in-chief saw that problem in an Internet cafe‚ in Ketchikan, Alaska and was surprised when neither the manager of the store nor the cruise computer ‘expert’ knew the answer. As you probably know, […]
Two new Microsoft Office bundles coming in 2021
Microsoft has announced two ‘perpetual licence’ or non-subscription versions of Office that will be released later in 2021. Both continue Microsoft’s unstated but bleedingly obvious attempts to push customers to annual ‘subscription’ payments. Here’s what Microsoft has disclosed so far with an explanation of the continued reduction of value for perpetual licence purchasers. To replace […]
New Office release in 2021 – maybe Office 2022?
Microsoft has finally confirmed what was long suspected. There will be another fixed price, perpetual licence version of Microsoft Office. The successor to Office 2019 will be released in late 2021 for Windows and Mac. Update in late 2021: of course we now know it’s called Office 2021 All about Office 2021 for Windows & […]
Six shortcuts for horizontal lines in Word and stopping them!
Word has six shortcuts to make horizontal lines, here’s how they work, change them, color the lines and how to stop lines when they get out of control. All six line shortcuts There are six horizontal line shortcuts. For each one type the same character three times at the start of a new line then […]
Why Windows Variable fonts are important
Office Watch reader, John Hoffmann has some more detail on variable fonts, supported in Windows 10 and Windows 11 Variable fonts are a single package that includes many variations (Light, Heavy etc), instead of having separate font files for each variant. That takes up less disk space (important on tablet devices) and, as John explains, […]
Word’s Comments feature embarrasses Milo
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 are the editor’s comments in […]
Paul Manafort was trapped by Microsoft Word and how he could have prevented it
The FBI is using evidence from Microsoft Word to oppose a change of release conditions for former Trump campaign chairman, Paul Manafort. We’ll show you the mistakes that were made and how to avoid them. We’re not interested in the prosecution itself nor the politics, here’s a summary. Our focus is on the little known […]
Office Emoji look different on other devices
Emoji in emails should be used with great care because what the receiver sees can be very different from the emoji you entered. This isn’t Microsoft’s fault. It’s in the complex nature of emoji with different fonts etc. The ‘take away’ is that emoji’s are great but keep in mind that they might not appear […]
Microsoft reads private email on Hotmail/Outlook.com
When Microsoft feels the need, they read cloud emails on Outlook.com (aka Hotmail) or other Microsoft 365 hosted email. Microsoft has been caught reading private data stored on their cloud servers and it’s all quite legal. In 2012 screenshots of the, then unreleased, Windows 8 had been leaked and Microsoft wanted to know where the […]
Excel’s SUM is much more
There’s SUM and then there are all the useful SUM variations to choose from. Excel’s SUM() function is probably the first one we learn but there’s a lot more to it than simply clicking on the button to add up a list of numbers. In this article we’ll look at the options available in SUM […]
Excel’s effect on economic policy
A simple Excel worksheet mistake caused a change in economic policy. Was it a user’s mistake or Microsoft’s? A few weeks ago, came the news that a much-quoted academic paper was based on a faulty Excel worksheet. The paper titled “Growth in a Time of Debt.” from Reinhart & Rogoff was widely used to support […]
