All about Microsoft Office for Apple Mac. Word, Excel, PowerPoint and Outlook on macOS
Microsoft 365 for Mac, Office 2021 for Mac and earlier versions.
The Share pane in modern Office is fine within an organization or with people who are familiar with document collaboration. But what if you want to share a document link with more detail in the email or using a non-email method like Instant Messaging? Well, you want to get just
Ever since Microsoft added shared, collaborative documents via OneDrive, they’ve had problems with saving and sign-in. Here’s how to deal with some of those persistent bugs. These bugs can happen in Word, Excel, PowerPoint or OneNote. Most commonly with documents saved to OneDrive but also Dropbox or other cloud storage.
A list with groupings (like Product Type, Country, Region or Staff pay level) can become a nested PivotTable. The sub-totals are created with + – signs to show/hide the groupings. We’re using the same source list as in our Basic PivotTable and Two-dimensional PivotTable examples. Doing that is simple, just
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
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
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
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
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
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.
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
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
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
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
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
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 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
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
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
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
An upcoming release of Outlook 2016 for Mac will get something that Outlook/Windows users take for granted: Read Receipts and Delivery Receipts. It’s hard to believe but the current and past versions of Outlook for Mac don’t have these features. Source: Microsoft The feature is now available in Outlook 2016
The ability to make a new Outlook item from an existing one by drag and drop is, finally, coming to Outlook for Mac. This feature lets you drag an email to the calendar or tasks folder, Outlook will make a new appointment or task using the email as a basis.
Shrill headlines talking about the ‘death’ of MP3. Here’s how Microsoft Office is affected (hint: not a bit but you might start moving away from MP3 to the better MP4). Audio and video support mostly applies to PowerPoint. Microsoft Office supports a range of different audio formats including MP3 but
Apple has announced a change to how third-party products, like Microsoft Outlook, connect to iCloud services. From 15 June 2017, you’ll need an ‘app specific password’ for Outlook and other programs to connect with Apple services. This makes two-factor authentication for Apple ID’s compulsory if you use external products. Two-factor
Microsoft played a great PR game over the last few days. They managed to deflect responsibility for the WannaCrypt ransomware global outbreak and even make the company look like the victim. Make no mistake, the main responsibility for the WannaCrypt trouble lies with Microsoft. Some blame can be directed to
