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.
Nudge, nudge PowerPoint for better positioning
Moving objects around your PowerPoint slides in tiny, tiny little jumps instead of larger moves, simply by holding down the Ctrl key. The simple way to position an image or object in a PowerPoint slide is either dragging with the mouse or using the arrow keys – obviously. Either option is usually enough but the […]
Easily Calculate Body Mass Index in Excel
BMI or Body Mass Index is a ‘rule of thumb’ calculating body fat based on height and weight. It’s easy to calculate in Excel whether you use metric or feet/pounds. BMI can be a polite way of saying how overweight a person is! A BMI over 30 is considered obese and need of work to bring down […]
Wavy Dash 〰 in Word, Excel, PowerPoint and Outlook
Insert the Wavy Dash 〰 symbol into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Wavy Dash 〰 symbol is like a long curvy version of the em-dash, there’s no specific meaning or purpose. Not to be confused with the two Tilde ~ symbols and reversed ∽ Tilde […]
How to convert Normal style to Body Text style in Word
Switching paragraphs from Normal style to Body Text styles in Microsoft Word is a clever use of the Replace feature that can switch text with any style to another. We’ve talked about how savvy Word users have their main text paragraphs in the Body Text style instead of the standard Normal style. See also Modifying Body Text […]
Automatic worksheet/tabs list in Excel
Make an automatic list of tabs in an Excel workbook a better and more flexible way with options to create clickable links and sort the sheet list. Unlike older methods, it works in Excel for Windows and Mac. We’ve already talked about fitting more tabs on the screen or making a manual list of tabs/worksheets. […]
Explore five (yes FIVE) different Exclamation Mark ! in Word and Office
There’s more possible with the humble ! exclamation mark / point in Microsoft Word or Office. At least five different ! available and that’s before changing color, size and other text effect options. We’ll show you ways to insert FIVE different exclamation marks into Office, as characters, icons, symbols and several emoji with infinite variations possible […]
Stop contract trickery with a Word document
There are risks when sending a Microsoft Word document to someone when you don’t need to, one landlord found that out the hard way. A Word doc can be changed if you’re not careful. We have some suggestions for avoiding unexpected editing traps. A tenant in the USA received a draft lease via email in the […]
Make captions for PowerPoint video and audio
Here’s the basics of how subtitling or captions works for PowerPoint. Using a simple text editor, you can create closed-caption files for videos and audio that you wish to make more accessible. It’s great for subtitling any video including one you’ve made of your PowerPoint presentation. Closed captions or Subtitles are made and stored in […]
Purple, Prince, Pantone and Microsoft Office
There’s a special purple color named by Pantone as ‘Love Symbol Number 2’ in honor of the musician Prince. That same purple is possible in Microsoft Word and other Office applications. Only last year, Pantone teamed with Prince’s estate to announce that PQ 7448C was to be known as Love Symbol Number 2. Now the […]
Add Prince’s Symbol ‘Love Symbol Number 2’ in Word and Office
The late and much missed musician Prince wished to be known by single character symbol called ‘Love Symbol Number 2‘. Here’s how to enter that unique symbol in Word, PowerPoint or Microsoft Office generally. There are various methods suggested on the Internet, we’ve narrowed them down to one excellent option (SVG graphic) two others that […]
Add the King Charles III monogram to Microsoft Office docs
There’s a new King in Britain (and other countries) which means there’s a new Royal Logo Cypher or Monogram. Here’s how to get the Cypher for Microsoft Office documents or slides. The Royal insignia is usually made from two parts, the Tudor Crown or Scottish Crown above the Royal Cypher. There’s a Royal Cypher below […]
Beware a Microsoft Office 365 – OneDrive outage, what you must to do protect yourself
No cloud service is perfect, no matter what the company says. Here’s what you must do to protect yourself from breakdown of your OneDrive, SharePoint, Teams or Microsoft 365 cloud storage. Microsoft pushes use of OneDrive to store all your documents and images. That suits Microsoft’s strategy but isn’t necessarily a good thing for customers. […]
Exploding Head 🤯 emoji in Word, Excel, PowerPoint and Outlook
Insert the Exploding Head 🤯 emoji into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. How Exploding Head 🤯 emoji looks Windows only has Exploding Head 🤯 in the Segoe UI Emoji font, either color or black. To me the black version looks more like a bowl than […]
Three ways to understand part of an Excel formula
Excel has three different ways to see a partial formula result to help you locate and fix a problem or understand how a formula works. Two methods have been in Excel for some time and there’s a new tooltip feature. Evaluate Formula The full Evaluate Formula has been around since at least Excel 2007. It […]
Understand or fix an Excel sheet with Evaluate Formula
Excel has a simple way to understand or fix a complex formula. Evaluate Formula lets you calculate parts of a formula and see interim results that make up the final value that appears in the cell. It’s on the Formulas tab under Formula Auditing. Evaluate Formula isn’t new, just little mentioned despite its usefulness. We […]
Fixing AutoFit Table Columns in Word
Word will automatically adjust or Autofit the width of table columns and the space within cells to fit the content that you are entering. Sometimes you don’t want this and want to be able to control the column widths yourself. AutoFit for Word tables is great but sometimes gets too enthusiastic. Tables get pushed beyond […]
