For emails that you send regularly, there’s a way to have a ‘boilerplate’ email template with most of the details already filled in. Messages can be sent faster and be more consistent. Welcome to the little-known world of Outlook email templates. Outlook email templates can have all the message details
Microsoft promotes OneDrive as protection against ransomware however our tests show it’s not always as practical or complete as the company boasts. One recovery feature works fine but the other isn’t complete. While updating our book Everyday Backups, we tested the OneDrive ransomware protections, not taking Microsoft’s word about how
Sometimes Excel 365’s Linked Data Types are great (Stock and Currencies) and other times they’ll drive you crazy or lead you to use wrong statistics. Here’s some problems we found trying out the, supposedly, simple City data type compared to the similar Geography and Location data types. Just getting the
Something new in Excel 365 Linked Data Types is nested data types. If a data field can itself be linked to another data type, Excel will add it automatically. See the ‘Director’ names (from the Movie data type) have little icons next to them? That’s because Excel has added the
How to insert the Psi upper case Ψ, and Psi lower case ψ symbols in Microsoft Word, Excel, PowerPoint, or Outlook. Both in Office for Windows and Office for Mac. Psi (uppercase Ψ / lowercase ψ) is the 23rd letter of the Greek alphabet. The symbols are commonly used within physics to
A hacker trick is sending fake ‘file deletion’ email, taking advantage of a useful Microsoft service for all Microsoft 365 and OneDrive customers. If many files are deleted from a OneDrive account, Microsoft sends an email warning to the customer. It’s possible that the deletion was accidental, caused by ransomware
Insert the Xi upper case Ξ, and Xi lower case ξ symbols in Microsoft Word, Excel, PowerPoint, or Outlook. Both in Office for Windows and Office for Mac. Xi (uppercase Ξ / lowercase ξ) is the 14th letter of the Greek alphabet. The symbols are used within various contexts. The uppercase letter
The latest releases of Office for iPad are crashing when opening documents. Here’s what to do while Microsoft fixes the bug. The problem appears to happen when trying to open documents from OneDrive, which is the vast majority of documents because Microsoft encourages use of OneDrive. The bug is reported
Use Sequence() to get an ordered list of numbers either increasing or decreasing and with your choice of increments. Sequence is possibly the least understood of the dynamic array functions but combined with other functions it greatly extends Excel’s power. Sortby(), Filter(), Unique() and RandArray() all have obvious uses but
There are a few strange, non-standard, behaviors to the FollowedHyperlink style that Word uses for visited links. FollowedHyperlink is a hidden style which Word uses for any link which has been clicked or visited by the current user. Because it’s automatically applied it has some peculiarities that don’t apply to
Word has special styles for hyperlinks which you can change from the standard blue, underlined look. Word link styles have some special behaviors to keep in mind. Word links can look very different or appear no different to regular text. All these are hyperlinks, believe it or not. Hyperlink and
About the RAND() function to make random numbers in Excel plus related functions RandBetween() and RandArray() plus some tricks for getting whole numbers only and even rolling ‘dice’ made in Excel. By Michael Barden Typing the =rand() function into a cell in an Excel spreadsheet will return a random number
With Random.org you can get truly random numbers for Excel plus options not available in the spreadsheet program like random but unique numbers with no repeats and random dates. Using ‘True’ Random numbers in Excel Our article on Random Numbers in Excel continues to surprise us by being one of
Bahnschrift is a Windows font which is a little special and not fully compatible within Office. We’ll explain why it’s special, the extra care needed and the workaround. While it’s listed as an Office Cloud Font, Bahnschrift was originally included with the 2017 ‘Creators’ update of Windows 10. So, it
There are two a simple ways to make a list of unique or non-duplicate entries from a longer list. Unlike the many automatic ‘unique’ options in Excel, these options work only once but it’s available in many Excel releases, old and new. Advanced Filter One is hiding at Data |
Since we’re talking about Star Wars, how does Microsoft Office 2016 for Windows handle the words and names from the famous films? A mixed bag. Most of the common names are in the MS Office dictionary but some surprising omissions. The evil Emperor isn’t included. Planet Tatooine has a major
Coming to Microsoft 365 for Windows is the Subscription Benefits Center, a new way to introduce innovations in Word, Excel, PowerPoint and Outlook. It appears as a diamond icon at top right. That opens a pane over your existing document with three tabs, Home, Apps & Benefits and Premium Features.
The new Unique() dynamic array function doesn’t let you do anything new in Excel, but it makes a once-complicated task into simplicity itself. Unique or distinct, no-duplicate lists, counting and sorting the results are all possible with easy formulas that won’t confuse. For as long as there’s been Excel, people
Microsoft has decided that Calibri is getting a little tired, so it’s asking customers to vote on which font will replace it. Calibri has been the default font since Office 2007. It’s familiar to most people whether they realise it or not because it appears in many Word documents. The
The new iOS 14.5 has hundreds of new emoji but beware using them in emails and documents because they can look very different on other computers. We have examples of how a simple emoji can look very different in Word or Outlook. The new version of iOS for iPhone and
Thanks to Office-Watch.com reader, Pierre B. we can tell about a good deal on Microsoft 365 Personal or Family, now available from Amazon in Canada. Microsoft 365 Personal cheaper The usual price for Microsoft 365 Personal (12 month, one user) is CDN$79.99, but Amazon.ca has it for CDN$48.99. Here’s the
Microsoft is updating their Services Agreement, the rules we call agree to live with when using Microsoft’s many services. We found a few interesting things in the changes. The Summary of Changes to the Microsoft Services Agreement is mercifully short. Compared to full agreement of over 15,000 words which is
Here’s all about Office 2019 for Windows – the facts, prices and shortcomings. There’s a matching page about Office 2019 for Mac. Before you get too excited Do NOT buy Office 2019 if you have Microsoft 365 like Microsoft 365 Family (formerly Home), Microsoft 365 Personal or an enterprise plan. In
All about Office 2019 for Mac the facts, prices and warnings. There’s a matching page about Office 2019 for Windows. Before you get too excited Do NOT buy Office 2019 if you have Microsoft 365 plan like Microsoft 365 Family (formerly Home), Microsoft 365 Personal or an enterprise plan. In
