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.
Making QR Codes for Word and Office
QR Codes are those funny little boxes you see in apps and signs. They were once a bit unusual but COVID have made them part of our lives. You can add them to your Word, Excel or PowerPoint documents. Scan that code with your smartphone camera and it’ll read information, most commonly a web link. […]
Barcodes and QR codes in Word, fast and easy
Adding barcodes and QR codes into Word documents and mail merges is remarkably easy though hidden from view for no good reason. There are two unlisted field codes that drop barcodes or QR codes into a Word document. No need for special fonts, calls to web sites, VBA code or other nerd trickery. It’s all […]
Save a sorting order for Word tables
Create and save custom sort orders for Word, you easily apply them when list changes. You can also set up different sort orders that can be applied with a single click, streamlining your workflow and enhancing efficiency. Brian D writes with a question about custom sorting a table, in his case a To Do List. […]
Fast change Outlook calendar views
The Outlook Calendar views can change quickly with some shortcuts that work for both Outlook for Windows (classic and new) plus Outlook for Mac. The shortcuts follow the order of the Home | Arrange buttons in Outlook for Windows. Day – Ctrl + Alt + 1 Work Week – Ctrl + Alt + 2 Week […]
Outlook for Windows essential shortcuts
Fast access to important Outlook features! The ribbon in Outlook isn’t the only way to efficiently things done. Use the keyboard shortcuts that have been available in Outlook (Windows or Mac) for Microsoft 365 or Office 2024 and many earlier versions. Outlook for Windows Here are some keyboard shortcuts that are worth using with any […]
Quick View shortcuts for Outlook
Quickly change between Outlook views using these keyboard shortcuts that work for three different Outlook’s, Windows classic and new plus Outlook for Mac. With all the changes in Outlook for Windows or Mac, it’s nice to see that some keyboard shortcuts have survived all the upheavals. This works with both Outlook for Windows classic and […]
How to recall an email message in Outlook
Outlook for Windows and now Mac have a ‘Recall Message’ option for messages already sent but is now not needed, been replaced or you’ve realized was a mistake. But Recall isn’t all that Microsoft says it is. A ‘recall’ request message either to delete the message or sometimes replace it. How the recall request is […]
Microsoft Word isn’t always right, example 3,141,592
Word’s grammar checker is good, very good but it’s not perfect. Here’s the latest example of wrong advice under that blue underline. Office Watch reader, Simone J from Berlin sent us this English language anomaly in Word. “Your Latin and calligraphy skills are some of the best I’ve even seen” It’s the same error in […]
Smart Percentage Change in Excel
Calculating a simple percentage increase in Excel seems simple but, as usual, there’s a traps for the unwary. Here’s a smarter and more consistent way to figure out % change. First we’ll go over some basics which you’re welcome to skip … The formula for calculating a percentage change is simple: In other words, find […]
Excel’s order of calculation is not BODMAS
Excel has a slightly different order of calculation to the BODMAS rule taught to us at school. Those variations are important and can give a result you didn’t expect. Ray E from Iowa asked about one of those tricky algebra questions that appear on social media and generate heated arguments -10^2 . Ray wondered how […]
Forget what you’ve heard, Word still has a Thesaurus
Ignore the clickbait headlines and social media experts, Microsoft Word still has a Thesaurus feature. A slightly related feature has gone but Synonyms is still alive and kicking. Here’s Word’s Thesaurus or “Synonyms” still in Word 365 using Microsoft’s example word. And here’s Synonyms in Word 2024, using a more appropriate example word for this […]
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 […]
