All about Microsoft Office for Apple Mac. Word, Excel, PowerPoint, Outlook on macOS, Microsoft 365 for Mac, Office 2021 for Mac and earlier versions.
2019 Calendars from Excel
If you’re looking for 2019 calendar options, open up Microsoft Excel. Excel has a wide range of calendar templates to choose from. Go to File | New and type ‘calendar’ into the search box. There’s a proverbial embarrassment of riches. Pick a year All the Excel templates apply to any year. Enter the year you […]
Office for Mac gets Dark Mode
You can ‘go dark’ with Office 365 for Mac combined with the MacOS Mojave Dark Mode. MacOS Mojave release includes a system-wide Dark theme at Apple | System Preferences | General | Appearance. Compatible programs will switch to darker menus etc. Originally Office 365 for Mac did not change with Dark Mode but now it […]
Play music via Excel
Musicians with Excel skills might like to try Excel MIDI an Excel file with a simple sequencer that plays MIDI music. Made by ruiseixas from Portugal, Excel MIDI is an Excel worksheet downloadable from SourceForge. It’s an .XLSM file so you’ll have to enable VBA content to let it work. We tried it on Excel […]
Pantone Color of 2019 – available now in Microsoft Office
Pantone has announced its Color of the Year for 2019 but before you run off to grab color swatches, here’s how to get it in Microsoft Office – Word, Excel, PowerPoint etc. The color of 2019 is <drum roll> ….. Living Coral … As usual what’s more amazing than the color is the description from […]
Is it safe to use Icons / SVG in Outlook emails?
Icons are a relatively new part of Office 365 for Windows/Mac but can they be used in emails that go to people not using Office 365? SVG graphics are widely supported in web browsers but not all email programs know what to do with these new images. What do they see if you’ve used an […]
PowerPoint 365 gets live captions and translation
The long-standing Presentation Translation plug-in will be included in PowerPoint from January 2019. It will add real-time captions to slides for what you say, either in your language or translated to another language. Office Watch told you about Presentation Translator back in July 2017. It’s a Microsoft Garage test project that’s about to hit the […]
Save $40 on Office 365 Home renewal plus Office 2019 deals.
This is a good time to renew Office 365 Home with prices about as low as we’ve ever seen them. It’s possible to save $40 or 40%. There are also some good deals on Office 2019 packages. The official and automatic renewal price for Office 365 Home in the USA is $100 (well $99.99). You […]
Beat the Office 2019 Price rises
Microsoft has raised the prices of Office 2019, but there are still ways to beat the price rise. As widely expected, Microsoft upped the retail price of Office 2019. The official price increases are up to 10%. Office 2019 Home & Student remains at the same price, $149.99, keeping the entry price for Office the […]
Convert Excel formula into fixed values or text
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. Copy them, using Ctrl + […]
Microsoft Word vs Scrabble Champions
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 were: Groutier Zonular Phenolic Maledict […]
Why Microsoft’s Word Count went to court
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’) so the judge was more […]
Monthly and Yearly Date Arithmetic with Edate() in Excel
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 1 January to 1 February […]
The Microsoft Office font that helps you remember
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 is designed to be a […]
The new Office 365 licence system starts today
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 software. There’s no noticeable difference […]
Office 2019 starts public release
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 enhancements. There’ll be security and […]
Brand logo font with color, at least in theory
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 color fonts. Try out Brand […]
