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.
Two ways to make a running total in Excel
Here’s two ways to make a running total column in Excel. The way you were probably taught and a much better and more flexible choice. Running or Accumulative Totals are a very common thing in spreadsheets. Here’s a really simple example in columns C and E. Here’s two ways to make those totals, using Sum() […]
Delete or hide comments in a Word document
All your choices for deleting or hiding comments in Word documents. An essential step before sending a document out. Comments in a Word document are really great for making side-notes or even discussions between people working on a shared document. It’s also great for adding your own notes to a document. But there’s some problems […]
How to stop migration to new Outlook
How to prevent Microsoft from pushing a change from classic Outlook for Windows to their new and incomplete Outlook (new). Microsoft is pushing customers to use Outlook (new) even though the software doesn’t have basic features like proper offline support or interactions between mailboxes. New Outlook also has a serious privacy breach for anyone using […]
Too Many Microsoft Outlooks? Clear Up the Confusion in Simple Terms
If you’ve ever been baffled by all the different things Microsoft calls Outlook, you’re not alone. Microsoft uses the “Outlook” name for multiple apps, web services, mobile clients and desktop programs. From Outlook (classic) for Windows to Outlook.com and the Outlook mobile app, making it hard to know which version you’re actually using or talking […]
Word field codes for everyone
Word field codes let you add automation or automatic content into documents. A simple example is the { DATE } field, which inserts the current date into a letter but there’s a lot more possible. Chances are good that you’ve already used field codes and not realised it. Date, PrintDate, Page numbering (current and total […]
Why Word doesn’t always show US and UK spelling correctly?
Microsoft Word’s English dictionaries can be confusing because they don’t always mark incorrect spelling differences between US and UK English (like color/colour). We did some tests with surprising results. English spellings can get screwy as you move between countries and there’s a lot more overlap than many people realize or realise 😁. There are many […]
How to remove words from the Word dictionary
How and why to remove words from the main Microsoft Word dictionary. The Office Exclusion List ensures a red squiggly underline appears to warn you about an unwanted word. Sometimes the supplied Office dictionary has words you don’t want or you’d like a warning about. Here’s how to put the red squiggly line under words […]
All the Outlook solutions to ‘Spy Pixels’ in emails
The many different Microsoft Outlook versions have a way to block images linked to emails, that includes the so-called ‘spy pixels’ used by many companies. See ‘Spy Pixels’ email epidemic, the good and the bad You can choose to view pictures in an Outlook email by clicking a button at the top of each message. […]
What Office License do you have? Retail, Volume or OEM
Here’s how to find out what type of Microsoft Office licence you have; Subscription, Retail, Volume or OEM and other hidden details of your Office license. For perpetual non-subscription versions of Office like Office 2024, Office 2021 or Office 2019, it’s important to know if your purchase is Retail/Volume or OEM. OEM licences are sold […]
Outlook (new) doesn’t mail merge with Word
Outlook (new) for Windows doesn’t support Mail Merge from Word. Just one of the many limitations of that software which is still a work in progress. We’ve heard from a few people that Microsoft has ‘dropped’ mail merge from Word but that’s not true. Word’s Mail Merge has been there for decades and isn’t going away. Outlook […]
Adding your name and other personal words to Microsoft Word
If Word doesn’t recognize personal words such as your name, the name of your hometown or the name of your favorite actor, it flags it as a mistake with the familiar red squiggly line. Here’s how to fix that. You can choose to add your words to the app’s custom dictionary. This is one of […]
Great Excel monthly calendar from just one cell
Modern Excel lets you make a whole monthly calendar from just one cell formula. We’ll explain how it’s done with a sample workbook for our supporters. At its simplest, Excel can make a single month like this from a formula in cell A6 which fills all the cells with the correct dates for that month. […]
Outlook bug, another reason to avoid Windows 11 24H2
As if there weren’t enough problems with the latest Windows 11 24H2 update, now there’s a bug which can block Outlook with Google Workspace Sync. Microsoft tries ‘passing the buck’ to Google. The bug is in the Windows 11 24H2 update though Microsoft is quick to dismiss the problem as “external” (which it isn’t) and […]
Everybody loves FRED, including Excel
Get Economic data or graphs from FRED (Federal Reserve Economic Data) to load into your Excel workbooks or PowerPoint slides. From unemployment rates to the price of potato chips. FRED has 825,000 data sets for the USA and around the world. Tip: search FRED for your country (Canada, United Kingdom, Australia etc) to see what […]
Word’s Calculator tricks and problems
Word can do simple calculations because Word for Windows has its very own built-in calculator. Calculate in Word has some nice tricks but also problems and traps. Type a calculation, hit the button (see below) and the result appears in the status bar AND it’s loaded into the clipboard ready for pasting. Calculate is a […]
Get better accuracy from Word’s Calculator
How to get greater accuracy out of Word’s in-built calculator. Recently, we unearthed Word’s hidden calculator. Word rounds its calculator results to two decimal places. This time, we’ll take a look at the two ways to improve the accuracy of Word calculator results. Use an old maths trick or change the Windows settings. Neither trick […]
