Apple is releasing a new version of MacOS, for all Mac computers, called ‘Big Sur’ or version 11. What does that mean for Microsoft Office compatibility and stability? Big Sur is the latest MacOS operating system (version 11) for Mac computers. It’s rolled out from 12 November but you can
Apple’s new Macbook’s use a totally new type of chip, the M1 or Apple Silicon. What does that mean for Microsoft Office and other programs? We’ll explain what Apple Silicon Macs are and why they are better. Microsoft Office compatibility with the new machines (it’s messy at the moment) and
The new Apple iOS 14.2 adds 117 new emoji to use but be careful now you use them because not even all iPhone and iPad can handle them, let alone non-Apple devices. We explain how they work, how the emoji appear on receiving devices and include a full list of
Plus + , disposable or instant alias email addresses are now available for Microsoft 365 hosted mailboxes and Outlook.com accounts. Here’s how to get this useful email trick for your mailbox. Outlook.com All Outlook.com accounts have plus addresses automatically. It was introduced to Hotmail (‘as was’) back in 2013. It’s
Outlook for Windows/Mac has features that work well with email plus or disposable addresses. Plus addresses let you make sub-addresses that come to the same mailbox see What are email Plus addresses and how to use them for details. Outlook Rules with plus addresses Most Outlook Rules are based on
Those ‘award’ logos with the laurel or fern on each side can be made in Word or PowerPoint. The ‘awards’ can be serious or joking. Here’s the thing we mean, you’ll often see them on theatre or movie posters. Format The standard wording for these logos is: Award organization (Academy
Microsoft first quarter 2021 earnings received a big boost from the move to remote working and the COVID-19 crisis. Though the company was careful not to credit the global pandemic for their success. The headline results for the quarter to 30 September 2020, compared to the same period in 2019:
Put the Sound Recording Copyright ℗ or Circled P character into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Sound Recording Copyright ℗ symbol (aka Circled P ) is used to mark musical copyright. The ‘P’ stands for ‘Phonogram’ or the modern ‘Phonorecord’
Adding a continent map is easy in Word, Excel or Powerpoint, in fact there’s a few ways to get them for the Americas, Europe, Africa, Asia, Australia and Antarctica. It depends on the quality you need and version of Office. Continental Icons Among the many icons are silhouettes of all
There are 87 different security breaches fixed in this months rollout of Microsoft bug fixes, including an important one for Windows. Also a Critical fix for Outlook and patches for Word, Excel. We’ll start with a very critical Windows bug that’s important to patch right away. Vital Windows 10 bug
Are your Excel worksheets ready for negative interest rates? The world is seeing historically low interest rates. So low that they can drop to zero or even lower rates. Not only can Excel worksheets break with unexpected negative percentages but modelling can accidently move into negative territory. Interest rates might
Excel’s Sparklines have a good range of options for highlighting high and low values, text or calculated overlays, changing axis and handling blank or zero values. Sparklines are in Excel for Windows and Mac. Excel Mobile (iPhone, iPad, Android) shows existing Sparklines made elsewhere but they can’t be changed, only
Excel isn’t the best way to store a large database but it’s a great way to sort, filter, analyse, chart and PivotTable from it. Here’s the best way to import and update a large database into Excel. The standard way to store a list in Excel is to import CSV’s
The UK has been embarrassed (again) with the news that around 16,000 COVID-19 test results were missing from the official database and so contact tracing wasn’t done. The culprit? Excel. Or, to be fair, bad use of Excel is to blame. Not understanding it’s limits and how to workaround them.
A strange name but Sparklines is a useful new part of Excel which makes simple single-cell graphs in Excel for Windows or Mac. Mea Culpa – we thought that ‘Sparklines’ was a fancy name made up by Microsoft after a long liquid lunch … Office Watch readers, John F, Nick
Microsoft has finally confirmed what was long suspected. There will be another fixed price, perpetual licence version of Microsoft Office. The successor to Office 2019 will be released in late 2021 for Windows and Mac. Update in late 2021: of course we now know it’s called Office 2021 All about
There are several ways to fill in a PDF form and add your signature with Microsoft Word, Acrobat Reader or online services. All these tips are free with nothing to pay. It’s possible to ‘sign’ a PDF form and return it without making a paper copy. Paper forms are so
Common programming tools can be used to make malicious Office workbooks which bypass both online security checks and Microsoft’s own protections in Word, Excel, PowerPoint or Access. We’ll explain what’s happening and what Microsoft could do better. VBA Purging or VBA Stomping are clever tricks to make an Office documents
The latest ebook from Office-Watch.com is a little different, it’s a heartfelt ‘Thank You’ to our Office Watch donors. Peter Deegan has been quite astonished and humbled by the generosity of readers to our reader appeal. Both the money and kind remarks have been a considerable morale boost quite beyond
Stop duplicate names, email addresses or product SKU’s from being added to an Excel list or Table. Adding more rows to an Excel Tables can be done while preventing accidental duplicates creeping into the list. Excel Tables or lists can grow to hundreds or thousands of rows, there’s a risk
Microsoft is releasing a ‘Quick Poll’ option in Outlook ignoring the very similar, voting buttons, option that’s already in Outlook for Windows and Outlook for Mac. Use Voting Buttons to ask a question and Outlook will automatically collect responses. Office Watch also explains how recipient see the voting options and
Everyone with Microsoft 365 can get a ‘quick poll’ now with any email account or software. No need to wait for the Outlook Quick Poll option, now in preview for Microsoft 365 customers with Outlook for Windows. As we’ve already explained, Quick Poll is a simple and very limited way
Type the Left Right arrow ↔ into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. How Left Right arrow ↔ looks in different fonts. Here’s some examples of how Left Right arrow ↔ looks in common Office fonts. Left Right arrow ↔ codes
