All about Microsoft Office for Apple Mac. Word, Excel, PowerPoint, Outlook on macOS, Microsoft 365 for Mac, Office 2021 for Mac and earlier versions.
Office 365 Home/Personal activation changes make sign-in better
Microsoft is improving (fixing?) the activation system for Office 365 Home and Personal customers. This comes a few weeks after they announced the same changes for Office 365 Enterprise 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 […]
Do you have Dynamic Arrays in Excel 365?
It’s quite easy to tell if your Excel 365 has the new Dynamic Arrays. No need to setup a table and use the new feature – just three keypresses are enough. Some people are reporting that they have the right Excel 365 but with no dynamic arrays. Checking the program/app version is possible, see below. […]
Excel now has Dynamic Arrays – Windows, Mac and more …
After many months of testing, all Excel 365 apps now have dynamic arrays (except Excel Online) though some are just for Insiders at present. Dynamic Arrays are a major and powerful expansion of Excel’s powers. The new abilities, functions and error messages might seem scary but are a great leap forward for Excel. All Excel […]
Making Word work for Jacob Rees-Mogg’s style rules
A newly promoted UK politician has his own special style guide for staff, here’s some Word features that can help ensure your documents are approved by the boss. The Right Honourable Jacob William Rees-Mogg (to give his new full title) proudly affects an old-fashioned demeanor and has been described as “on secondment from the 18th […]
Office 365 activation improvements but not for everyone
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 15 devices with a single […]
Cheap Office 2019, Visio and Project on the Home Use Program
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 government entities with Software Assurance […]
Complete guide to adding placeholder or filler Text in Word
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 to do this directly within […]
What’s the earliest date possible in Outlook and workaround.
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 valid date and/or time”. That […]
Apollo 11 events to download and add to a calendar
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 text files which have all […]
Apollo 11 mission timeline in Excel
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 viewing and reading The full […]
Things to do with the Apollo 11 timeline in Excel
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 method. Also Add Apollo 11 events […]
Complete Apollo 11 timeline in Excel
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 is much better. The older […]
Office 365 discount for Amazon Prime members
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 extent that the Prime Day […]
Now … Sketchy Shapes the video!
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
Add Apollo 11 events and anniversary into Outlook
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 past events. That it’s in […]
Much better Ink replay animation coming to PowerPoint
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, as we noted back in […]
