Microsoft 365 / Office 2021 Cloud Fonts are only available in Office programs … that’s the official line unless you know the trick to make the fonts available in other Windows or Mac apps Cloud Fonts can be selected and installed for Word 365/2021, Excel 365/2021, PowerPoint 365/2021, Outlook 365/2021
What are the legal limits on fonts supplied by Microsoft in Windows or Microsoft Office? Is there anything special for the Microsoft 365 only Aptos fonts? A few readers have asked us about the font license rules that apply to fonts provided by Microsoft. Can the fonts be embedded in
There are a lot more Office Icon or SVG graphics available than the ones in Microsoft 365, Office 2021 or 2019. Jazz up your documents, emails or presentations with a wider range of graphics than the (overused) ones that come with modern Word, Outlook or PowerPoint. Microsoft 365, Office 2021
Type or enter the ° Degree symbol into Microsoft Word, Excel, PowerPoint or Windows / Mac programs generally. Degree ° is a common symbol and should be available in most fonts. If not, try another font or one of the fonts with a very wide range of characters like Arial
Insert a World Map 🗺 symbol into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Of course, there are many Earth map images or drawings available on the Internet. There’s also some Microsoft Office Icons that we’ll explain below. We’re mostly talking about
Excel 365 has a detailed history of workbook changes down to the cell level so users can see what’s changed, when and who did it in Show Changes. Office-Watch.com explains how to use the new feature, some handy tricks plus the inevitable traps and limitations. This is great for collaborative
The new Aptos fonts in Microsoft 365 are installed and licensed in a different way from most fonts. How does that affect making a PDF either saving or printing. Can it be done at all? There are two broad ways to make a PDF file from an Office document. Save
Images can now be included in Excel PivotTables which not only makes for better looking PivotTables but more interesting Slicers too. A great contribution from Office Watch reader “AllanC” in New Zealand. With pictures in a PivotTable you can easily make cute slicers like this to show one record (person)
The new Aptos range of fonts is only available on Microsoft 365 apps. We investigate what happens when a document, sheet, slide or email with an Aptos font is opened on a computer without Microsoft 365 and the Aptos font range. In short: if Aptos fonts are not available, it’s
Microsoft is changing more than just the font in Microsoft 365, there are also default color scheme and even line changes coming too. Here’s all the proposed changes and how to reverse them. New Default Fonts We’ve already talked about the new default fonts, Aptos and Aptos Display. New default
Microsoft Excel has caught up with the needs of investors by adding automatic refresh of Stock prices and Currency data. Office Watch will explain what’s now possible and its limitations. Don’t get too excited, we’ve waited so long and when Microsoft does respond, the auto-refresh options don’t go far enough,
How to insert the Mount Fuji 🗻 or snow-capped mountain into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Mount Fuji (富士山 or Fujisan) is a Japanese Holy Site and World Heritage Listed. The symbol or emoji 🗻can be used for the famous mountain
For all the changes Microsoft has made to Search (aka Tell Me), they continue to ignore one basic that would make Word, Excel, PowerPoint and Outlook a lot easier to work with. Here’s some examples of how Microsoft Office search badly needs fixing. Search (formerly called “Tell Me”) usually appears
The Sharing options in Office are changing, yet again with a new ‘sharing experience’ in all Microsoft Office 365 apps for desktop, web and mobile. We’ll explain the changes, including a few options that Microsoft hasn’t mentioned. All the usual Microsoft buzzwords have been recycled to describe these changes; “streamlined”,
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
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
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
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
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
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
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
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.
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
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
