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.
14 perfect pumpkin colors and more in Microsoft Office
Our exclusive Pumpkin Color Charts have the perfect ‘pumpkin’ colors you can use in Halloween documents, slides and graphics with their Microsoft Office compatible color codes including the five Pantone colors called ‘Pumpkin’. There are many Halloween ‘pumpkin’ colors to choose from depending on the variety and ripeness of virtual vegetable you want. See more […]
Make your own Halloween costume pack image
Create your own fun, satirical ‘Halloween costume’ pack in the style of a popular meme using just Microsoft Word or PowerPoint. Use this article as a year-round example of how to overlay one image over another plus adding text to a picture. Take a blank Halloween costume image, add an image and some text. Something […]
PowerQuery mystery solved – how to Remove Duplicates, keeping most recent record
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 […]
PowerPoint Cameo puts your video selfie into a slide
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 […]
Xlookup is truly a great Excel function
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 […]
Anesthetists discover how NOT to use Excel
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 […]
All about Safe mode in Microsoft Office
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 […]
Fixed: Outlook bug showing restore items dialog
Microsoft has fixed a bug in Outlook for Windows which wrongly popped up the notice “Outlook closed while you had items open. Reopen those items from your last session?” When Outlook closes with items open (email, appointment etc.), it should offer to reopen those items when Outlook next starts. The message looks like this: Outlook […]
How Excel’s hidden CalcChain can catch data cheats
There’s a hidden part of Excel which can be used to catch ‘data cheats’ or people who tweak workbooks to get the results they want. There’s a news story about research into honesty, the academic is being accused, ironically, of dishonesty in their findings. The Professor is suspected of tampering with source data to change […]
Use a Hidden Registry Hack to Improve Your Privacy with Microsoft Office
Use a hidden registry hack to protect your privacy by reducing the amount of private info Microsoft Office apps send to Microsoft. Dr Aleksandar Milenkoski, working for the German Federal Office for Information Security, has produced a report on what information Microsoft Office software sends back to the company. That’s information about when and how Office […]
Stethoscope 🩺 emoji in Word, Excel, PowerPoint and Outlook
How to insert the Stethoscope 🩺 symbol/emoji into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Trivia: the stethoscope was invented by a Frenchman who was embarrassed putting his ear upon a lady’s chest to hear her heartbeats. His original was a simple tube, not the dual-ear device we […]
Bharat or Bhārat (India) in Microsoft Word
The alternative name for India is Bhārat and that term is now being used, somewhat controversially, by the government. How does Microsoft Word handle “Bharat” and what are your choices for either using the word or not. Even if you’re not interested in the name change, it’s a practical lesson in what’s possible in the […]
Listen to free audiobooks from Microsoft and Project Gutenberg
Microsoft and Project Gutenberg have joined to create thousands of audiobooks for free, using modern ‘text to speech’ technology that’s amazingly good. And we have some tips on how to create audiobooks with more variety in voice, accent and pace. Since 1971, Project Gutenberg has compiled a wide range of copyright free ebooks in many […]
Discover Office Keyboard Shortcuts in Windows 11 and 10
There are some keyboard shortcuts to open or switch to Office apps in Windows 11 and Windows 10, if you have enough fingers! They are all based around the Ctrl + Alt + Shift + Win combo plus a letter. That might seem like a keyboard shortcut for an octopus but it makes a little […]
Microsoft fixes a big hassle with Excel’s great Lambda()
Microsoft has fixed the big hassle that comes with the otherwise excellent Lambda() feature in Excel 365 with the new Advanced Formula Environment. Office Watch has sung praises over the power that Lambda brought to Excel. It’s the ability to write custom functions within Excel but without VBA macros. Proper IDE for Excel formulas But […]
Copying images from Designer to Office documents
Unfortunately, copying an image made in Designer isn’t as simple as it should be. Here’s how to grab images made with Designer to use in your own Office documents. Don’t wait, start using Microsoft Designer now It’s easy to paste an image into Designer. Just copy the image from your app (like Word or PowerPoint), […]
