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.
Inside the Schengen Visa Calculation workbook
Here’s a quick look at some of the modest Excel tricks we used to make the Schengen Visa Calculation worksheet. Table Making the itinerary list an Excel Table lets us make use of some features. Formatting It’s a lot easier to format as a table with banded rows. We’ve turned off the Table | Filter […]
Microsoft Word is beaten (again) by a 14 year-old spelling champ
Our annual Microsoft Word vs the Spelling Bee Champions contest is on again for 2022. Word has done better than in the past but was still beaten by another extraordinary 14 year-old. 2022’s Spelling Bee Champ is Harini Logan, 14, from San Antonio TX who narrowly beat Vikram Raju a mere 12-year-old from Denver, CO. […]
Zero-day security hole in Word, Microsoft very slow to act
A large security risk has appeared in Microsoft Word, a zero-day security problem which can infect even fully updated Word. Microsoft has taken at least 14 months and still hasn’t fixed the security hole. We’ll explain the problem and what you can do. It’s a relatively simple hack which takes advantage of gaps in Word, […]
Five ways to turn text into Excel dates
Sometimes you need to convert a date from the Excel cell saved format to a particular format. There are at least five ways to do that. DateValue(), Date() or converting Unix dates to Excel. Simply typing dates into a cell also works but there are traps for the unwary. Excel’s trap when typing in dates […]
Text to Excel Date conversion by adding Zero with Paste Special
Another way to convert text to dates is by adding zero to the text. This is a trick which forces Excel to convert the text into an Excel value so it can then add the zero. Since adding zero doesn’t change the value, you end up with text converted to an Excel value. It’s a […]
Excel Conditional Formatting, beyond the presets
Excel has some nifty and simple options for color highlights the extremes in a list of values. It’s called Conditional Formatting and you can do all sorts of clever things with it. First let’s look at the simple presets that Microsoft has given us, some of the obvious choices they’ve left out and how to […]
Simple sharing your Outlook invitations
It’s easy to share appointment details with other people, whether they use Outlook or not. No need to type in appointments when you can send and receive the details right in your calendar. We’ll explain how it works for both sender and receiver (organizer and invitees) on various platforms, including Outlook.com and Gmail plus the […]
IF and Nested IF Statements in Excel
An IF statement might sound like a complicated thing that programmers do, but it’s actually fairly easy to do in Excel. An IF statement basically puts something into a cell depending on certain conditions – if A is true, put X in this cell. You can even use what’s called a nested IF statement if you have […]
Microsoft Office license info coming to Windows
Windows 11 is getting a way to view your Microsoft 365, Office 2021 and Office 2019 licence details within the Windows Settings app. At Windows Settings | Accounts | Your Microsoft account … it shows a lot of the details from the Office.com account web pages. Windows 11 for Microsoft Office users is your independent […]
Elizabeth Line designs for Word, PowerPoint and Office
The Elizabeth Line (aka Crossrail) is now open in London, a major new tube line crossing the city. Here’s the roundel and color scheme for the new line in a format ready for Word, PowerPoint and Office. The same design elements can be used for any other London Tube line (real or imaginary) or totally […]
Otter 🦦 emoji in Word, Excel, PowerPoint and Outlook
Type the fun Otter 🦦 emoji into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Otter 🦦 emoji represents a light-brown otter (a member of the weasel family) on its back with its paws held together. But the emoji can just be used for a bit of fun. […]
Dictation (speech to text) is now in OneNote
OneNote is finally getting the Office Dictation (speech to text) feature that’s already in other Office programs. That’s in addition to the long-standing Look for Dictation in OneNote for Windows Home tab, way off at the right-side. Also, in OneNote in a web browser … Dictation and Read Aloud in Office is our comprehensive guide […]
Two ways to open a OneDrive document in Microsoft Office
There are two different ways to access a Microsoft Office document that’s saved on OneDrive. We’ll explain both and why it’s sometimes important. Microsoft’s OneDrive stores documents on servers. Programs (like Office) can open those files directly from the cloud service. Or the OneDrive app can copy (synchronize) files from the cloud to your “local” […]
Six ways to number lists in Excel
Excel doesn’t automatically number lists but there are at least six ways to add numbering depending on your needs and how the list appears. Numbering is important but can be annoying when you’ve got a large dataset. If it’s small, it’s easy to number it manually or by an auto-filling sequence. But if it’s inconsistent […]
Duck 🦆 emoji in Word, Excel, PowerPoint and Outlook
Add the Duck 🦆 emoji into Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Duck 🦆 emoji represents the quacky bird with webbed feet. The emoji is usually depicted as a Mallard. Sometimes used as a substitute for the f-word, because of iPhone’s tendency to autocorrect to the obvious […]
What can you put in your email address?
A simple question – what characters can you put in an email address? Like many things to do with the Internet the answer isn’t as simple or direct as you might think. We’ll look at what makes a valid email address, both in theory and in practice. A simple question – what characters can you […]
