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.
Six useful Replace tricks in Word
Microsoft Word’s Replace does a lot more than just replacing one bit of text for another. It can quickly change formatting, enforce a style, paste from clipboard and use special characters. You’re probably familiar with the basics. Press Ctrl + H to open the Replace dialog. Type in the text to look for ‘Find what’ […]
Drawing in all sorts of places Microsoft Office apps
Microsoft has been getting serious about drawing features in Office so we thought it was time to look at what’s available and possible across all the Office applications. Word, Excel, PowerPoint and some nice drawing stuff in OneNote Once upon a time, drawing onto a Word document or Excel worksheet was only possible with a […]
Share Draft Outlook emails on Apple, Android and desktop
Make a draft email on a phone or tablet (maybe some quick notes) to later revise and send from Outlook for Windows/Mac. Once that was a problem but not any more, as long as you’re using Outlook mobile apps. Syncronizing the Drafts folder is really useful. You can write a partial message or reply on […]
Faster ways to Outlook’s Choose Forms or Templates
Getting to Outlook Forms and Templates is a hassle, hidden deep down in the menus. It’s possible to bypass all those clicks and open the Choose Form dialog directly and even a specific library. See Email templates give you faster messages in Outlook The published way to access templates and forms is long-winded, Home | […]
Hyphens and Hyphenation, all the options in Word
Hyphenating words in Word has many choices; manual, optional, compulsory (non-breaking) and fully automatic. Manual Hyphen The simple one we all know. Type the – on the keyboard (properly known as the Hypen-Minus) to hyphenate a word, e.g. choreo-animator. See Of hyphens, em-dash, en-dash and more Automatic hyphenation Word will hyphenate long words when they […]
Faster ways to make a new email with Outlook template file
Here are four different ways to make a new email from an Outlook template file without the hassle of going deep into Outlook’s menus. You can choose to start a template based message from Windows or a button inside Outlook. See Email templates give you faster messages in Outlook for the basics on Outlook email […]
‘Friends’ logo or text complete in Word, PowerPoint and Office
Here’s how to add a taste of the logo or text from ‘Friends’ sitcom to a Word document, PowerPoint slide or other document. That includes the important dots between letters. All you need is available online plus a little Office trickery. Note for old-timers (like Peter, our Editor-in-Chief). ‘Friends’ was a televisual entertainment shown on […]
Email templates give you faster messages in Outlook
For emails that you send regularly, there’s a way to have a ‘boilerplate’ email template with most of the details already filled in. Messages can be sent faster and be more consistent. Welcome to the little-known world of Outlook email templates. Outlook email templates can have all the message details completed including To: CC: BCC:, […]
Ransomware protection in OneDrive isn’t everything Microsoft says
Microsoft promotes OneDrive as protection against ransomware however our tests show it’s not always as practical or complete as the company boasts. One recovery feature works fine but the other isn’t complete. While updating our book Everyday Backups, we tested the OneDrive ransomware protections, not taking Microsoft’s word about how it works. We found that […]
Psi upper Ψ or lower ψ symbols in Word and Office
How to insert the Psi upper case Ψ, and Psi lower case ψ symbols in Microsoft Word, Excel, PowerPoint, or Outlook. Both in Office for Windows and Office for Mac. Psi (uppercase Ψ / lowercase ψ) is the 23rd letter of the Greek alphabet. The symbols are commonly used within physics to represent wave functions in quantum […]
Xi upper Ξ or lower case ξ symbol in Word and Office
Insert the Xi upper case Ξ, and Xi lower case ξ symbols in Microsoft Word, Excel, PowerPoint, or Outlook. Both in Office for Windows and Office for Mac. Xi (uppercase Ξ / lowercase ξ) is the 14th letter of the Greek alphabet. The symbols are used within various contexts. The uppercase letter is often used in pure […]
Time durations are possible in Excel
” How can I enter a duration in Excel with the format days:hours:minutes:seconds ? If I enter 5:32 Excel converts that to 5:32am but I want to record 5 hours and 32 minutes.” Time durations aren’t very clear in Excel, but they are possible. The time features are mostly aimed towards date and time so […]
Sequence() for ordered numbers in Excel 365
Use Sequence() to get an ordered list of numbers either increasing or decreasing and with your choice of increments. Sequence is possibly the least understood of the dynamic array functions but combined with other functions it greatly extends Excel’s power. Sortby(), Filter(), Unique() and RandArray() all have obvious uses but Sequence() seems almost pointless. Here’s […]
Understanding the strange FollowedHyperlink style in Word
There are a few strange, non-standard, behaviors to the FollowedHyperlink style that Word uses for visited links. FollowedHyperlink is a hidden style which Word uses for any link which has been clicked or visited by the current user. Because it’s automatically applied it has some peculiarities that don’t apply to other styles, including its partner […]
Hyperlinks and link styles explained in Word
Word has special styles for hyperlinks which you can change from the standard blue, underlined look. Word link styles have some special behaviors to keep in mind. Word links can look very different or appear no different to regular text. All these are hyperlinks, believe it or not. Hyperlink and FollowedHyperlink Links have two modes […]
Random Numbers and more in Excel
About the RAND() function to make random numbers in Excel plus related functions RandBetween() and RandArray() plus some tricks for getting whole numbers only and even rolling ‘dice’ made in Excel. By Michael Barden Typing the =rand() function into a cell in an Excel spreadsheet will return a random number that is greater than or […]
