All about Microsoft Office for Apple Mac. Word, Excel, PowerPoint, Outlook on macOS, Microsoft 365 for Mac, Office 2021 for Mac and earlier versions.
Excel has ‘real’ Regular Expression functions
Microsoft Excel 365 has built-in support for regular expressions (regex). The functions REGEXTEST, REGEXEXTRACT and REGEXREPLACE have powerful pattern matching, text extraction and replacement directly into spreadsheet formulas, eliminating the need for VBA, add-ins or convoluted workarounds. Even better, the functions use a widely understood form of Regex for text-manipulation capabilities, data cleaning, validation and […]
All the Outlook solutions to ‘Spy Pixels’ in emails
The many different Microsoft Outlook versions have a way to block images linked to emails, that includes the so-called ‘spy pixels’ used by many companies. See ‘Spy Pixels’ email epidemic, the good and the bad You can choose to view pictures in an Outlook email by clicking a button at the top of each message. […]
Important Microsoft 365 and Office events to watch in 2025
2025 promises to be ‘interesting’ for Microsoft 365 and Office users, not always in a good way. Here’s some of the predictable events. What I can guarantee in 2025 is more Copilot and Outlook (new) hype – some justified and some stretching credibility. Happy New Year! Office 2016 and Office 2019 end All Office 2016 […]
Microsoft 365 money saving chance – if you act now
Microsoft 365 Family and Personal users have a chance to beat the price rise widely expected to come in 2025. You can lock in the current price for up to five years. Why the expected price increase for Microsoft 365? Microsoft has already raised the price of Microsoft 365 in some countries with the “Microsoft […]
Adding your name and other personal words to Microsoft Word
If Word doesn’t recognize personal words such as your name, the name of your hometown or the name of your favorite actor, it flags it as a mistake with the familiar red squiggly line. Here’s how to fix that. You can choose to add your words to the app’s custom dictionary. This is one of […]
Great Excel monthly calendar from just one cell
Modern Excel lets you make a whole monthly calendar from just one cell formula. We’ll explain how it’s done with a sample workbook for our supporters. At its simplest, Excel can make a single month like this from a formula in cell A6 which fills all the cells with the correct dates for that month. […]
Bad news for Microsoft 365 customers, Skype Credit has ended
Skype has stopped their Skype Credits service which is bad news for Microsoft 365 consumers who took advantage of their monthly 60 minutes of free calls to worldwide phones. Without notice, Microsoft stopped both Skype Credits and Skype Numbers (incoming phone numbers to your Skype account). What’s now appearing at https://secure.skype.com/en/credit/ is bad news. Savvy […]
Everybody loves FRED, including Excel
Get Economic data or graphs from FRED (Federal Reserve Economic Data) to load into your Excel workbooks or PowerPoint slides. From unemployment rates to the price of potato chips. FRED has 825,000 data sets for the USA and around the world. Tip: search FRED for your country (Canada, United Kingdom, Australia etc) to see what […]
Show currency in Excel with country and symbol
How to show currency amounts in Excel with the country and correct currency symbol included. Excel doesn’t support the standard way that different currencies are displayed with their country codes like this: Dig into the Accounting/Currency Formats and you’ll find these among a VERY long list of currency symbol options. All those options let you […]
Pantone’s 2025 color ‘Mocha Mousse’ in Word, Excel and PowerPoint
Pantone’s color of the year for 2025 is “Mocha Mousse”. You can use that exact color in Word, Excel, PowerPoint, Outlook and Designer using the Hex/RGB color code. And we’ll look at the flowery prose that’s become a hallmark of this annual promotion. The color of 2025 is … Mocha Mousse We make fun of […]
All you can do with PowerPoint Action Buttons
Action buttons in PowerPoint are versatile tools that bring interactivity and control to your presentations. By following a few simple steps, you can insert and customize these buttons to perform tasks such as navigating slides or opening external applications. Incorporating action buttons can greatly enhance audience engagement, making your presentation more dynamic and interactive. Whether […]
Make your own London Tube sign for Word or PowerPoint
The famous London Tube Roundel or station sign is easy to recreate for Word, PowerPoint or other Office apps. The best way to do this is SVG graphics in Microsoft 365, Office 2024/2021/2019/2016. SVG’s let you change the colors and set the text easily. They don’t have to be a railway sign. Use the roundel […]
UK Deal alert: save on Microsoft 365
Amazon UK have a great deal on Microsoft 365 Family. There’s a minor condition which is easily bypassed once you know the trick. Office Watcher, John F, let us know about this offer at Amazon UK. Alas, the original offer didn’t last long but the replacement deal is still worth considering. It’s a good price […]
An Excel shortcut that can speed (or confuse) your day
Enter the Ctrl + – (minus) shortcut in Excel. This powerful shortcut instantly deletes entire rows or columns without any confirmation. But there’s hidden trickery going on and some misleading info online. Ctrl + – is commonly said to “delete the selected row or column” but, as usual, the reality is more complicated. Some online […]
Why Microsoft’s “Connected Experiences” page is not an AI conspiracy
The idea that Microsoft is using Word, Excel or other documents to train their Copilot AI system won’t die. Let’s debunk one too often repeated myth about Office “Connected Experiences” which is not proof of a Microsoft conspiracy to steal customers work. We’ve gone into detail about what isn’t or might be used to train […]
Is Microsoft using your data to train Copilot AI – the facts
Social media is full of allegations that Microsoft is spying on customers Word and Excel documents to train their Copilot AI system. Here’s the facts and the ‘gotchas’ that Microsoft leaves unanswered. In this article we’ll go into the possibility of Microsoft ‘spying’ on customers. We’ll start with a summary then dig into the details […]
