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
Microsoft is making crucial changes to their Microsoft Office 365 Education licenses that will increase costs to many schools and colleges. Office 365 A1 plus – gone! The Office 365 A1 Plus program for Education will be retired by Microsoft on August 1, 2024. A1 Plus included Office desktop apps
The Office Watch head honcho, Peter Deegan, isn’t just a Microsoft Office nerd for over 25 years. He’s been a theatre junkie for even longer and goes to the famous Edinburgh Festivals each year. And each year he’s asked for recommendations and tips. For 2023, he’s publishing some short reviews
Like to know some more about your Microsoft 365 for Windows software license? How long the Office apps will run without an Internet connection? Here’s how to see that hidden license info, how it’s changed and a little good news too. Microsoft 365 software occasionally checks with Microsoft servers to
Here’s how to find out what type of Microsoft Office 365 licence you have with details hidden from the usual About dialog box. We recently showed it’s important for for perpetual non-subscription versions of Office like Office 2021 or Office 2019 to know if the purchase is Retail/Volume or OEM.
There are many different ways to insert a page break into a Microsoft Word document, some are visible and others invisible even with Show All turned on. Luckily, Word has a straightforward way of doing this with a manual or separate Page Break. It’s also possible to associate a page break with the paragraph, which is a lot easier manage page breaks but they are somewhat invisible and it’s not
Every Microsoft Word Style has an option to ‘Automatically Update‘ which sounds great, but can lead to more confusion. Here’s what ‘Automatically Update’ really means, why it’s wise to turn it off and the better alternative. There are many ‘Automatic’ options in Word that are spread all over the place.
A quick and reliable way to update a style within a Microsoft Word document. It works only when you ask it and you can apply a series of changes before updating the style. Update Style to Match Selection We’ve made a series of changes to a paragraph; font size, color
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”,
Microsoft is making Clipchamp available to their Microsoft 365 commercial customers after limiting access to consumer users for too long. As usual, Microsoft’s announcement has many ‘fine print’ details to annoy paying customers. Clipchamp is Microsoft’s online video editing service. It’s been available to Microsoft 365 Personal and Family customers
Clipchamp, is Microsoft’s video editing software and service. It’s a simple way to create videos easily with text, graphics, effects and transitions. Microsoft 365 consumer customers get extra Clipchamp features. You can try it out here, or download it from the Microsoft Store for Windows. Mac users can get Clipchamp
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
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
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
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
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 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
There’s a bug in the latest release of Outlook 365 for Windows (Microsoft 365) which makes saving attachments slow to a crawl. Microsoft has a workaround to consider, if you’re desperate. The problem occurs when saving attachments to a network folder directly. There’s a long wait looking at this dialog
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
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,
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
