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.
Excel allows you to sort a PivotTable in alphabetical order or from largest to smallest values. They are similar to the standard Excel sorting options but worth looking at separately because there are automatic sorts, custom sortings and a manual sorting option. Quick PivotTable Sort Sort the PivotTable by right-click
There are interface changes coming to Outlook for Windows and Mac which Microsoft quietly previewed recently. As usual, interface changes are accompanied by the same vague promises and jargon. Long standing Office users will find a lot of what follows to be tiresomely familiar. We’re told this change will ‘increase
Apple has introduced a new image and video format for iPhone and iPad, here’s how to handle it in Microsoft Office documents. .HEIC image files are made by default in some Apple devices with iOS 11. Microsoft Office and Windows don’t support the new format yet but there’s workarounds available
A recent Office addition is ‘Shared with Me’, a list of the documents you’ve been invited to collaborate on with others. It’s available in Office 2016 Windows/Mac and the iPad, iPhone and Android Mobile apps. According to Microsoft ‘Shared with Me’ ” lets you see the files others have shared
Office 2016 for Mac (Office 365) has the same document sharing options as Office for Windows but they look a little different. In fact, Office for Mac has an additional sharing option not available in Windows. Just like Office 2016 for Windows, Office 2016 for Mac has a Share button
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
