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.
All about Diaeresis or Umlaut in Microsoft Word
How to typing words with a diaeresis or umlaut in Word for Windows, Mac, Apple or Android plus the shortcuts on Mac computers. They aren’t normally needed in English except some organizations that require diaeresis for words like: naïve coöperate reëlectBrontëNoëlNoël Coward Or you might be typing in another language where the umlaut makes a difference to […]
Saving OneNote notebooks be saved locally and not in the cloud
Many OneNote users would like to save their notebooks on their computer and not OneDrive. Saving a notebook to a local folder is possible. It might become impossible in the years ahead. Only OneNote 2016 for Windows supports saving a notebook to any folder. OneDrive is the only notebook option in other OneNote apps (including […]
Ignore or Mute emails in Outlook
How to get rid of an email conversation or thread in Outlook – it’s called Ignore or Mute. Sometimes you get emails on a topic that doesn’t matter to you and is cluttering up your Inbox. Outlook for Windows has a fairly simple solution – the Ignore button. Ignore tells Outlook to move all existing and […]
Six tips for better spreadsheets
Some good advice for better spreadsheets from the distinguished science journal, Nature, (established 1869!) who have tips about the right way and wrong way to use Excel or Google Sheets. The article Six tips for better spreadsheets opens with a horror story about a list of latitude/longitude “It was a complete mix, The spreadsheet was […]
Hiding stuff in Word, Excel and PowerPoint
We’ve completed our series on ‘Hidden’ options in Word, Excel and PowerPoint. How to hide text, images, cells, slides etc within documents. Hiding is a useful option and avoids deleting content that might be needed later. It lets you make a different version of a document/sheet/deck without the hassle of maintaining two very similar documents. […]
Automatically Update Document Styles in Microsoft Word
Deep in Microsoft Word is the choice “Automatically Update Document Styles“. What does that do and which documents are affected? There are several similarly worded options to do with ‘Style’ and ‘Automatic’ so let’s be clear … we’re talking about File | Options | Add-ins | Manage | Templates | Go | Templates and Add-ins […]
Showing 12 o’clock as ‘noon’ or ‘midnight’ in Excel
Excel shows midday or noon as 12:00 PM which doesn’t suit everyone, here’s how to change the defaults to a word such as ‘Midnight’ or any other time label you’d like. ABC News in Australia delves into the argument about showing 12 PM – There is no such time as 12pm. The argument is that […]
Save fast replies & common text for Outlook emails
In many situations, there’s common text or even whole messages that you want to reuse in emails. Here’s an option to save and add that text with a single click. It’s a lot faster, more consistent and already in Microsoft Outlook. Outlook has a feature that’s good for recycling text for emails. Strictly speaking, Word […]
Apple command ⌘ symbol in Word, Excel, PowerPoint and Outlook
The Apple command ⌘ symbol can be typed into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Apple command ⌘ symbol appears on Mac and iPad keyboards but only as a command option, not as a symbol to type. The ⌘ symbol predates Apple computers. It’s a ‘PLACE […]
Excel Formula Bot upgrades and goes pro
The wonderful Excel Formula Bot has a new look, more features and has gone ‘pro’ with paid subscriptions. The whole site https://excelformulabot.com/ has been revamped with a cleaner, clearer look. Excel Formula Bot is certainly up-to-date, as you can see above, it already ‘knows’ about the new Image() function despite still in beta testing. Please […]
Great Periodic Table documents for Microsoft Office
There are some great and editable Periodic Table of Elements options available in Microsoft Office – Word documents, Excel spreadsheets and PowerPoint slides There are many Periodic Table ‘documents’ on the net but most are PDF’s or images that can’t be changed. We’re looking for editable Word documents and Excel worksheets that you can adapt, […]
North West/Top Left Arrow ↖ in Word, Excel, PowerPoint and Outlook
Insert the North West or Top Left Arrow ↖ into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. North West Arrow ↖ or “Top Left Arrow” can be used for directions on a map (naturally) or pointing to ‘top left’ in a Word / PowerPoint table or Excel […]
Excel merge arrays into a single array with VBA
Until late 2022 an annoying omission from Excel and VBA was a simple way to combine or merge arrays into a single array. Here’s how to do it with VBA for older Excel releases. Excel 365 for Windows and Mac now have HStack() and VStack() which will combine dynamic arrays or ranges. The VBA method […]
Six workarounds when your keyboard breaks
Your deadline is in four hours, you’ve got pages to write and BAM! a letter key breaks on your keyboard …. What do you do? There are at least six different workarounds available in Word, Windows and Mac. A broken key happened to Colin Chambers, a University of Buffalo student when a drink spilled on […]
Sentence spacing in Word – one, two or don’t bother?
Is there one space or two between sentences? Word lets you check the sentence spacing or ignore it completely. It’s a useful option for those of us who learnt on manual typewriters where double sentence spacing was standard. Switching to single spacing is hard for your fingers to remember. One Space or Two People can […]
‘Punctuation required with quotes’ in Microsoft Word
‘Punctuation required with quotes’ is the most commonly changed Microsoft Word grammar and style setting. It checks is for the location of commas etc. when used with a quotation. Here’s two similar sentences to demonstrate: In US usage, the sentence punctuation mark go inside the quotation marks. In standard British /Commonwealth usage, the comma is outside […]
