several “are you sure you don’t want Office 365 instead?” type dialogs. The best way to get An even better solution would be to fork out an extra $30 / £20 per annum to get up to 6 accounts; even if you don’t plan on sharing O365 with your extended family, you could set up separate accounts for different purposes – eg if you want to backup all your movie files from a home NAS, that could be a separate login to your primary one, or if you store RAW format images you could keep them in one OneDrive login while enjoying your processed photos in your regular account.
If you really need more than 1TB per login, Office 365 will soon let you buy addon storage, so for $2 per month more, you can add storage in 200GB blocks, all the way up to an additional 1TB for an extra $9.99 per month. Online commenters have already pointed out that you could buy 2TB of storage outright from Google for $10/month without first needing to have an Office 365 subscription, but let’s get distracted by that. |
Category: Productivity
Tip o’ the Week 485 – Excel and the Web
A recent tweet from @msexcel showed a simple video on how to grab data from a website – highlighting a capability that’s been in Excel for years but has been refreshed and made a lot easier to use.
Once you’ve tagged the source data, clicking on the icon to the left of the data point will show a pop up with the background detail, or you can reference the fields within formulae to display or manipulate the data values.
See more detail on using the Stock quotes functionality, here. |
Tip o’ the Week 484 – Saving Office 365 profile pics
There’s supposedly a lot that your choice of profile picture says about you. There’s a tabloid version (akin to the “What Your Horoscope Says About Your Pet” style nonsense more often to be found on the Edge browser homepage). There are some more scientific resources with views on what people think when they see your picture, and some hints on how to choose the right one. Some fun examples of what not to do could be illuminating. Facing left-to-right is supposedly best – maybe it makes you look more powerful, or simply, when your photo is on the left side of a load of content (like the details of your LinkedIn profile), then it’s better to be looking toward it rather than away to the left… Similarly, good advice is to stick to a head-and-shoulders shot, or at least waist-up – if your profile pic is your visible brand on LinkedIn and Office 365, then there’s no point in using a photo that shows your face as too small for anyone to recognise you. How to save photos from Office 365 This tip will probably become obsolete at some future update on O365, such is the march of innovation, but it deals with how you can get to the profile photo that someone else in your organisation has published. The inspiration came from a departmental admin who was trying to build a nice org chart, and had to repeatedly nag members of the team to share a photo of themselves. It can also prove handy when someone has posted a photo of themselves that’s too small to see – if you can open the photo up in a browser, it can show you the original full-resolution image, and you can always use the browser to zoom in, too.
An even quicker way might be to go to https://www.office.com/search/people?auth=2&q=<name> and follow the q= with the name you want to search for. When you have the results of the search, hover over the thumbnail of the person’s profile pic, and in the pop-up that appears, right-click on the slightly larger image. If you’re using classic Edge, then you’ll be able to save the image locally, but if you’re on Chrome or the new Edge Dev browser, then you’ll easily be able to copy a link to it – paste that into a new browser tab, and you’ll get the full-size version of the profile pic so you can zoom in, save it, draw moustaches on it with your Surface Pen and so on. |
Tip o’ the Week 483 – mobile OCR and Office
Near OCR functionality is also pervading the slew of freely available Office apps for Android tablets, phones and even Chromebooks, and similar versions for iPad and iPhone. A recent addition to the iOS version of Excel is the ability to scan a table of printed data and use OCR plus a bit of tweaking, to import the data into the spreadsheet. See more here. The same functionality was first made available on Android a couple of months earlier …
Then the OCR goes to work and tries to lay out the data as closely as possible to its source – obviously, your accuracy will be improved by having a well-lit and clear original document, and you’ll get to tweak the contents in context of seeing the OCR’d data and the scan at the same time, before committing to insert it. |
Tip o’ the Week 481 – Lost in Translation
In the not-too distant future, we may have the ability, babel fish-like, to automatically hear in our own language, regardless of what is spoken. Institutions like the EU have thousands of translators and interpreters, who provide written, spoken and signed interpretation between different languages. There are rigorous checks in place when trying to get work in these areas (though not everywhere), as we all know what can happen when wrong grammar is used, the words are unsuitable, or punctuation is in the incorrect place.
There are plenty of mobile apps and websites like Bing Translator, and the cloud-powered translation service is built-into Word (just right-click and Translate on any text). Microsoft Research Asia recently won a competition for the best machine translation between a host of languages, and the growing fidelity of AI models is helping to improve the quality – a year previously, the Chinese-English translation was adjudged to be at human conversation level already, so it might not be too long before machine translation gets good enough that it’s hard to tell the difference between that and humans. A practical tip for users of the new Chromium-based “Edge Dev” browser; you can enable on-the-fly
Legacy Edge users can install the Translator extension. As they say in translation circles, Yandelvayasna grldenwi stravenka! |
Tip o’ the Week 478 – O365 and Windows’ Mail and Calendar
The genesis of Outlook on the phone as we know it today, is perhaps the acquisition of a company called Accompli 5 years ago, and a great deal of refinement and effort since.
e.g. Hit WindowsKey+R then enter outlookcal: and you’ll jump straight into the Calendar app. Both have come a very long way – at first release, they were pretty basic, but they’re now so well featured that most people could use them as their primary email and calendar apps, most of the time.
Go into the settings on the Calendar app, then Manage accounts, then + Add account… or just Win+R then outlookaccounts: and you’ll be able to add your Office 365 account onto both Mail and Calendar. If you have multiple calendars connected – like home Office 365, Gmail or Outllook.com accounts as well as your corporate one – you could selectively enable them for display in the app, and the set of calendars that are shown will also appear in the agenda if you click on the clock / date on your taskbar. You can also see your upcoming appointments in a live tile on the Start menu, if you still use such things. You’ll also see your next appointment on the Windows Lock Screen if you have it enabled under Lock screen settings. You may want to go into the Notifications & actions settings page (just press Start and begin typing notif…) and turning off Calendar notifications, or you’ll get a blizzard of reminders from desktop Outlook and the Calendar app. |
Tip o’ the Week 474 – Parse and Flow
Learn how to build Flows here. Many of the templates for Flow are quite esoteric – when a tweet on a particular topic appears, write a log to a Sharepoint site and send a notification to a Teams channel, that kind of thing. But there are plenty of really useful connectors that can be combined in time-saving ways; here’s a really handy way of bringing traditional data sources into the modern era: an email parser, called Parserr. After signing up with Parserr – free if you only need a few uses per month – you can then crack open mail that is consistent in format and contains some information you’d like to extract and use elsewhere, such as confirmation of an appointment or maybe a travel booking. In practice, you get given an inbox with a unique email address within Parserr and you’d set up a rule in Office365 or Outlook.com to send mails that meet some inbox rule to that address, where it would be parsed for you and key data fields then sent back to Flow. e.g. if email comes from a specific source address or it has a subject that indicates it’s a particular type of reservation, then forward to your nnnnn@mg.parserr.com inbox address, extract the details of the booking then do something with them within Flow.
Create a rule for each piece of information you want to extract, and it will effectively create a field: Once set up, you create the Flow by choosing the connectors for Parserr and whatever other applications you need to work on the information. In this example, we’re using Office 365 to create an appointment that matches a reservation – the arrival and departure dates are provided by the source email, and converted to YYYY-MM-DD format within Parserr, then dragged across in Flow to match the Start & End times of an “event”. We’ll tack on T16:00 to the arrival time and T10:00 to the departure as that’s the check in and check out times, and thus create an ISO8601-compliant date/time such as 2019-04-05T08:00, which Office365 will use as the start or end time of an appointment. “Advanced options” gives you further control (such as adding body text that might contain static text and other fields provided by Parserr, other addresses to forward the invite to, setting if you want it to be free/busy/tentative, reminder duration, time zones etc). And that’s it: you can test the logic is working within each system – in Parserr, you can continually re-run the processing of your initial sample mail until you know the data is being extracted as you’d like, and within Flow you can keep testing your formatting etc by Once you’re happy just save the Flow, and it will automatically create an appointment in your calendar every time you get a matching email forwarded to the Parserr system – all in a few seconds. See more on using Parserr with Flow and here’s a worked example. |
Tip o’ the Week 473 – Teams Shortcuts
As world+dog moves from internal corporate email to Teams, Slack etc, it’s handy to know how to get the best out of the new messaging environment. Before abandoning Outlook already, here’s a reminder of some especially useful shortcut keys:
And there are lots and lots more. When it comes to using Teams, one of the most useful shortcut tips is essentially the same as the Outlook set above – CTRL-number takes you to one of the nodes on the side-bar that corresponds to the number from the top – eg CTRL-4 will jump to Meetings, which is handy if you have Teams calls in you
Click the “Join Teams Meeting” icon on the Ribbon in Outlook instead, and you’ll skip this. If you’re super-skilful then you can jump straight to that command without lifting your fingers from the keyboard – just press the ALT key and you’ll see There are many other shortcuts in Teams, with varying degrees of usefulness. Customising the UI is still a bit clunky (eg you can’t add shortcuts straight to the sidebar or move items on it up and down) but you may be able to find a quick way of doing the things you need most. To see a summary of shortcut keys whilst in teams, just press CTRL-. (ie CTRL and full stop/period ‘.’). |
Tip o’ the Week 469 – To-Do Files and Accounts
It’s also now possible to add multiple accounts to the Windows To-Do app; so you can have several Office 365 or personal Microsoft Accounts – and switch between them without needing to sign out and in again. Maybe something that Teams could aspire to… To keep up with further news, check out the To-Do blog, or the Twitter account. |
Tip o’ the Week 467 – Gardyloo, It’s the News!
The Mobile version of Edge browser was updated in January 2019, to include the NewsGuard plugin (though it wasn’t enabled by default), and at the time it was widely reported that their vetting had decided the UK’s Daily Mail, a popular newspaper and at one time the largest newspaper website in the world, was not to be trusted. (Screenshots above & right were taken on 24 Jan 2019). More people probably read about the warning that was gleefully propagated by the Mail’s competitors, than there are actual users of the Edge mobile browser itself (if you use Edge on your PC, give it a try on your phone – it’s really rather good).
NewsGuard has since worked with the Daily Mail and decided that it’s not quite as bad as all that, so has backtracked and removed the klaxon warning. It’s still not giving a completely clean bill of health – see the “nutrition label” – but the feedback NewsGuard has shared with some other news websites may well help to improve the quality of their output. |