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.
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 […]
How to look inside an Office document
Dig into a Microsoft Office document file, such as Word, Excel, or PowerPoint, and see its inner workings, here’s a straightforward method. It reveals the small files that comprise an Office document, mostly XML files, which you can easily explore with a text editor. Very occasionally it’s helpful or necessary to dig into the structure […]
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 […]
Get more from your Keyboard: How to Turn the Caps Lock Key Into Something Useful (or Disable It)
If you often hit the CapsLock key by accident,sending part of your text into unwanted ALL-CAPS mode, you’re not alone. But rather than letting it stay a nuisance, you can repurpose it or disable it altogether. Stop accidentally turns CAPS ON when you don’t want it. On Windows or Mac you can remap CapsLock to […]
Excel blooper history – mistakes by users and Microsoft
Excel is now 40 years old and it’s capable of some amazing things. Let’s not forget some of the mistakes made by users and serious bugs by Microsoft along the way. First a reminder of some Excel bugs and how Microsoft never seems to learn from their mistakes. Excel bug adding rows and columns Back […]
Halloween icons and symbols for Word, Powerpoint and more
Quickly add a Halloween ghost, pumpkin, witches’ hat and more to your Outlook email, Word document or PowerPoint slides which have many in-built icons, graphics and pictures to enhance your “All Hallows’ evening” Icons, Stock Images, Stickers and Illustrations are all available in Microsoft 365 for Windows or Mac. Some Icons are also available in […]
RandArray – Excel’s best way to get random numbers
My ‘go to’ way to get random numbers in Excel is the new-ish RandArray because can do everything that Rand() or RandBetween() can and more. RandArray() fills cells with random numbers for as many rows and columns as you want. It’s in Excel 365, Excel 2024 and Excel 2021. The most basic version of the […]
