All about Microsoft Office Word, Excel, PowerPoint and Outlook, Microsoft 365, Office 2021 and earlier versions.
List all available fonts in a Word table
Here’s how to make a list of all the available fonts on a computer by making a table in Word complete with sample text using each font. It makes a Word table of all the fonts, including sample text like this. VBA features on show The code is fairly straight-forward and a simple example of […]
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. […]
Office Lens is a useful tool for any smartphone
Office Lens is a good app for iPhone, iPad and Android devices. If you want to convert photos into a Word document (as text) or PDF, the Office Lens is the way to go. Lens has a wonderful straightening trick that turns an off-center photo into something ‘straight on’ which is easier to read and […]
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 […]
Jump quickly to graphics with new Word shortcut
The latest enhancement in Word for the web brings a better graphic navigation experience. Now, with keyboard shortcuts alone, you can select and move between graphics like never before. In short, Ctrl + Alt + G or Cmd + Alt/Option + G will select the first graphic in the document and then jump between other […]
Why pay $30 extra a month just for Copilot?
Microsoft has surprised by putting a high extra price on their upcoming AI features in Microsoft 365. To get these innovations, add another $30 a month to the cost, which in many cases doubles the price of Microsoft 365. Copilot is Microsoft’s name for their AI features that can write, summarise and design parts of […]
New default styles in Excel 365
The change of fonts in Microsoft 365 also means the default styles are also changing in Excel 365. Here’s what the new styles look like and the exact settings Microsoft has chosen in Excel 365 for Windows and Mac. The new Excel defaults for a worksheet mostly use Aptos Narrow with a little Aptos Display. […]
New default styles in Word, PowerPoint and Outlook
The change of fonts in Microsoft 365 also means a change of default styles (normal and headings) are also changing. Here’s what the new styles look like and the exact settings Microsoft has chosen for Word, PowerPoint and Outlook. At the moment, these fonts and styles are in Microsoft 365 Insiders builds for Windows and […]
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 […]
