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.
Make Word line spacing LESS than single
There’s a simple Microsoft Word trick that lets you shrink the vertical space between lines. Specifically reducing to below single line spacing. To set less than 1 line space go to Paragraph | Line Spacing and choose ‘Multiple‘ – yes ‘Multiple’. Sounds screwy but it works. Set the Multiple line spacing value to less than one eg […]
Speaking Head in Silhouette 🗣 emoji in Word, Excel, PowerPoint and Outlook
How to insert the Speaking Head in Silhouette 🗣 emoji into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Speaking Head in Silhouette 🗣 emoji can be used as a different way to draw attention to a special point or note. Or as an alternative icon for a speaker […]
OneNote is (finally!) blocking dangerous files
The latest versions of OneNote will prevent over 120 file types from being added to notebooks in a move that’s WAY overdue. The blocked types of file might contain dangerous, hacked content that could infect a computer. Many of the newly blocked types are obscure or obsolete, mostly used by hackers to trick the unwary. […]
Files blocked from Outlook and OneNote – a complete searchable list
Here’s a complete and searchable list of the 120 file types that are blocked by Outlook (sending or receiving) or OneNote (embedding in a notebook). These, mostly old and obsolete, types of file can be used by hackers to infect Windows computers. As a precaution, Outlook and Exchange Server block messages containing these files, unless […]
Siren 🚨 emoji in Word, Excel, PowerPoint and Outlook
Insert the Siren or Police Car Light 🚨 symbol / emoji into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Police Car Light🚨 (aka Siren or Emergency Vehicle Light) symbol can be used any time you want to add warning or alert to a document, slide or sheet. […]
Starting out with 3D models in Microsoft Office
How to insert and use 3D models in Microsoft Office. 3D models let you rotate, pan and zoom all around an object to show it exactly the way you want. Microsoft Office’s 3D models feature has more uses than you might expect. From the Microsoft promotion, it looks like 3D models are only good for […]
Degree Fahrenheit ℉ symbol in Word, Excel, PowerPoint and Outlook
How to insert the Degree Fahrenheit ℉ into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Degree Fahrenheit ℉ symbol is used as the unit for the Fahrenheit temperature scale. It’s a single character that’s a combination of the degree symbol and capital F. There’s a matching Degree Celsius […]
Degree Celsius ℃ symbol in Word, Excel, PowerPoint and Outlook
Insert the Degree Celsius / Centigrade ℃ into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Degree Celsius ℃ is a single character symbol is used to refer to a specific temperature on the Celsius or Centigrade scale. Centigrade was the original name for the temperature scale before 1948 […]
SketchUp 3D graphics in Office 365
Microsoft has added SketchUp 3D graphics (.skp files) to the models inserted into Word, Excel, PowerPoint, and Outlook. SketchUp is a 3D graphics program where you can create shareable designs such as architectural models and graphics used in industrial design, product design, and civil and mechanical engineering. SketchUp Free is available for everyone. Adding Sketchup’s […]
Illegal colors in Word, PowerPoint and Office
Amazingly, a simple color can be trademarked and using one in a Word, PowerPoint or Office document can be illegal. We’ll explain why and a list of some colors you might need to avoid. Companies can trademark a color that’s associated with their product or logo. If you’re designing a document or presentation, especially for […]
Start a Word list from any value, not just 1 or A
You can tell Microsoft Word to start an ordered or numbered list from any number or letter you like. Not just start an ordered list with 1 or A. Lists can also restart numbering after a break. Creating a numbered list There are different ways for creating a numbered list you can simply type 1 […]
Myth Busting about Office document formats
Even after 15 years, there’s still misinformation about the ‘new’ Office document formats .docx .xlsx etc. We’ll explain these myths and how you can easily disprove them yourself. Most of these myths surround the use of ZIP compression to make the document files smaller. Folks have jumped to wrong conclusions after hearing about ZIP. Not […]
Vertical Bar | symbol in Word, Excel, PowerPoint and Outlook
How to insert the Vertical Bar | into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Vertical Bar | symbol (technically a glyph) has many uses in computing, physics, maths and typography. In some programming languages | has a special meaning, for example in PowerShell | is called […]
Excel’s Round () and nine other rounding functions
Excel’s Round () function rounds a number to a specified number of digits. It might seem like the choice for your rounding needs but there are NINE more rounding functions that might be better and even that’s not enough to cover all rounding needs. Round () basics Round() is pretty simple, give it a value […]
More accurate Excel rounding to the international specification
Here’s how to round numbers more accurately than Excel’s in-built Round() and other functions. This method uses the internationally recognized standard for rounding (yes, there is one), we’ll show the long formula, how it works plus the Let() and Lambda() versions that can make your worksheet easier to deal with. Rounding ‘Ties to Even’ The […]
Why Excel’s Round() function is wrong
Excel’s Round() function is not totally accurate. There’s a lot more to rounding numbers than we were taught in school and how Microsoft’s Round() function works. What we learned in school and Round() is OK. But if you’re dealing with larger groups of numbers, narrow rounding ranges or should be very, very fair (e.g test […]
