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.
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
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
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
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
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
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
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
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
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
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
Type the Left arrow ← into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. The official Unicode name is ‘Leftward Arrow” ← but it can be called ‘Left pointing’ ‘Left facing’ or just ‘Left Arrow’ See also Right arrow → symbol in Word, Excel,
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
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
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
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
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
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
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
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
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
