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.
Outlook Function Keys – complete list
Here’s a complete list of the Outlook Function Key features from fast access to Help, jumping around your inbox, doc panes, spelling, grammar and key shortcuts. Let’s look in detail the functionality of the F-keys labelled F1 through F12 on your keyboard. F1 – Help, hide ribbon F2 – Calendar F3 – Search, change case […]
See Word Styles alongside document paragraphs
Each paragraph style can be seen alongside the text in Microsoft Word but it’s very much an afterthought that could be much improved. The Style Area Pane appears only in Draft and Outline view on the left-side. Turn on Style Area Pane Dig into Word for the Style Area Pane. File | Options | Advanced […]
Zero Thirds (Baseball) ↉ emoji in Word, Excel, PowerPoint and Outlook
How to insert the Zero Thirds (Baseball) ↉ fraction or symbol into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Zero Thirds ↉ symbol (officially called ‘Vulgar Fraction Zero Thirds’) is a rarely used Baseball scoring symbol. The best explanation we could find was a Japanese Wikipedia page, here’s […]
All about MROUND() in Excel
MROUND() is lesser known but really useful rounding function in Excel, it’s worth considering for anyone dealing with cash money. In short: MRound() rounds up or down to the nearest multiple you choose. It’s very handy for rounding prices to match the lowest coin or note you want to handle, but it’ll have other uses […]
The important difference between Int() and Trunc() in Excel
There’s an important difference between two seemingly similar Excel functions: Int() and Trunc() don’t always give the same results so we’ll explain how to choose wisely. Both Int() and Trunc() ‘shorten’ a number by removing digits to the right of the decimal place. Int() rounds the number, Trunc() doesn’t. And Trunc() has an option to […]
Discover all the Function Key goodies for PowerPoint
Here’s a complete list of the PowerPoint Function Key features from fast access to Help, jumping around the presentation, doc panes, spelling, grammar and guidelines. What you can do with the F-keys labelled F1 through F12 on your keyboard. Don’t like Function Keys? KeyTips are your way to faster Microsoft Office F1 – Help, hide ribbon […]
Secrets still left in docs after Document Inspector in Office
Office’s Document Inspector is supposed to remove or scrub information being accidentally included in Word, Excel or PowerPoint files. It’s not perfect and misses out on some critical hidden information that can give away secrets. Details in images, layers and even highlighting. Document Inspector is at File | Info in Office for Windows. The feature […]
Dates, time and duration, the truth in Excel
Date handling in Excel can be confusing and it’s not your fault. Microsoft could do a better job. Here’s a quick guide to how Excel handles dates and date arithmetic with the settings you should know. What you see isn’t what’s saved What Excel shows in a cell is only a version of what’s actually […]
Line And Paragraph Numbering In Word
How to number lines and paragraphs in Microsoft Word and format the numbers with a different font, size or color. Plus some ‘wish list’ features that are missing from Word. When you’re discussing a speech or other document ‘in progress’ you might want to number the lines or paragraphs for easy reference “Please change paragraphs […]
Construction Sign 🚧 emoji in Word, Excel, PowerPoint and Outlook
How to insert the Construction or Roadwork Sign 🚧 emoji into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Construction, Roadwork or Warning Sign 🚧 symbol can be used in PowerPoint slides and in other Office documents sometimes to mark WIP or “Work in Progress“. Need more than an […]
Word keyboard shortcuts, add, change or remove
Speed up your work by adding and changing keyboard shortcuts to Word commands, styles, fonts and even symbols that aren’t on the keyboard. You can even override or remove Word’s in-built shortcuts so they do what you want (or nothing). We’ll show how to find the more useful and interesting commands that are hidden away. […]
Fixing Microsoft Office Unlicensed Product errors
Here’s what to do if you get the dreaded Microsoft 365 / Office 2021 or Office 2019 Unlicensed Product / View only error message. Assuming you have a current Office 2021/2019 or Microsoft 365 subscription (we’ll show you how to check that, below). The unlicenced product warning usually happens if you’ve started Office after a […]
Find more and faster in Word using these tricks
Use these Microsoft Word options to quickly find words and word variations that you might have thought impossible. Finding words that sound the same or past, present and future tenses in the one search or ignoring punctuation to find “its” and “it’s” in one search These options are in the two places you can Find […]
Reversed Question Mark / Irony ⸮ symbol in Word, Excel, PowerPoint and Outlook
How to insert the Reversed Question Mark / Irony ⸮ into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Reversed Question Mark / Irony ⸮ symbol has been proposed to denote irony or sarcasm within text. Or for rhetorical questions. It’s never really caught on. The proper name […]
Add a special font for dyslexics to Word and Office
Dyslexie is a special font that’s easier for dyslexic people to read than standard type. It’s free for personal use and easy to include in Microsoft Word, Excel or PowerPoint for Windows or Mac. The font is specially designed, making it easier for the eye/brain to distinguish similar letters. For example, the slight incline reduces […]
How Microsoft left an Outlook security hole that’s way too easy for hackers
More is coming out about the latest, critical Outlook security bug and how embarrassingly easy it is for hackers to infiltrate an unguarded computer. What Microsoft blandly calls an “Outlook Elevation of Privilege Vulnerability” is truly dangerous and is so easily done that it’s likely to be quickly and widely used. Everyone with Office for […]
