All about Microsoft Office for Apple Mac. Word, Excel, PowerPoint, Outlook on macOS, Microsoft 365 for Mac, Office 2021 for Mac and earlier versions.
Beware the privacy trap in the 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 they show is entering an […]
Does Microsoft Word think ‘Walz’ is a spelling error?
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 vs. waltz” sticky note on […]
Olympic medal comparisons in Excel
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 compared population and GDP (Gross […]
Microsoft Office highlights in latest company results
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 % figures are comparisons with […]
Excel for Mac gets PowerQuery ‘from folder’ updates
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 Excel. Among the many choices […]
Major benefit removed from Copilot Pro
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 Builder was being dropped from […]
Many Ordinal RANK() options in Excel with joint, equal rankings, words and more
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 wording. On the left are […]
Replace Word document with anonymous text – complete Step by Step
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 means Word 2003 or later […]
How a file name can reveal your secrets
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 hidden information in the document […]
Paris 2024 Olympics complete calendar in Outlook
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 US Central time with the […]
Get a Paris 2024 Olympics event times into Outlook calendar
Here’s how to quickly add events from the Paris 2024 Olympics into your Outlook calendars, showing times in your location. The Paris Olympic organizers have provided an online calendar with .ics calendar files for individual events from their website. Those calendar files can be imported into Outlook for Windows or Mac. They’ve been well made […]
Does Microsoft Word know how to say “Kamala” properly?
Pronouncing the name “Kamala” is a source of confusion even to Microsoft Office’s Read Aloud feature which needs a little tweaking. How does Word’s grammar check handle the possessive, it is Harris’s or Harris’? Kamala Harris has a Sanskrit based name which is simple to pronounce once you know the correct way. We checked the […]
Why Crowdstrike might still strike you
There are two ways the fallout from the Crowdstrike troubles might affect people even if their computers didn’t ‘die’. First, some organizations are still recovering or are dependent on businesses that are recovering. Keep that in mind if there are problems with a company. (On the other hand, some organizations might use Crowdstrike as an […]
Nice new features in Excel on the web
Excel on the web has a new look and some nifty extra features like better ways to arrange rows/columns – move, resize, insert. A clever Freeze Pane option too. Some of these we’d love to see in desktop Excel. Overall, the web version of the Office apps now look more like the modern desktop apps […]
Microsoft Designer has discovered landscape images
Microsoft Designer’s Image Creator can now make landscape (wide) images as well as square and portrait orientations. Unlike Copilot which gives no orientation choice. Go to Image Creator and click on Size to see three options. Square (1024 x 1024) Portrait (1024 x 1792) Wide (1792 x 1024) Designers ‘Wide’ is almost the common 16:9 […]
Two better ways to Remove Background from images
Microsoft Office has a Remove Background tool for images but there are two better, faster and free ways to do the same job. Background removal lets you get an image with a transparent surround which can be merged/overlaid into any other slide or document more seamlessly (left) than a separate box with non-matching background (right). […]