World Map đș symbol in Word, Excel, PowerPoint and Outlook
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 the World Map đș symbol […]
Show Changes is a wonderful addition to Excel
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 worksheets with many people making […]
Aptos fonts and making a PDF from Office
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 As PDF or Print to […]
Add pictures to your Excel PivotTables
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) at a time Hereâs the […]
What happens when Aptos fonts aren’t available?
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 not possible to say, for […]
All the Office theme changes in Microsoft 365
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 font, Aptos, in Microsoft 365 […]
Excelâs Stock / Currency data (kinda, sorta) gets auto-refresh
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, isnât properly configurable and doesnât […]
Mt Fuji đ» symbols in Word, Excel, PowerPoint and Outlook
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 or any time you want […]
Which Microsoft Office feature badly needs a fix?
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 in the title bar as […]
Changes to Sharing options in Microsoft Office
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â, âsimplifiedâ, âfree of distractionâ, âexperienceâ […]
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 […]
