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.
Microsoft charges quite different prices for Office 365 Home and Office 365 Personal, depending on the country. We decided to see how cheap or expensive Office 365 Personal plan can be, depending on where you live. Maya surfed through many different Microsoft sites to compile this list of countries and
We’ve talked, at length about Excel’s Rank()/Rank.EQ functions and coping with joint or equal rankings. What about Rank.AVG()? Rank.AVG() works differently for equal rankings because it returns an average of the combined rankings. For example, joint 3rd place getters will return the value ‘3.5’ by Rank.AVG() which is the average
So many patches for Microsoft Office and Windows in this month’s package of bug fixes. Few parts of Windows or Office aren’t patched this month, either directly or indirectly. According to Microsoft there’s ‘only’ 56 patched security holes in their products, this month alone. In reality there’s a lot more
Back in Excel 2007, Tables were added. That simple name hides a quite different and powerful Excel option that, in our view, Microsoft hasn’t explained very well. Excel is often used for lists and Excel Tables make managing and extending those lists a lot easier. In fact, ‘Excel Lists’ was
There’s so much information and mis-information about the Spectre and Meltdown chip problems, we’ve decided to have a look at what Windows and Mac users need to do about Spectre/Meltdown, what not to worry about, plus some trivia and nerdy details. A quick What to Do that quickly tells you
It doesn’t take a lot of effort to stretch up to three extra months out of your Office 365 Home or Personal plan. In other words, 15 months for the price of 12. This is based on the experience of reliable Office-Watch.com users who can stretch the proverbial penny better
All the ‘End of 2017 news reviews’ reminded us of the great ‘Covfefe’ debate. President Trump made a tweet typing error, adding the previously unknown ‘covfefe’ to the language. It’s believed to be a mistype of ‘coverage’ though neither the President nor his staff would admit that. Word 2016 for
Crossover, the Windows emulation for Mac computers, has released v17 which adds support for Office 2016 for Windows. With Crossover v17, the default compatibility has changed from Windows XP to Windows 7. That’s a big improvement and opens the way for a lot more recent programs to run like Quicken
It’s time again to see how Microsoft Word’s spell checker goes against the newest words in the English-speaking world. We’ve taken the “Word of the Year” from various dictionaries plus some other 2017 contenders and typed them in Word to see if the red squiggle appears. We used Word 2016
The FBI is using evidence from Microsoft Word to oppose a change of release conditions for former Trump campaign chairman, Paul Manafort. We’ll show you the mistakes that were made and how to avoid them. We’re not interested in the prosecution itself nor the politics, here’s a summary. Our focus
The Australian tax authorities have released some interesting data about the biggest corporate (non) taxpayers in an Excel format. It’s raw data ready for extra calculations, charts and PivotTables. Another example of how publicly available data can be used by anyone to dig into previously obscure areas using Excel tools.
You’re not locked into the PivotTable sorting options provided by Microsoft. Excel lets you arrange a PivotTable into any order you like. Right-click on a PivotTable column and choose Sort | More Sort Options | Manual. How to Drag and Sort It’s not obvious how to select an item (row
Sometimes you want to sort a list or PivotTable in a special way that doesn’t fit the usual ‘A to Z’ or number order. The most common need for this are days of the week or months in a year. Neither of those orders make sense to a literal computer.
You still want to explore more Excel PivotTable sorting, there are some additional options like Click More options button on the Sort dialog box. The More Sort Options dialog box appears for your Sorting list of the Pivot Table. Let’s see what these additional features can do for you: As
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
