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.
Excel formula: get percentage discount
Use Excel to figure out the percentage discount or increase, for example the difference between the original and sale prices. We’ll show you the Excel formula and some practical tricks beyond the official answer. Percentage discount formula The basic formula is: (Original – Sale) – to figure out the difference between old and new amount […]
All the left pointing hand symbols in Word and Office
Word and Office have several left “pointing hand” symbols available in some fonts. Here’s the Unicode options explained and shown. We’ve also looked at the options for All the RIGHT pointing hand symbols in Word and Office Want more arrows or pointers? Check out all 200+ Arrow or Hand pointing symbols and more in a […]
Right arrow → symbol in Word, Excel, PowerPoint and Outlook
Insert the Right arrow → into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. The official Unicode name is ‘Rightward Arrow” → but it can be called ‘Right pointing’ ‘Right facing’ or just ‘Right Arrow’. Want more arrows or pointers? Check out all 200+ Arrow or Hand pointing […]
All the right pointing hand symbols in Word and Office
Word and Office have several right “pointing hand” symbols available in some fonts. Here’s the Unicode options, index, backhand, sideways in white or black, all explained and shown. Want more arrows or pointers? Check out all 200+ Arrow or Hand pointing symbols and more in a searchable list. Index, Backhand or Sideways? The Unicode system […]
Microsoft Word vs Spelling Bee quiz
How does Microsoft Word’s spell check work against ten difficult or unusual words from a New York Times spelling bee quiz? What’s in a Word is an interesting quiz of words used in past Scripp’s Spelling Bee’s and, as usual, we’re interested in how many of the words are recognized in Microsoft Word’s spelling. Word […]
Three ways to run an Office macro direct, from the ribbon or toolbar
There are three main ways to run a macro in Microsoft Office (Word, Excel, PowerPoint or Outlook). From the Macros list, from a button on a ribbon or from the Quick Access toolbar. We previously spoke about how to install an Office VBA macro, here’s how a macro can appear on the ribbon or Quick […]
Make the Office ribbon more useful, add your choice of buttons
Any Office ribbon tab can be more useful for you. By trimming some of the buttons you don’t need, making room for the buttons you want. We’ll show you how to remove some of the less needed ribbon sections (likely from the Developer tab) to make more room for your own buttons. Previously we’ve explained […]
Add Chess Piece symbols to Word, PowerPoint and Office
Insert any of the chess piece symbols available in Word, Excel, PowerPoint and other Office apps. King, Queen, Bishop, Knight. Rook and the lowly Pawn all with different looks, depending on the font plus three pieces available in Microsoft Office icons and the single chess piece emoji. Chess Pieces – the full list Here’s the […]
Save money on printer ink, toner and consumables
Printer makers are happy to sell a cheap printer because they make big profits on ink, toner and other consumables. Here’s how to save money. Buy in advance Stores and printer makers rely on people waiting until they’ve run out of ink/toner before rushing to get more. You pay a high premium for that rushed […]
Easily install an Office VBA macro
Here’s how to easily install VBA code or macro in Microsoft Office. Adding some code you’ve seen on a web site or been given is simple once you know the little tricks. Often people are given some Office VBA code to use with Word, Excel, PowerPoint or Outlook but without instructions for how to install […]
Changing Measurement Units in PowerPoint
Changing the measurement units in PowerPoint is possible but unnecessarily complicated, we’ll show you how in both Windows and Mac. The Measurement Units show up in the ruler and also in places like the size and exact positioning of images. Measurement option – US or Metric Ideally you want to change between the main measurement […]
Fantastic Earth image for your desktop or PowerPoint
The European Space Agency has released the first full Earth image from its new weather satellite and it’s a fantastic, high-resolution view of Europe, Africa and the Middle East. Great for a desktop, screen saver or Powerpoint slide. Taken by the Meteosat Third Generation Imager-1 (MTG-I1), the image is available for download. Use it as […]
Beware, Microsoft is looking in password locked ZIP files
Microsoft is now looking at the contents of password protected ZIP files stored on OneDrive, Sharepoint and other cloud services. Maybe with honorable intentions but there are serious privacy concerns that haven’t been acknowledged. For a long time, Microsoft’s antivirus and safety systems have opened up compressed ZIP files to check the contents for nasty […]
Update your Outlook and Windows now
There’s another security bug in Windows, embarrassing for Microsoft because it was caused by their own March fix for another security bug in Outlook! That means anyone with Outlook for Windows or Windows should ensure they have the latest updates. This is another ‘zero-click’ Outlook bug that can infect your computer without any action by […]
Check, tick and cross symbols galore
There are different check mark, tick or cross symbols available in Word, PowerPoint or other Office apps. Here’s an easy searchable list of all Unicode symbols plus in modern Office ✅✔️☑️ is called a ‘check mark‘ or ‘check‘ in some places and ‘tick‘ in others. Same symbol, different English names. ❌X╳ has many more symbols […]
Nine easy statistics in Excel
There are at least NINE simple statistics formulas and functions in Excel that can summarize a list of numbers into something easy to understand. Often Excel has lists of numbers or money that makes little sense until you add a summary like this: We have a table called CountbyState and want to know something about […]
