All about Microsoft Office for Apple Mac. Word, Excel, PowerPoint, Outlook on macOS, Microsoft 365 for Mac, Office 2021 for Mac and earlier versions.
Make your first Two-dimensional PivotTable in Excel
We started with a simple Excel PivotTable, now let’s move on to a multi-column or two dimensional PivotTables. They aren’t a lot more complicated than a basic PivotTable, just add a few more fields. We’ll start with the same sales list that we used for our PivotTables 101 article. This time we’ll make a more […]
Get the new Crayola color, Bluetiful, now in Microsoft Office
Bluetiful will be the new Crayola color. It’ll be generally available from January 2018 or you can use it right now in Microsoft Office with these tips. Office-Watch.com told you about the demise of Dandelion, the now defunct Crayola color. And we showed how to keep Dandelion in your Office color palette regardless of Crayola […]
Why bother with Excel PivotTables?
PivotTables really are great and we’re not just saying that because it was one of Bill Gate’s favorite features. The original PivotTable feature was clumsy and difficult so you’re forgiven for trying them and giving up in disgust. Mayurakshi wants to show you some of the nifty parts of PivotTables but before that she’ll of […]
Reduce the disk space used by Outlook for Mac
Outlook for Mac is a disk space hog but the macOS has a way to recover some of that. Mac computers can have relatively small hard drives like 128GB or 265GB which Outlook 2016 for Mac can gobble up. Unfortunately, Outlook for Mac, even the latest Outlook 2016 doesn’t have some of the space saving […]
Office for Mac – interesting things coming
Office 2016 for Mac is getting some big improvements in the next few months. That’s not just Microsoft hype, it seems very real. Last week, Microsoft quietly declared that they were making some big changes to how Office 2016 for Mac works. Those ‘under the hood’ changes would let them add new features a lot […]
Read Receipt responses in Outlook Windows / Mac
Here’s how to control what Outlook does when it gets a Read Receipt request with an incoming email. The setting is at File | Options | Mail | Tracking, just below where you set the options for outgoing Read Receipts. That’s Outlook for Windows, see below about Outlook for Mac. The choices are: Always send […]
Power Excel lists for comparison shopping
Make smarter decisions with Excel’s tables and lists. Excel is a great place for comparison shopping or deciding which product to buy. Unlike Word or OneNote, Excel has tools to sort, filter and do calculations to help you narrow down many choices to just a few or one. In this article we’ll show you a […]
Animated GIFs in Outlook messages, but not all Outlooks
Outlook for iOS and Android has a of plugin with support for animated GIF’s which is very strange indeed. Gfycat has released a plugin for Outlook iOS and Android that lets you choose animated GIF’s to insert into your messages. Source: Microsoft/Gfycat You can add animated GIF’s to emails from the Outlook app, but they […]
Changes to Office for Mac – get ready now
There are changes coming with both Office for Mac and Apple’s MacOS which Mac users need to be aware of. Office 2011 for Mac Office 2011 for Mac will lose support on 10 October 2017, just over month from now. After that date there will be no more updates, especially security updates for Office 2011. […]
Back to School tips for buying Microsoft Office
It’s back to school time in the USA, rushed parents in stores with long lists of supplies. Here’s some tips for getting Microsoft Office for less. Do you already have Office? Maybe you’ve already got Microsoft Office? Before buying, make sure you’re not already entitled to use Office. Some schools have bought a school-wide licence […]
Delete or reorder PDF pages – free!
Here’s how to delete whole pages or rearrange the page order from a PDF document without paying for PDF editing software. A lot of people never need PDF editing software. Making PDF’s is easy using Microsoft Office or the ‘Print to PDF’ feature in Windows. Simple editing, like deleting pages or rearranging the order of […]
How to make Office for Mac speak
On Macintosh computers, the speaking is entirely done by the macOS not Office for Mac To enable speech to text, go to System Preferences | Accessibility and look for the Speech option. Speak selected text when the key is pressed – lets you choose a shortcut key.
Excel security patches for July 2017
Excel is main focus of this month’s security patches from Microsoft. It’s a familiar story, so Microsoft recycles their stock phrases from similar security lapses in the past. A ‘specially crafted’ document can cause a ‘memory corruption’ in Office. The July 2017 patches fix not one, but two separate design errors in Office. All supported […]
Spelling Bee winners 2017 vs Word
Each year Office-Watch.com has a little fun seeing how Microsoft Word’s dictionary compares to the winners of the Scripps (US) National Spelling Bee. Word did better in 2017 than past years. Still, no chance of Word reaching the finals in 2013, 2014, 2015 , 2016 and now 2017 despite being much older than any of […]
Office 2011 for Mac – time is running out
Support and patches for Office 2011 for Mac have only a few months left to run Mainstream supports ends on 10 October 2017 That date is based on the release of Service Pack 3 on 29 January 2013 plus a special extension by Microsoft. According to Microsoft the 21 month extension was “… to provide […]
Office for Mac support with the new macOS ‘High Sierra’
Microsoft has given some guidance about Office for Mac support on the upcoming MacOS ‘High Sierra’ 10.13. But not without a little encouragement to buy the Office for Mac. High Sierra will be publicly released in the (northern) autumn and some testers will have it already. There will be a public beta release later in […]
