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.
More than five Christian ✝ Cross choices in Word, Excel, PPT and emails
There are at least five different options inserting a Christian or Latin ✝ Cross symbol into Office documents like Word, Excel, PowerPoint or emails. There are some cross symbols available in the Windows / Office symbol fonts and there’s plenty of nice cross options available online in the flexible SVG format. Office itself is surprisingly secular […]
Two ⸘ Interrobang symbols ‽ in Word, Outlook, Excel and PowerPoint
What is an interrobang ‽ and how to use it in Microsoft Word, Excel, Outlook and PowerPoint. Also the Inverted Interrobang ⸘ that can be used with ‽ Interrobang or interabang ‽ is a non-standard punctuation mark – a combination of a question mark and exclamation mark in a single character (glyph). It can be […]
Send scheduled emails more reliably than Outlook
Schedule or delay sending an email more reliably than using Outlook desktop apps. Even better, it’s incredibly simple to do in Gmail, Outlook.com or any Exchange Server mailbox including Microsoft 365 hosted mail. We’ve explained how to use “Delayed Delivery” in Outlook desktop apps and also the many problems with that feature. There are various […]
See the whole ‘raw’ email message in Outlook
“ I need to see the entire message that was sent to me, headers, MIME parts, the lot. How can I do that in Outlook?” – Gary G, Taupo NZ. The short answer is, you can’t, with a possible exception. That’s not the answer you’ll see elsewhere on the Internet but it’s the sad truth. […]
Delayed Sending in Outlook has problems and bugs
You can delay sending an email in Outlook. It’s a handy trick that can help make sure your message is read. Here’s how to schedule send an email plus the many traps, complications and a long-standing Outlook bug. A Washington Post article headed The one simple trick to make sure your email gets noticed caught […]
Year of the Rabbit images and more in Microsoft Office
2023 is the Year of the Rabbit in the Chinese calendar. There’s plenty of rabbit, bunny and other New Year related images, icons and Chinese character 兔 in Microsoft Office plus advice on the right colors to use for Chinese New Year graphics. Chinese New Year is on 22 January 2023, an excuse for fireworks, […]
Why the US government is switching to Calibri font
The US State Department is changing from Times New Roman font for documents to Calibri. There are good reasons for the change though, as usual, there are objections and a little Microsoft Mystery. Calibri is the current default font in Microsoft Word and other Office apps. It’s been the default since Office 2007, though users […]
Two ways to change the default font and more in Word
Changing the font, size or style for all Word documents is remarkably easy and there’s two ways to do it. Alter the font that’s automatically used when you make a ‘blank document’. In Word 2007 and later the default font face is Calibri, font size 11 and style Normal. This might not be the ideal […]
All about Office 2021 for Windows & Mac
Office 2021 is the current ‘perpetual licence’ or non-subscription version of Microsoft Office for consumers and small businesses, here’s details of what’s new, prices, shorter support time and why Microsoft doesn’t want to sell Office 2021 at all! It’s what Microsoft calls a ‘perpetual licence’ version. A single payment for ongoing use of the software […]
Easy way to get UTC / GMT current time in Excel
Finding out the current UTC / GMT time in Excel is possible with a little VBA magic. We’ve included a full working example. Excel has two functions to give you the current date TODAY() or current date and time NOW() but it’s the local time as set on your computer. Often the worksheet needs either […]
Get the local time zone offset into Excel
Finding out the computers local time zone offset in Excel is possible with a little VBA magic. We’ve included a full working example of how to get the ‘nn hours from GMT’ setting from Windows into Excel. The need for the current UTC/GMT time and offset is becoming more important as Excel improves its external […]
Compass 🧭 symbol in Word, Excel, PowerPoint and Outlook
Insert a Compass 🧭 symbol into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Compass 🧭 uses Segoe UI Emoji In Windows, the Compass 🧭 symbol is in the font: Segoe UI Emoji. Depending on the app and use, it’ll appear in color or black. The symbol can […]
Quick change the language setting in Word
There’s a way to quickly change the language setting for a multi-lingual Microsoft Word document, by adding a language selector to the Quick Access Toolbar (QAT) like this. Use this as a pull-down list to change the language setting in parts of a document. The problem is the fixed width of the toolbar item, which […]
Cool Excel Year Planner now available for download
A clever and different year planner with a progress thermometer is now available for download as an Excel workbook. The days remaining in the year are visible with weekends shaded and each day of week shown. At the bottom is a clever use of Excel’s Chart features to make a progress ‘thermometer’ for the year. […]
Average / Mean options in Excel
Excel statistical functions have many Average / Mean options including Average with IF for filtering or mean with extreme values excluded. by David Goodmanson In a world which has more and more data, statistics are really important. They help you distill lots of numbers down so that you can see the overall pattern. And yes, […]
Set the default translation language in Word
If you regularly translate text from or to the same language, you can set default languages. Once you have set the languages, Microsoft Word will automatically translate the text as soon as you hit Translate, without you having to set the text each time. To set the default languages, go to Review | Translate | […]
