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.
Changing an Excel formula into the values is amazingly easy. It’s just a copy and special paste. Another way to think of it is deleting the formula but leaving the results in the cells. Select the cells. In this case from our article on converting text cells into Excel dates.
The 2018 Scrabble World Championship is over. How does the Microsoft Word spell check fare against the Scrabble champs? Microsoft Word has slightly different dictionaries for many English language variations (US, UK, Australian etc). Word’s English dictionaries different from the official Scrabble dictionary. Among the words in the final rounds
A judgement from the US Court of Appeals turned on the Word Count feature in Microsoft Word and how it differs from the rules for court submissions. Most courts have rules about the length of submission which, in this case, were accidently exceeded. The plaintiff is representing himself (‘pro se’)
Adding or subtracting months in Excel is easier with the Edate() function. As you probably know, Excel uses whole numbers to calculate dates. Add 1 to an Excel date adds a day. How to add a whole month? How to make Excel jump a whole calendar month? For example from
An Australian university has developed a font that will help you remember what you read. It sounds like an April Fool’s joke, but the font is real and works in Office for Mac or Windows. Sans Forgetica was made at RMIT University in Melbourne, Australia. Unlike most fonts, Sans Forgetica
From today, 1 October 2018, Office 365 licencing rules change in a way Microsoft has never done before. Redmond announced the change a few weeks ago but now we can see the new Office 365 licence rules working, with a few unanswered questions. The change won’t affect your current Office
Office 2019, the new non-cloud version of Office for Windows and Mac, is now available to volume licence and commercial customers. This is the ‘cloud free’ or, as Microsoft call it the ‘on-premises’ version of Office desktop. It has no cloud related features and is ‘feature fixed’ with no future
A fun new font using famous logos for letters also demonstrates where Windows 10 and Windows 11 color font features become useful with Microsoft Word. Brand New Roman is a fun mashup font made up of famous logos. It looks best in color so it’s handy that Windows 11/10 supports
A new report from Sophos shows how hacking via Office documents has changed of lot in 2018 with new attacks coming much faster than in the past. Microsoft’s assurances that a security bug (sorry ‘exploit’) hasn’t been used ‘in the wild’ doesn’t mean a lot. Office document hacks made in
The upcoming changes to Office 365 mean a big boost for Office 365 Personal customers. They’ll get a lot more for their annual fee to Microsoft. At the moment, Office 365 Personal allows a single user to install Office on (quoting Microsoft). “1 PC or Mac, 1 tablet and 1
Microsoft has announced some truly important improvements in what you get with Office 365 Home, Personal and University plans. The Home plan will be available for six family members instead of five. How Microsoft calculates use of Office software is changing and for the better. All these changes apply from
If you get an error message when trying to activate Microsoft Office, settle in for a difficult time. Microsoft doesn’t make activation easy to understand, let alone fix activation problems. Office activation is where newly installed Office software is authorized by Microsoft’s servers. Without activation the software only has very
When you buy Microsoft Office there’s no CD or DVD with the software to install. The vital thing you’re getting is the Product Key. The Product Key is that the 25 character code which unlocks or activates the software. This applies to both Office 365 ‘subscriptions’ or single-purchase Microsoft Office packages.
After the report of buying illegal Microsoft Office via Amazon (and Amazon’s initially poor response) here’s what to do if you’ve bought an illegal, pirated or at least non-working Office Product Key. Credit Card as separate transaction Whenever possible, pay by credit card. The MS Office purchase should be a
After our recent Excel worksheet for visitors to Europe we were asked for a similar one to help people stay onside with the UK Statutory Residence Test (SRT). This is a test to decide if someone is a UK resident for tax purposes. Depending on the situation, a person can
Microsoft seems to be moving towards a name change for ‘Office 2016’. They haven’t announced anything directly, but their documentation is changing for Windows and perhaps Office for Mac as well. If you’re confused, don’t feel bad because Redmond isn’t making it easy. They are moving gradually towards naming Microsoft
The next macOS release will include a tool to migrate Outlook for Windows data to Outlook for Mac. The upcoming macOS release codenamed Mojave will have an improved Windows Migration Assistant. Apple says it will include more third-party programs including Microsoft Outlook. The news came via a sharp-eyed Twitter user
The Edinburgh International Festival is just one of the August festivals in the city. They have some methods of adding their show information into Outlook but with some traps along the way. On the My Festivals page for each account, use the ICS Calendar Link to get a list of
If you love drama, comedy or music then you’d love Edinburgh, Scotland during August. It’s a busy, busy time with so much going on that you’ll need your online calendar and Outlook to keep track of everything. In this and other articles, we’ll give you a practical guide to managing
The Edinburgh Fringe Festival has some help adding your Fringe bookings into Outlook with some tricks and traps they don’t mention. Overall The Edinburgh Fringe Festival has an excellent site and apps with an online calendar for each customer and a feature to download booked events into Outlook. It would
There’s an amazing collection of Apple device (iOS) and computer (MacOS) you can use on PowerPoint slides or a Windows desktop. ‘nucleam’ put the collection up on Google Photos. They range from the most recent for iPhone back to the early days of iOS 3. Some are famous images, a
Microsoft Teams is primarily a cloud and web-based service with software or apps available for the main platforms. Teams features appear to be introduced first to the browser based Teams then added to apps later on. We’ve had considerable trouble with the Teams apps during testing. Perhaps that because of
When you first go into Teams it’s a confusing jungle of terms and options. As usual, Microsoft assumes we’ve all been born knowing how their software is arranged. It’s not as difficult as it looks … once you get the structure or logic of Microsoft Teams. Wrap your head around
There’s a somewhat confusing range of parts inside Microsoft Teams, here’s a guide to things like Teams, Channels, Chats, Wiki and other goodies. In How Microsoft Teams fits together we explain the Microsoft Teams structure from an teams. The Best Way to learn Microsoft Teams Dive in and try it. Teams
