As promised, Excel 365’s Regular Expression support has been extended to include both Xlookup() and XMatch() functions. Regex adds a huge amount of power to matching results from a table. Back in July, Excel 365 added three Regular Expression (regex) functions, RegexTEST(), RegexEXTRACT() and RegexREPLACE(). At the time Microsoft promised
Clipchamp, Microsoft’s video editor is now boasting background removal which is great for tricks like adding a watermark or ‘bug to a video. But there’s some limitations or ‘gotchas’ to watch out for. Add an image to a Clipchamp timeline, right-click then choose ‘Remove Background’. Wait a few moments and
There are quicker ways to use the View Zoom slider in Microsoft Word and one little-known trick that works in other Microsoft Office apps, Excel and PowerPoint. Plus a related Windows volume tip. Scroll to View Zoom Hover the mouse pointer over the Zoom slider (bottom right in Word, Excel
This is how to change Word’s Zoom to your preferred Zoom settings instead of the defaults. Ray R writes … “I have been having some vision problems lately and have found that using Word’s zoom dialog to increase the displayed font size without changing it in the document or email
Understanding the difference between the United Kingdom, Britain, and England can be quite confusing. Here are some “simplified” “diagrams that might clarify things. Use this or make a SmartArt version for your PowerPoint or Word document. The late Michael Flanders had warning about usage of the terms. If it’s something good then
Excel 365’s Linked Data Types are technically impressive. However, the reliability of the data is a problem Microsoft doesn’t talk about. We discovered mistakes with the data without actively looking for them. In general, the data sources are ‘scraped’ from sites like Wikipedia which explains some, but not all, of
Excel 365’s Geography data type isn’t totally reliable or accurate. Looking at its results for the UK (United Kingdom) vs Great Britain is just one example of the problems you need to watch out for. If you’re not clear on the difference between United Kingdom and Great Britain, see below.
The BBC has released some high-quality images from their famous TV shows to be used as online meeting backgrounds or in PowerPoint slides. Pick from Doctor Who (old or new), Fawlty Towers, Yes Minster, Match of the Day, Eastenders and more. Consider using these BBC TV backgrounds in PowerPoint for
Some imported Outlook calendar items can’t be changed, here’s why and how to make the imported appointment editable. Understanding issues with an Outlook imported appointment can help you manage calendar inconsistencies. Usually an imported appointment (via a downloaded .ics file) can be edited just like most Outlook calendar items. Often
Zoom has a browser-based word processor to their Workplace range with some interesting features including what they call the Magical Key. Zoom Docs word processor aims to enhance productivity within its collaborative environments. Zoom Docs is designed to be used within Zoom group calls and many of the templates reflect
Microsoft says that the new Outlook for Windows is now generally available, but everyone should ignore that. Outlook (new) isn’t truly ready. It lacks vital features and has serious security shortcomings which are likely to frustrate anyone who relies on it. On 1 August 2024, Microsoft declared that Outlook (new)
Microsoft’s eventual replacement Outlook (new) for Windows supports Gmail, Yahoo and other accounts but there’s a privacy trap that Microsoft does its best to hide. Outlook for Windows privacy is a major concern. According to Microsoft, it’s easy to add Gmail, Yahoo and other accounts to the new Outlook, all
Can Microsoft Word handle a newly famous name “Walz” or does Word think it’s a spelling error? What about the other VP candidate, “Vance”? In the last few hours, we’ve seen social media posts like this: “ Okay, word people, now would be a great time to put a “Walz
We’ve expanded our live Paris Olympics medal table to compare countries’ performances to their population or wealth. Along the way we explain how to cope with some problems that can arise when Excel theory hits the Real World. Our newsletter readers get a working example workbook to try themselves. We
Microsoft shareholders should be happy with the company’s latest financial results for the quarter ending 30 June 2024 (Q4). Here’s a few highlights from an “Office Watch” point of view. Office 365 Commercial Revenue growth was up 13% possibly due to the new Copilot for Microsoft 365 fees. (All these
Excel for Mac is now getting the ‘From Folder’ option in PowerQuery. An important part of the PowerQuery puzzle. PowerQuery’s ‘From Folder’ lets you add more data to a query simply by adding data files into a folder. PowerQuery will then scoop up all the data and add it to
The Dictation feature in Outlook for iPhone, iPad and Android will leave the apps in September for no reason Microsoft will share. The announcement was made discreetly so that only Microsoft 365 non-consumer accounts with Admin access are notified. Message MC841218 “We will be retiring the Dictation feature from Microsoft
Paying Copilot Pro customers have lost a major part of what they pay for. Say goodbye to Copilot GPT Builder in early July 2024. It’s only been a few months since Microsoft launched their paid AI plans including Copilot Pro and they are already removing a major component. Copilot GPT
Here’s how to save a Word document with the private and hidden details automatically removed. Normally, you’re expected to manually go to File | Info | Inspect document to check/remove things like comments, hidden text, header, footers or watermarks. What if you want it to happen automatically, whenever you save
Use Excel to get your own automatically updating Medal Table for the 2024 Paris Olympics then make charts and maps too. Our newsletter readers get a working example workbook to try themselves. Not interested in the Olympic medal count? This article and download are a good, working example of how
Here’s some more ordinal rank (First, 2nd etc.) options for Excel including with joint or equal results plus special fun wording. In a previous article we looked at options for showing ordinal numbers in Excel, now we’ll go a step further to cope with joint or equal results plus special
Here’s the complete step-by-step manual method of replacing text with filler or anonymous words in Microsoft Word. This is quite easy, the main thing is to be careful with the Find and Replace expressions. It will work with any version of Word that has the ‘wildcards’ / Regex option which
A US government department has accidentally revealed a secret by overlooking the obvious in Office document security, the file name. Microsoft Office helps you scrub documents of private or secret information before sending. It’s easy to overlook the obvious data leaks that ‘Inspect Document’ doesn’t cover. ‘Inspect Document’ checks for
Add to your Outlook a special Paris 2024 Olympics calendar shows all the events plus opening/closing ceremonies with times in your location and search for favorite events. A special Olympics calendar shows all the events plus opening/closing ceremonies with times in your location. This calendar shows the Olympic calendar in
