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 hasn’t had a good week with their hosted email with two breakdowns of Exchange Online and Outlook.com services. One stopped emails in and out, the other prevented messages from being read. Both Exchange Online (Microsoft 365 hosted email) and Outlook.com run on the same or very similar systems. Usually
Use Sequence() to get an ordered list of numbers either increasing or decreasing and with your choice of increments. Sequence is possibly the least understood of the dynamic array functions but combined with other functions it greatly extends Excel’s power. Sortby(), Filter(), Unique() and RandArray() all have obvious uses but
There are a few strange, non-standard, behaviors to the FollowedHyperlink style that Word uses for visited links. FollowedHyperlink is a hidden style which Word uses for any link which has been clicked or visited by the current user. Because it’s automatically applied it has some peculiarities that don’t apply to
Word has special styles for hyperlinks which you can change from the standard blue, underlined look. Word link styles have some special behaviors to keep in mind. Word links can look very different or appear no different to regular text. All these are hyperlinks, believe it or not. Hyperlink and
With Random.org you can get truly random numbers for Excel plus options not available in the spreadsheet program like random but unique numbers with no repeats and random dates. Using ‘True’ Random numbers in Excel Our article on Random Numbers in Excel continues to surprise us by being one of
Bahnschrift is a Windows font which is a little special and not fully compatible within Office. We’ll explain why it’s special, the extra care needed and the workaround. While it’s listed as an Office Cloud Font, Bahnschrift was originally included with the 2017 ‘Creators’ update of Windows 10. So, it
There are two a simple ways to make a list of unique or non-duplicate entries from a longer list. Unlike the many automatic ‘unique’ options in Excel, these options work only once but it’s available in many Excel releases, old and new. Advanced Filter One is hiding at Data |
Since we’re talking about Star Wars, how does Microsoft Office 2016 for Windows handle the words and names from the famous films? A mixed bag. Most of the common names are in the MS Office dictionary but some surprising omissions. The evil Emperor isn’t included. Planet Tatooine has a major
The new Unique() dynamic array function doesn’t let you do anything new in Excel, but it makes a once-complicated task into simplicity itself. Unique or distinct, no-duplicate lists, counting and sorting the results are all possible with easy formulas that won’t confuse. For as long as there’s been Excel, people
Excel’s Unique() function itself can’t show distinct values that appear more than once in a list. Repeated only items in a distinct list are possible with a simple extended formula. We’ve already shown the basics of Unique() either getting a list of Distinct values or values that only appear once
Microsoft has decided that Calibri is getting a little tired, so it’s asking customers to vote on which font will replace it. Calibri has been the default font since Office 2007. It’s familiar to most people whether they realise it or not because it appears in many Word documents. The
The new iOS 14.5 has hundreds of new emoji but beware using them in emails and documents because they can look very different on other computers. We have examples of how a simple emoji can look very different in Word or Outlook. The new version of iOS for iPhone and
Thanks to Office-Watch.com reader, Pierre B. we can tell about a good deal on Microsoft 365 Personal or Family, now available from Amazon in Canada. Microsoft 365 Personal cheaper The usual price for Microsoft 365 Personal (12 month, one user) is CDN$79.99, but Amazon.ca has it for CDN$48.99. Here’s the
Microsoft is updating their Services Agreement, the rules we call agree to live with when using Microsoft’s many services. We found a few interesting things in the changes. The Summary of Changes to the Microsoft Services Agreement is mercifully short. Compared to full agreement of over 15,000 words which is
Learn how to create live, dynamic sorted lists in Excel using the powerful combination of Sort()/SortBy() and Filter() functions. In Excel 365 and Office 2021+ dynamic array formulas like FILTER() let you extract a subset of data — and by wrapping that result inside SORT(), you can instantly sort the
Your first look at Office 2021 for Mac with Word, Excel, PowerPoint and Outlook, which is now out in public preview, showing off some of the new features. There’s only a Mac Office 2021 preview, no Office 2021 for Windows preview. Perhaps because there’s a few more innovations in a
Filter is another Excel 365 dynamic array formula that’s really useful and far better than similar options in earlier versions of Excel. Just like SORT() and SORTBY(), FILTER() refreshes automatically whenever the source values change. The older pull-down filter and sort choices don’t update properly. Dynamic Arrays also give you
Confused about Unicode, code-points and other techie details about inserting symbols? Here’s how it works and can work for you in Word, Excel, PowerPoint and other apps. Like many things in modern computing, you mostly don’t have to know the details of how things work. But occasionally things don’t work
Microsoft has been changing the way comments work in Office 365 and now it’s the turn of Excel 365 to get the new-style conversational comments. If you’ve opened up Excel 365 recently you might have seen a notice like this: “ Comments can now be used for discussions. When you
In late 2018, Excel 365 got an important new feature, Dynamic Arrays . Here’s a simple way to use the feature to make your workbooks sort better and automatically. It also fixes a long-standing problem in Excel. We’re going to focus on a very simple and useful part of dynamic
How to insert the Double Vertical Bar ‖ into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Double Vertical Bar ‖ symbol is used to represent norms in mathematics, (for example ). It can also be used to signify parallel lines. It can
Type the Cross of Lorraine ☨ into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Cross of Lorraine ☨ symbol was originally a heraldic cross. In more recent times it was used in the global distribution systems, Sabre, Apollo, and Wordspan, as a delimiter
Windows has some nice features for quickly showing your appointments, calendar and contacts/people lists so why don’t they show that information that’s in Outlook for Windows on the same computer? In Windows 10, clicking on the date/time in the bottom right-corner (the taskbar) you’ll see the monthly calendar and either
=Rand.old() is a Word trick which adds common sentences that use all, or most, of the letters in that language’s alphabet. Here’s what Word does in English, French, German, Danish, Polish and many other languages. It’s useful filler text for testing formatting or other Word features just like “Lorem Ipsum
