Claude Almer 1950-2020 We’re devastated to report the passing of Claude Almer who died in Sydney, Australia, on November 19, 2020 after a long illness Claude was technical and personal support for Office Watch since well before the newsletter started in 1996. Whenever in-depth analysis of some virus code was
Apple’s new Macbook’s use a totally new type of chip, the M1 or Apple Silicon. What does that mean for Microsoft Office and other programs? We’ll explain what Apple Silicon Macs are and why they are better. Microsoft Office compatibility with the new machines (it’s messy at the moment) and
Illustrations are a new graphics option coming to Microsoft 365 that supplements the existing Icons with a wider range of visual aids for documents, emails, worksheets and slides. They’ve appeared, without any mention, in preview versions of Microsoft 365 for Windows (version 13415.20002) and Microsoft 365 for Mac (v16.43 20102102)
The UK has been embarrassed (again) with the news that around 16,000 COVID-19 test results were missing from the official database and so contact tracing wasn’t done. The culprit? Excel. Or, to be fair, bad use of Excel is to blame. Not understanding it’s limits and how to workaround them.
Microsoft has done a clever thing, combining two important Excel features into a new and really useful addition – Custom Data Types. Excel 365 for Windows/Mac already has Stock and Geography data types to drop live information into workbooks. It’s now possible to make your own Custom Data Types (CDT)
Office 2010 ends support on 13 October 2020 and we’ve been receiving questions from readers asking about switching to newer Microsoft Office. We’ll answer questions about when to update, what to replace Office 2010 and important factors to consider. We’re hearing concerns about privacy in modern Office, reliability and the
Common programming tools can be used to make malicious Office workbooks which bypass both online security checks and Microsoft’s own protections in Word, Excel, PowerPoint or Access. We’ll explain what’s happening and what Microsoft could do better. VBA Purging or VBA Stomping are clever tricks to make an Office documents
Everyone with Microsoft 365 can get a ‘quick poll’ now with any email account or software. No need to wait for the Outlook Quick Poll option, now in preview for Microsoft 365 customers with Outlook for Windows. As we’ve already explained, Quick Poll is a simple and very limited way
Microsoft has made a major blunder with the July patches for Office. An update can crash Outlook for Windows entirely and the reason for the problem makes the bug especially humiliating for Microsoft. We’ll explain Microsoft’s blunder, what you can do if affected and how to avoid the buggy patch.
Word can be used to fill in and make an ICE or In Case of Emergency card. Our newsletter subscribers can download the Word document, ready to fill in and use. ICE cards are known to paramedics and emergency rooms the world over. An unconscious or uncommunicative patient is searched
Animated GIF support is coming (finally!) to Microsoft Word, Excel and PowerPoint. We discovered the new feature in a new Insiders build, Microsoft hasn’t announced anything. Here’s an animated GIF playing in Word 365. Paste or Insert an animated GIF now has play/pause buttons included (bottom left corner). The animation
Microsoft has expanded Teams to allow personal groups like families, clubs and groups to use the service. Within Teams it’s possible to text chat, save and edit documents, share calendars and lists. A family could have a grocery list to which anyone can add items before the next supermarket run.
Microsoft has gone public with their Money Excel template to import and manage financial transactions from bank accounts. There are some undocumented tricks available and an important security recommendation that Microsoft overlooks. Money in Excel can import transaction details (US bank accounts only) and show current balances. And convert that
The latest global exchange rates can go directly into Excel 365 for Windows and Mac. No plugins or extras are necessary because it’s in Excel 365 though it’s hiding away. Foreign exchange rates are part of the Stock data type. They weren’t part of the original Stocks data feed but
Some useful new features have now been rolled out to the public versions of Microsoft 365 (Office 365) for May 2020. Word, Excel, PowerPoint and Outlook all have improvements. Two we’ve already told you about, the other is new. Stock Images, Cutout People and Stickers Or what Microsoft calls “New
We continue our look at the options for the ‘Ken Burns Effect’ in PowerPoint by combining the pan and zoom animation features into a complete effect. It adds interest and movement to a still image with two separate animation effects available, in part, in PowerPoint. Ken Burns Effect in PowerPointThe
