Tip o’ the Week 486 – Cloud Storage Bonanza

clip_image002Microsoft’s OneDrive end-user cloud storage system was in the news this week, as plans were unveiled to allow people to buy more storage space than was previously available. The tl;dr version of this is that in addition to your free 5GB of storage when you sign up for OneDrive, you can opt in to buy an additional block of 50GB for $1.99 a month. Now, you’ll get 100GB for the same amount, and Office 365 users will soon be able to buy even more.

clip_image003If you visit the OneDrive.com site and sign in, you’ll see the total space being used in the lower left, and have the option of upgrading your service – but it’s pretty clear that Microsoft doesn’t want you to buy OneDrive storage on its own… in a Tarrantesque “We don’t want to give you that!” move, you’d need to click through

several “are you sure you don’t want Office 365 instead?” type dialogs.

The best way to get clip_image005additional OneDrive storage is indeed to get Office 365 Personal, if you only need one account – and for your $70 / £60 per year, you get 1TB of storage plus all the additional awesomeness of Office 365 for your home delight.

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.

Tip o’ the Week 485 – Excel and the Web

clip_image002For decades, it’s been possible to import data into spreadsheets from elsewhere. Excel supports many data sources, from basic stuff like CSV, ODBC and OLE DB, to more specific and advanced knowledge of particular data sources and types.

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.
Try this as an example:

  • clip_image004In a new Excel workbook, go to the Data tab and choose From Web
  • Try a web site that has data tables – eg
    https://en.wikipedia.org/wiki/World_population
  • clip_image006After confirming the authentication method to connect, Excel will retrieve the page and try to make sense of its layout – and let you choose the table you want to retrieve data from.
    This is part of a new “Get & Transform Data” set of functionality that’s available to Office 365 subscribers, that uses Power Query to retrieve data from a variety of sources, and can include some advanced transformation and editing of the query too. See here for a more detailed tutorial.

clip_image008If you want to revert to using the old data import methods, you can either enable the Legacy import wizards in Options (File > Options > Data > Show legacy data import wizards), or just type Legacy into the Search / Tell Me box in Excel, and see the available actions from there.
You can jump to the Search box quickly by pressing ALT+Q and jump straight to any Excel function, or get help on how to do many tasks.

clip_image010Another cool Office 365 data feature is to use Data clip_image012Types. Enter your data in a column, select it and choose the appropriate Data Type – let’s use Stocks as an example.

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.

clip_image014Each data source presents a number of fields that can be discovered and selected through autocomplete in a formula, and the values can be refreshed easily.

See more detail on using the Stock quotes functionality, here.

Tip o’ the Week 484 – Saving Office 365 profile pics

clip_image002Office 365 users will be familiar with the Profile Picture that appears in multiple places, most visibly in Outlook and Teams. Just like their picture on LinkedIn, many users will help people understand what they look like by posting an actual photo of themselves, whereas some will insist on posting a photo of their dog, or their kids, or themselves wearing a hat and shades while standing very far away.

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.

clip_image004Start by going to the Office home page and sign in; you can then search for someone’s name and click on the People tab for the detailed results.

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

clip_image002Optical Character Recognition is one of those technologies which has gone from being just-about-possible at great expense and hassle, to so mainstream that people just assume it will work flawlessly, all in a relatively few years. Numerous companies offer OCR services or addins to line-of-business systems which help to prepare printed data for easier consumption – scanning invoices for example.

clip_image004Consumers tend to use OCR in other ways; combined with language translation, you can point your phone at a foreign menu or sign and it may be able to help you understand. clip_image006In OneNote, if you have captured an image (maybe through the clipper addin from your browser), then it can extract the text from that picture – not always perfectly, and not necessarily well-formatted, but it’s probably quicker than re-typing everything.

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

clip_image001Start with the grid capture icon on the toolbar of a new spreadsheet, and then use the camera to highlight the area of a document that you’re interested in – the UI will be familiar to anyone who uses Office Lens, as the same anti-skewing technology is used to prepare the “document” for importing.

clip_image007clip_image008clip_image009

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.