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.
Three ways to insert a Recycle symbol ♻ in Word, Excel, PowerPoint and Outlook
Three ways to insert the Recycle symbol ♻ into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. There are many different and specialist Recycle symbols. We’ll focus on the standard, generic symbol, officially called “Black Universal Recycling Symbol” in three forms: Emoji or Unicode symbol, Office Icon and the […]
Teardrop-Spoked Asterisk ✻ in Word, Excel, PowerPoint and Outlook
Insert the Teardrop-Spoked Asterisk ✻ into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Heavy Teardrop-Spoked Asterisk ✻ symbol has a circle in the middle with six ‘teardrop’ spokes around it. It has no specific purpose but is a more decorative alternative to the standard asterix * or other bullet […]
Investment Rate of Return is easy in Excel
Excel’s IRR() function is a straightforward way to calculate the rate of return for investments which have regular return/payment dates with amounts which might vary. Such as a simple fixed-interest bond, where cash flows occur at regular intervals such as monthly or yearly. When expressed as a percentage return, it’s a lot simpler to understand. […]
Easily calculate stock and asset returns in Excel
There’s a nice little Excel function that will calculate the rate of return on any asset like a stock or fund including income/dividends with purchases and sales over time. The secret sauce is XIRR() a function which calculates an internal rate of return with uneven interest or dividend payments. In other words, common real-world situations. […]
Scanning from within Microsoft Word or Office
Can you scan a picture or document directly into Word, Excel, PowerPoint or Outlook? Certainly, but these days we’re spoiled for choice and have fantastic features like using a smartphone as a simple scanner. Back in the day, you could click a button in Word 2003 to scan a document or image and drop it […]
The faster way to insert pictures into Office documents
An easy and fast way to add pictures into Word, Excel, PowerPoint or Outlook. We mentioned a faster way to get a scanned image into Word via the ‘scan to clipboard’ option available in some scanning software. There are similar options available for copying existing image files into Word, Excel or PowerPoint documents as well […]
Why another Outlook for Windows is coming
Windows Mail and Calendar apps will be replaced with the ‘new’ Outlook. That means a second ‘Outlook for Windows’ and plenty of confusion for customers and support people. Microsoft made this mistake before and seem determined to do it again. This ‘new’ Outlook is a Progressive Web App (PWA) formerly known as ‘Project Monarch’. It’s […]
Excel can figure out how long to pay off a loan
Microsoft Excel has a handy function called NPER that can help you work out how long it’ll take to pay off a loan. It’ll show how adding even a little bit per payment can help clear a loan faster and some practical advice on using NPER in the real world. Say you have a personal […]
Two ways to change document defaults in Microsoft Word
How to change the ‘Blank Document’ defaults like font etc. in Microsoft Word. Either ‘Set Default’ choices or update Word’s core template. What to do when the usual tips don’t work. In other words, all about Normal.dotm in Microsoft Word. Microsoft 365 customers are getting new default fonts called Aptos, which means many people are […]
List fonts in a Word document – method 2
There’s another way to make a list of all the fonts in a Word document. This method is probably faster than using VBA to search for fonts through large documents. This is an alternative to the VBA code in How to list all fonts in a Word document Word documents contain a list of fonts […]
Excel can figure out payments to clear credit card debt
Let Excel help you cut your credit card debt by calculating the monthly payments needed to pay off the card. The PMT function in Excel calculates of loan payments needed to clear the debt in a certain time. Suppose there is a remaining balance of $5,400 on a credit card with an annual interest rate […]
Predict the future value of your investments with Excel
Excel can calculate the future value of your investments, such as finding out a return you’ll get on a Certificate of Deposit (CD) or Term Deposit. There’s an inbuilt Excel function to make the task very simple. It’s just one way Excel can make your financial decisions a whole lot easier. Future Value of a […]
Make better Excel Charts by adding graphics or pictures
Add some extra flair to your plain Excel charts by inserting pictures or graphics within the chart. It’s remarkably easy and enhances charts a lot. You can simply enhance your graph by inserting a business logo in the chart area. Or you might want to add images to replace the text labels. You may want to insert an image of money to represent dollars spent, or a car to represent […]
Check out the winner and other new fonts in Microsoft 365/Office 2021
Here are samples of the five new fonts available for Microsoft 365 and Office 2021 customers one of which has become the new default font, but under a different name – Aptos. Did we say five? … there are really 10 new sans-serif fonts. Each of the five newbies come in two versions, normal for […]
Word’s Find can’t find all Unicode symbols and emoji
Word has a way of finding Unicode symbols by their reference number, except it doesn’t work for many symbols and not at all for emoji! And the Find ^u option is inconsistent with the rest of Word and common practice. These bugs have been in Word for a few years now with no sign of […]
Make your own Worlde in Office and Word
Make your own Wordle grids in Microsoft Office, Word, PowerPoint or Excel. Choose the right font, colors (the exact green, yellow or grey) plus grid details including blank or unfilled boxes. Wordle was originally a standalone app, created by Josh Wardle . It’s now owned and run by The New York Times, though the look […]
