Make a draft email on a phone or tablet (maybe some quick notes) to later revise and send from Outlook for Windows/Mac. Once that was a problem but not any more, as long as you’re using Outlook mobile apps. Syncronizing the Drafts folder is really useful. You can write a
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
Excel’s Unique() function itself can’t show distinct values that appear more than once in a list. Repeated only items in a distinct list are possible with a simple extended formula. We’ve already shown the basics of Unique() either getting a list of Distinct values or values that only appear once
In late 2018, Excel 365 got an important new feature, Dynamic Arrays . Here’s a simple way to use the feature to make your workbooks sort better and automatically. It also fixes a long-standing problem in Excel. We’re going to focus on a very simple and useful part of dynamic
Apple’s new Privacy tags sound like a great idea but they rely on the honesty of app makers (Ha!) The simple labels can cover an enormous amount of privacy intrusion in Microsoft Office and Outlook mobile apps. The Washington Post is behind a paywall but the ‘general tenor of his
There are two security risks in iPad and iPhone devices that are being used by hackers. It’s important to get the latest iOS update to protect your devices. Some Apple updates are bug fixes or self-serving for Apple to add links to new devices or services. 14.4 is a little
Presenter Coach or Rehearse with Coach is now available in PowerPoint for iPad. You can practice your presentation with Microsoft’s systems ‘listening’ and giving advice on how to improve. Presenter Coach is already in PowerPoint 365 for Windows or PowerPoint Online on the web. See Presenter Coach makes for better
Windows 10X is coming and you’ll hear a lot about it in the coming months. Let’s see what Windows 10X is, how it will run Office (Word, Excel, PowerPoint, OneNote and Outlook) and why most people won’t need to worry about Windows 10X. What is Windows 10X? Windows 10X is
As we mentioned back in October, Office Lens has been dropped from the Microsoft Store but it’s not the end of Lens, far from it. Microsoft announced that the cloud services backing Lens features would be disabled from 1 January 2021. Only Office Lens for Windows 10 and Windows Mobile
Commercial users of Microsoft Teams can now quickly switch to a personal account without shutting down the app or browser window. Personal Teams can keep in contact any group of people, family, extended family, school friends, study group, class, sports team or club. See Teams gets personal for families and
PowerPoint Mobile for Android is getting an ‘Outline View’ but it’s not like Outline View in Windows or Mac versions of PowerPoint. This Outline View is really an ‘Outline to Presentation’ wizard that lets you make an outline or bullet point list then choose a slide theme to quickly make
The Microsoft 365 logins on top executives are being sold on the dark web, allowing hackers direct access to the emails and files of chief executives, directors and managers. ZDnet is reporting that a forum for hackers has an offer to sell login details for Microsoft 365 / Office accounts
Microsoft can’t help themselves when it comes to naming their ‘Insiders’, ‘Preview’ or beta test versions. The names change for no good reason and timing is different for each platform rather than all Office apps changing at the same time. The latest changes are for MacOS, iOS (iPhone/iPad) and Android
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
Office Lens, the nifty way to photograph documents then convert to a document or PDF is ending it’s run as a Windows app. Office Lens for Windows is mostly for Windows Mobile smartphones though it can also be used on any Windows 10 machines. Microsoft has gone beyond just stopping
Apple’s iOS 14 for iPhone and iPad have some useful new features. Change default mail and web apps, Widgets, Scribble and Translate. Microsoft wasted no time improving Outlook to take advantage and adding a little extra to OneDrive. iOS 14 was released with very little notice to app developers. Most
The latest iPad Air is interesting but, like many iPad’s there’s a hidden extra cost because of Microsoft 365 licence rules. The new iPad Air has the usual changes, a faster processor and slightly better screen. The big changes are: Fingerprint login is combined with the Power button USB-C connector
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
According to Microsoft, there’s only four audio formats accepted by their new Transcribe option to convert audio into a text transcription. That’s not true, there are more formats possible with no conversion necessary. The official list of audio formats for Transcribe is .MP4 .M4A .MP3 and .WAV. Strictly speaking that’s
We’re happy to release a new version of our Subscriptions Manager that’s compatible with Excel 2007-2016. Subscriptions Manager is a way to list and manage the many online plans we sign up for; HBO, Netflix, Amazon, Spotify and so many more. You can track who pays (in a family) and
Office-Watch.com is always on the lookout for ways to save money on buying Microsoft Office. Here’s a summary of the tips we’ve discovered over the years. Microsoft 365 Family (with six users) is the main seller and you can buy/renew it for less than the official price. Formerly Office 365
How to make a computer setup suitable for the elderly or infirm. Something that’s simple ‘turn on and it’ll work’ and needs little or no action by the recipient or their carers. Bill Chubb wrote to us with his solution for keeping in touch with his wife in a nursing
The Excel team has joined the current ‘Cake’ meme with a new Cake() function in Excel. Hilarity ensues … Source: Twitter Ho ho, very funny, it is to laugh. Most people took the message in good spirit with one person implementing it in VBA That code really works. ChrW() returns
Excel for iPhone and Android smartphones have a useful extension of Excel Tables called Cards. It’s a better way to view tables on a smaller screen with larger text and easier editing. Instead of scrolling right/left on the small screen, all the info for a single table row can be
