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.
Word’s Hidden Calculator
You haven’t heard about it? Don’t worry, even Microsoft has no information about this feature, unless you dig way back into its archives where you’ll find that the calculator – which formerly held a prominent position on the Tools Menu – was driven underground in Word 6.0 to make way for the far more cumbersome, […]
Show currency in Excel with country and symbol
How to show currency amounts in Excel with the country and correct currency symbol included. Excel doesn’t support the standard way that different currencies are displayed with their country codes like this: Dig into the Accounting/Currency Formats and you’ll find these among a VERY long list of currency symbol options. All those options let you […]
Pantone’s 2025 color ‘Mocha Mousse’ in Word, Excel and PowerPoint
Pantone’s color of the year for 2025 is “Mocha Mousse”. You can use that exact color in Word, Excel, PowerPoint, Outlook and Designer using the Hex/RGB color code. And we’ll look at the flowery prose that’s become a hallmark of this annual promotion. The color of 2025 is … Mocha Mousse We make fun of […]
All you can do with PowerPoint Action Buttons
Action buttons in PowerPoint are versatile tools that bring interactivity and control to your presentations. By following a few simple steps, you can insert and customize these buttons to perform tasks such as navigating slides or opening external applications. Incorporating action buttons can greatly enhance audience engagement, making your presentation more dynamic and interactive. Whether […]
Make your own London Tube sign for Word or PowerPoint
The famous London Tube Roundel or station sign is easy to recreate for Word, PowerPoint or other Office apps. The best way to do this is SVG graphics in Microsoft 365, Office 2024/2021/2019/2016. SVG’s let you change the colors and set the text easily. They don’t have to be a railway sign. Use the roundel […]
My favorite Outlook calendar view looks to the future
My favorite Outlook calendar view is very useful but most people don’t know it’s there. See today and the next week in one screen. I rarely care what’s happened in the past, I want to see what’s happening in the near future. That’s why my ‘Go To’ calendar view is Home | Go To | […]
An Excel shortcut that can speed (or confuse) your day
Enter the Ctrl + – (minus) shortcut in Excel. This powerful shortcut instantly deletes entire rows or columns without any confirmation. But there’s hidden trickery going on and some misleading info online. Ctrl + – is commonly said to “delete the selected row or column” but, as usual, the reality is more complicated. Some online […]
Beware Black Friday Scams on Microsoft 365 and Office
Black Friday means many software deals, on Microsoft 365 and especially Microsoft Office. Here’s how to navigate the treacherous waters of Black Friday sales and ensure you get genuine products without falling prey to fraudulent offers and scams. Recognizing Too-Good-To-Be-True Deals It’s easy to be tempted by offers that seem too good to pass up. […]
Select a vertical column of text in Word
Yes, Microsoft Word lets you select vertical (up or down) text blocks. Most text selection in Word involves selecting horizontally – selecting a line or a paragraph of text. Sometimes, though, you need to select a vertical slab of text. To do that, hold down the Alt key while you click and drag your mouse […]
New London Overground line colours in Office
Here are the exact colour codes and new names for the ‘Overground’ lines in London, plus how to add a thick double line in Office documents just like on a Tube map. The changeover is happening in late November 2024. Some old rail lines in London were coloured Orange on maps and just called ‘Overground’. […]
Share your Office documents from Dropbox
OneDrive isn’t the only choice for sharing Office documents. Dropbox can also share Word, Excel or Powerpoint documents including real-time collaboration. The Dropbox and Microsoft Office integration allows users to open, edit, and save Office files directly from Dropbox. Use either Office apps on the web (Office Online) or modern Office/Microsoft 365 desktop apps. You […]
Word ‘AI free’ cure is worse than the disease
Social media is spreading a false ‘tip’ that’s supposed to stop Microsoft spying on your work in Word and Excel. The suggestion might not work at all and worse, it’ll stop important Office features from working at all. And Microsoft is NOT spying on Word, Excel or PowerPoint for their AI. The ‘tip’ is supposed […]
The hidden trap in Excel’s DateDif()
There’s a hidden trap in Microsoft Excel’s DateDif function that rarely gets a mention and is too easy to overlook. DateDif() is a long-standing Excel function that returns the duration between two dates. It’s not a ‘full’ Excel function because it was added for compatibility with Lotus 123 and has a known bug. Despite that, […]
The big difference between what Excel shows and what Excel knows
Understanding the difference between Excel’s stored value for a cell and its displayed value is important. It happens a lot and can make a big difference to the results. Back in the day we detailed a bug in Excel 2007 where the wrong number appears on the screen yet Excel ‘knows’ the right value for […]
Adding Action Buttons to PowerPoint
A PowerPoint action button is a shape you can add to your slides, allowing you to hyperlink to another slide or webpage, play a sound, or trigger other actions. It’s an easy way to add interactivity and navigation to your presentation with very little effort. It’s also a way to control the presentation within […]
How to get the official Porsche color in Word and Office
How to get the official Porsche color “Turbonite” in Microsoft Office for Word documents, PowerPoint slides and more. The color has been announced by Pantone with the code PMS-2336-C. Porsche Turbonite is described in the usual flowery terms by Pantone: Turbonite color codes It’s easy to apply the Turbonite color to Office documents using these […]
