All about Microsoft Office for Apple Mac. Word, Excel, PowerPoint, Outlook on macOS, Microsoft 365 for Mac, Office 2021 for Mac and earlier versions.
How to count unique items in an Excel PivotTable
Excel PivotTable can show a count of unique items if you know where to look. Handy to see the number of customers, products or students from a long data list. What is the count of unique customers who made purchases in each region? How many unique products were sold in each store? How many different […]
Recycling – good. Paper shredding – good. Together – not so good.
Paper shredding isn’t always welcome as recycled paper. Turns out there are hidden complexities even to just protecting your privacy and reducing waste. Wirecutter at The New York Times surprised us by explaining how putting shredded paper in a recycling bin can create all sorts of trouble. Shredded paper can cause problems at recycling facilities, […]
Smaller images make smaller documents in Word and Office
Pictures in Word, Excel, PowerPoint and Outlook can make the file sizes at lot larger than you expect. Here’s how to make images smaller (in file size) for Office documents without changing the look of the document, slide etc. The images in a document are what take up a lot of space in most documents. […]
Microsoft (again) announces 365 Basic plan extras
Microsoft has announced ‘extras’ for Microsoft 365 Basic but we can’t see anything new that wasn’t promised over a year ago and delivered six months ago. It’s a just a simple PR stunt that worked. The ‘Microsoft 365 Basic’ plan has just 100GB of OneDrive storage plus a 50GB Outlook.com mailbox for US$19.99 a year […]
Paper Sizing tricks in Microsoft Word
The world can be divided in many ways — how about by paper sizes? Letter/Legal/US sizes vs A4/Metric. Microsoft Word makes it easy to cope with both even with different paper sizes in one document. There’s a very handy way to rescale between Letter <> A4 for printing. Amazing Maps on X/Twitter shows the two […]
Coin 🪙 emoji in Word, Excel, PowerPoint and Outlook
How to insert the Coin 🪙 symbol or emoji into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. How Coin 🪙 looks in different fonts Only Segoe UI Emoji font has the coin symbol in standard Windows. Coin 🪙 codes These are the important code numbers or values […]
Why are Teams and Office divorcing?
Teams app is being forced out of the Microsoft Office bundle. It’s a compulsory divorce with a side-benefit for anyone who doesn’t use Teams or doesn’t use it often. Microsoft has now decided (under duress) to stop selling their Teams app as part of Microsoft Office / Microsoft 365 bundles throughout the world. That’s an […]
Pivotby – Excel’s new faster PivotTables
Pivotby() is a new and easy way to make PivotTables in Excel. It’s one of two new ‘aggregation functions’ but we prefer to call them fast summary powers. We’ll dig into the detail of what PivotBy() can do. Excel has been able to group or combine data for many years but now all you need […]
All about editing an incoming Outlook message
For many readers being able to edit incoming Outlook messages is just a handy feature, but for anyone in the legal or corporate world it could have ‘interesting’ consequences. In Outlook for Windows, open the email in a full window (not the Reading Pane) then go to Message | Move | Other Move Actions | […]
Credit Card 💳 symbol in Word, Excel, PowerPoint and Outlook
There’s more than one Credit Card 💳 image available in Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. How Credit Card 💳 looks in different fonts. Only two standard Windows fonts have the credit card symbol; Segoe UI Emoji and Segoe UI Symbol. The Apple device version is […]
Yes, there will be a new version of Microsoft Office
Here’s what Microsoft has confirmed for the new version of Office. Strictly speaking two new Microsoft Office, a consumer version Office 2024 and Office LTSC 2024. The next single payment “perpetual licence” version of Office will be Office 2024 (for consumers) or the very similar Office LTSC 2024 (for volume licences). LTSC = Long-Term Servicing […]
Start Grouping in Excel for better looking sheets
Grouping in Excel lets you collapse or expand sections of a sheet so you can see the ‘big picture’ but still drill-down to how totals were made. Another use for grouping is hiding rows or columns from view. You can organize and manage data more effectively by grouping together rows or columns. This feature is […]
Don’t trust any text message
The safest thing to do is NOT trust any text/SMS message from a bank, delivery company etc. The message might be real but could be a scam and you can lose thousands. Fake bank text messages, usually designed to make you panic and call immediately, are still catching thousands of people every year. This report […]
Five fast Clear options in Excel
Excel has some nice choices for clearing out cells quickly. You can remove the contents, the formatting only or both contents and formatting plus choices for deleting just notes, comments and cleaning up links. As you can see the drop-down menu Home | Editing | Clear offers options such as: Clear All, Clear Formats, Clear […]
PowerPoint – switch away from Aptos fonts
Here’s how to switch away from the new Aptos fonts in Microsoft PowerPoint and back to the old Calibri fonts or something else. Microsoft has forced a change to Aptos as the new default font in PowerPoint but that change doesn’t suit everyone. In particular, Aptos doesn’t make much (or any) visible difference for bold text. Both the paragraphs […]
Image restyling in Copilot
Copilot can change the style or look of an AI generated image to make endless variations on the same theme with a few clicks. We’ll show you how it really works and how to make it work even better. Ask Copilot for an image such as “make image of a Koala in the desert”, select […]
