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.
In August there’ll be some good changes to Office 365 activation for commercial customers. The per device activation limit will be handled in a much better way. Each Office 365 user is limited to login/activations on five each of desktop programs, tablet apps and smartphone apps. That’s a total of
Microsoft’s Home Use Program is a great way to get Office cheaply including Office 2019, Visio Professional 2019 and Project Professional 2019. The Home Use Program (HUP) has been a way to get Microsoft Office for less than retail for a long time. It’s available to many companies, organizations and
Microsoft Word has several ways to quickly insert placeholder text into documents. Sometimes you want to add some random text to a document as filler, but don’t want to think of something to write yourself. While there are websites that will generate placeholder text for you, it is also possible
Our articles about saving past events with anniversary reminders begs the question; How far back can Outlook save an event. The answer in Outlook for Windows, Mac and online is 1 April 1601. Trying to enter a date before 1st April 1601 brings up an error: “You must specify a
Here’s a practical example of how to share an appointment or event with reminders using the iCalendar .ics standard. Some Apollo 11 events ready to download and add to your calendar (in Outlook or other software). Outlook supports .ics files and so does most other calendar programs. They are small
Here’s the enhanced Apollo 11 mission timeline as an Excel worksheet. Office Watch newsletter readers asked for it after last weeks articles using the NASA web page as a data source. Complete Apollo 11 timeline in Excel Things to do with the Apollo 11 timeline in Excel Apollo 11 suggested
An Excel worksheet with Apollo 11 timeline can be used to analyze and breakdown the astronaut’s movements plus answer the big question: what time was it when Armstrong walked on the moon? See how we put the Apollo 11 timeline into Excel using Get & Transform or the older Copy/Paste
NASA has a detailed web page with the timeline of the Apollo 11 mission from before liftoff to well after splashdown It’s an example of the two ways to put a web table into an Excel worksheet. Newer Excel (365, 2019 and 2016) has PowerQuery with ‘Get and Transform’ which
Amazon Prime members might have a chance to get Office 365 cheaply while the Prime Day deals are on. The Amazon ‘Prime Day’ runs for two days (go figure), Monday 15th and Tuesday 16th apparently according to local time zones. Office 365 Home is often discounted but rarely to the
Sketchy Shapes, the new line option in Office 365 now has a little video to go with it. Sketchy line option in Office for Windows and Mac Sketchy or wriggly lines in Icons and SVG graphics Source: Microsoft
The 50th anniversary of Apollo 11 is our excuse to show-off some features in Outlook for Windows/Mac. How to add past events, post events in other time zones, get reminders of upcoming anniversaries and set reminders for longer times than Outlook allows. Adding Past Events Outlook can save details of
PowerPoint for Windows and Mac getting much better ink replay and animation support as shown in a new build for Office Insiders. Up to now, digital ink drawings could be replayed as a simple animation. That’s been available for about three years starting with OneNote Mobile. That was OK but,
Back in the 16th Century, italic fonts were invented and that trick can still be used today in Microsoft Word. Italics let you fit more text into the same space. An innovative Venetian publisher, Manutius, needed to make small and affordable books. Paper was expensive so anything that put more
It’s time for the July roundup of patches for yet more security bugs in Microsoft Office including Office 365 and Office 2016 for Windows plus Office 2013 and 2010. Plus the latest example of confusing documentation errors. Office 365 and Office 2019 A bug which lets Office Javascript doesn’t check
Here’s another case of someone trying to backdate fake documents and being caught by hidden details in the file. The font is the giveaway but not in the usual way. It’s the ongoing saga of Craig Wright, once a big name in the cyber-currency game. He’s now involved in a
Microsoft is expanding OneDrive storage for paying customers, either as part of an Office 365 plan or paying separately. Office 365 Home, Personal and other plans already include a Terabyte of OneDrive cloud storage per user. Now it’s possible to expand beyond 1TB online storage, for a monthly fee, up
Microsoft is hyping the addition of 300 more icons to Office 365 perhaps hoping to distract customers from the many problems finding and using the Insert | Icons feature in Office 365. We like the addition of SVG graphics (Icons) into Office because it opens up a much wider range
Microsoft is boasting that the Office 365 ‘Icons’ collection now has 300 more graphics but no information on what they are and no help finding them. The release of more Icons just emphasizes the problems with this cloud feature. Icons is a cloud service that delivers SVG graphics to Word,
Outlook for Mac (2016, 2019 and 365) has a Weather Bar similar to Outlook for Windows with differences both good and bad. Turning the Weather Bar on or off plus the Fahrenheit / Celsius choice is at Outlook | Preferences | Calendar | Weather. Like the Windows version, it’s not
Drop-down list boxes are useful in Excel but, like many things in Office, there’s more than one way to do it and more to know that the simple examples often given. Making a pull-down list is easy and there’re many tips showing the basics. In this article we’ll go beyond
Microsoft’s PR department must be laughing themselves silly this week. A press release for an existing Excel feature is getting wide coverage even though there’s nothing new and the feature is at least six months old. The blog posting on 5 June 2019 announces Microsoft is working with “Nasdaq and
While most Office users have nothing to worry about, there are big changes in the next macOS codenamed Catalina. macOS v10.15 Catalina is out now for Mac computers and represents a major change. See MacOS Catalina update tips and Office compatibility Catalina = 64-bit programs only For the first time, macOS
Here’s some other problems with the Word Sort feature and tricks to work around them. Generally speaking, long or complex sorting is better done in Excel. Excel has much better data management features to split and sort. The final result can be copied into Word. Sort a list of names
Microsoft has released a series of pages describing their support for the new Japanese era in Windows, Office and .NET. Plus a new Windows feature to support a nicety of Japanese date formatting. Japan’s traditional dating system works around the Emperor’s reign. The abdication of the last Emperor and enthronement
