Tip o’ the Week 498 – Go do, To Do (you do so well)

clip_image002The Microsoft To Do desktop and mobile applications and services (all available from https://todo.microsoft.com/) had a major update recently, which included being slightly renamed. Instead of “Microsoft To-Do”, the core app is now simply clip_image004Microsoft To Do”, and it has a new logo (well done if you noticed)… instead of a blocky light-blue and white tick on a blue background, it’s a slightly rounded and shaded blue tick on white background.

clip_image006Still, To[-]Do’s functionality has stepped forward greatly since its first release a couple of years back, taking more than a few leaves from the Wunderlist app that preceded it. The new v2 of the To Do app includes background images that can be shown behind task lists, including one of the Berlin Television Tower which was synonymous with Wunderlist.

After Microsoft’s acquisition of 6wunderkinder (the company that made Wunderlist), it was announced that, at some stage, the Wunderlist application would be retired but still there’s no confirmed date or anything, with back-end engineering apparently taking a good bit longer than was first expected.

When the To-Do app was launched, it was a somewhat poorer cousin. Now, the story is that To Do v2 has enough of the functionality of Wunderlist, and lots of new capabilities (such as Cortana integration), that it’s time for Wunderlist users to transition.

See more of the detail here. See what’s new in versions of To[-]Do. For further To Do tips, check the help center.

The founder of 6wunderkinder has taken to Twitter to offer to buy back Wunderlist before Microsoft shuts the service down. It remains to be seen if the offer is being considered or not…

Tip o’ the Week 496 – Dark Mode marches on

clip_image002Back in the olden days of computing, wage slaves sat in front of terminals with black backgrounds and lurid green text writing. The advent of the graphical user interface relieved this tyranny with a paper-white background from a bitmapped screen to write your WYSIWYG text, to showcase colourful graphics (and Fonts!).

Fast forward 30+ years and it seems every app and OS is running away from black text / white backgrounds, and heading for monochrome graphics and oppressive white text on a black background again.

Using Dark Mode, either in apps or in the operating system on your computer or phone, promises a variety of benefits – less noticeable flickering, reducing eye strain, avoiding bright lights in a dark environment, perhaps better readability and therefore productivity, and even lower energy costs.

clip_image004

Dark Mode has existed in Windows for a while – but ultimately, apps need to support the theme, too, and more and more are doing so – like new Edge browser, or Office apps (where you can set the Office Theme).

Microsoft recently put out a groovy video to highlight Dark Mode across a variety of apps and device types, and some commentary about why and when. It’s even come to Outlook.com as well.

clip_image006

The announcement on Microsoft 365 functionality adds for August 2019 highlighted additional Dark Mode support coming to Outlook mobile apps and Outlook.com, saying, Dark Mode is not only easier on the eyes and may extend battery life, it also enables you to comfortably continue using your device in places where the default bright mode isn’t appropriate, like darkened airplanes and movie theaters.”

So kids, next time you want to go and watch a movie & catch up on your email, make sure you’ve Dark Mode 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.

Tip o’ the Week 482 – Paste History

clip_image002[4]Back in 2012, three weeks before Super Saturday, ToW #133 talked about the Art of Cut ‘n’ Paste. How the widely-used CTRL-V keyboard shortcut for Paste can trace its roots back to a program co-developed by Butler Lampson, one of the “Dealers of Lightning” as a founder at Xerox PARC, and now a near-25-year Microsoftie and Technical Fellow. QED was a thing before Neil & Buzz set foot on the Moon (which happened on 21st July, not 20th: Eagle landed on the 20th, but it was 21st before “one small step for a man”… at least it was in UTC).

clip_image004[4]Did you know that in recent versions of Windows 10, there’s a useful new shortcut – WindowsKey+V?

It shows you the history of the clipboard, so you can quickly access something you’d previously copied; you can sync the clipboard between multiple machines (or phones), too.

clip_image006[4]There are other controls you can assert when it comes to pasting stuff, too – CTRL+ALT+V in Office apps will let you paste something and decide how to handle it (the equivalent of Paste Special, in most cases) and you can over-ride the default behaviour in  Word too, by choosing to Set Default Paste.

clip_image008[4]In other apps, there may still be different ways of handling Paste actions – Paul Thurrott recently wrote about how to change the options in OneNote for Windows 10 (the UWP app that is replacing traditional OneNote; the one you can start by running onenote-cmd: from the Win+R box).

The “copy & paste” metaphor dates to PARC, too – and yet it’s still evolving, 45 years later.

Tip o’ the Week 472 – Update Store & Office apps

clip_image001[4]We’re all used to Windows Update or other software automatically downloading and installing updates (on phones, TVs, cars…). Sometimes the updates are at more of a leisurely pace than keen users might want though occasionally the recipients demand to hold back the updates until they elect to install.

The Windows 10 October 2018 is now being pushed to (nearly) everyone, though business users will have the option of pausing Windows Updates in case they want to enact a temporary delay for some particular reason – you’re about to go on a trip, for example – though it’s not meant as a centralised policy control: IT departments have other ways to do that. Windows 10 Homes users will soon get the ability to defer updates for up to 35 days, too.

How often applications update themselves is largely down to the publisher, clip_image003[4]but it’s usually possible to give the apps a prod to see if there are published updates before they get pushed out to you.

clip_image004[4]In the Microsoft Store app, for example, go to the ellipsis menu on the top right. You’ll see Downloads and updates, which will force the check for updates for all your installed Store apps. Even if you’ve turned on the automatic app update checks, it’s worth taking a look periodically as some of the apps you use most often might have updates pending.

clip_image006[4]If you find that most of the stuff you’re offered is updates to boring apps that you don’t use, then you could just wait for them to fetch their own in time. If, however, you spot an individual update to an app that you know you want to have the latest version of, then click the down arrow to the right to get it right away, or click the app name to look at its page in the Store and see what’s new.

clip_image008[4]Of course, non-Store apps may still offer their own updates directly – to check for updates to the Microsoft Office suite, for example, try going into Word (or Excel or PowerPoint if those are your most-used Office apps) and from the start screen that offers a few previously-opened files, templates you’ll never use etc, look to the bottom-left and you’ll see Account.

clip_image009[4]Click Account to go to the product information page, which will let you check for updates, show you the current installed version number of the the application, and maybe even let you sign up for more updates through the Insider program.

clip_image011[4]After you’ve installed any pending updates, the What’s New option will be active and will show you a summary of what has changed, in a pane within the app itself.

Or check the View Updates option at any time, and it’ll take you to the web to see what the latest updates contain.

Tip o’ the Week 468 – Get Office, My Office, Office app appears

clip_image002[4]For a while now, new PCs have been installed with an app that “encouraged” users to install and use Office. Even users with Office already installed sometimes complained that Get Office was nagging them to, er, Get Office.

Get Office became “My Office”, which was a lot more useful in the sense that it was showing documents you used etc, but its main aim appeared to still be to help you find and launch Office apps, or buy them if you’re not already using them.

clip_image004[8]The latest incarnation – simply called “Office” – moves the game on a whole lot more. For one, it’s a portal into all the Office documents you work with on your machine or online, allowing you to search content across not just the docs themselves – so you can search for documents in your most-recently-used lists, something that the File dialog in Word/Excel/PowerPoint annoyingly won’t do.

The search bar also reaches across SharePoint sites you use, OneDrive locations you have and even brings in the global address list so you can get to people details really quickly, including a really fast org chart ability.

The new Office app will be delivered automatically for a lot of people as it will replace the My Office and Get Office apps in due course; if you’d like to check it out sooner, go to the Store.

See more about the app here, or here.

Tip o’ the Week 437 – Mapping of Minds

clip_image001Like just about every other productivity technique, “Mind Mapping” has vociferous proponents and those who’ve tried it but never quite made it stick. The general idea is to try to represent a complex but related series of thoughts and topics onto a diagram that helps to organise them, and to aid recall. Mind maps are perhaps more useful for the person doing the mapping as a way of sorting their own brain out, than as a means of communicating to other people or even to record those thoughts for much later consumption.

Like writing a status report, the act of doing the report or compiling the map prompts valuable activity more than the resulting artefact which might never be read. Research has shown that more visually oriented people are likely to get more out of mind mapping, and using a mind map to try to remember stuff has a fairly short shelf life.

If you’ve not tried mind mapping, the simplest way is to start with a blank sheet of paper and a pen. Read some more here about the concepts. Or here, realising that the site is basically trying to sell you mind mapping software. There’s a more balanced view of different software packages, here.

You don’t need to pay for your mind mapping software, though… OneNote could be a great way of doing it, especially if you have a PC with a stylus. There are a few 3rd party addins to OneNote (desktop version) that provide additional functionality for mind mapping, though the same don’t necessarily work with the Modern App version – something that’s been picked up on the User Voice forums.

clip_image002If you’ve got Visio on your PC, you could try the Brainstorm template, using Visio’s core strength of creating and associating shapes, moving them around, hyperlinking between them as appropriate and so on.

This functional approach can be a bit too structured and formal, some people preferring a much more freehand, flowing kind of mind map to basically do a brain dump. Maybe a good way of publishing an already-sketched mind map?

clip_image003

Here’s a step-by-step guide (originally written for Visio 2010). Watch this 10-minute tutorial video if you’d like a more visual approach.

There are some more brainstorming tips and tricks for Visio 2016 here.

clip_image005Another option is to try some specific mind mapping software – there are some very good examples of such in the Microsoft Store. One particularly good app is Mind Maps Pro, which is free for a few days (as of end of June 2018 – install it now; even if you don’t try it right away, it’ll save you a good few £/$/€/etc as and when you give it a go).


The app has simple hierarchical mapping features, and some freehand support – including Ink – with easy additions of structure, auto-layout and the like – it’s a great way to creating a mind map on Windows. It can automatically sync your maps to OneDrive, too, and export to PDF/PNG.

clip_image006

Tip o’ the Week 417 – Resolving aliases in bulk

This might be a very old-Microsoft culture clip_image002thing, but alias names have always been a relatively big deal within the company; not an alias in the sense of a nom de plume or some alter ego, but a name curiously given to mean your login name.

Before enlightenment, Microsofties were emailed simply by sending to alias@microsoft.com – and still are, so even if the primary mail address is forename.surname@microsoft.com, you could still mail them at forenams@microsoft.com, or whatever their alias is.

clip_image004The alias, or logon name, at Microsoft was historically an up-to-7- or 8-letter moniker, based by default on surname|first-letter-of-forename, eg billg or steveb.

In a company with a handful of people, it was easy to remember such a name for when you wanted to drop them an email, but with hundreds of thousands of mail addresses, you might need more room – when Exchange Server came out in 1996, it supported 64 characters in the alias name, though oddly, Microsoft has never embraced longer than 8-character aliases.

Back in the day, your mailbox was a folder on a Xenix server, then an MS Mail postoffice, and the folder names were restricted by the 8.3 filename format. There are probably too many legacy systems that also have an employee name represented by their 8-letter alias, and it still kinda works.

Aliases – and the cultural phenomenon of calling people not by their name, but by their alias… eg “we had a billg review” – were a central part of the 1995 Douglas Coupland book, Microserfs.

clip_image006Some people at Microsoft still talk about an email distribution list as an “alias” – eg. “TAKE ME OFF THIS ALIAS!!” as a Reply-All (as opposed to a little “r”) to the occasional mail storms that amazingly still happen. They’re wrong – those are Distribution Lists (DLs) or maybe more correctly, Distribution Groups (DGs).

But the true “alias” lives on, even if the Skypey “Contact Card” UI in Outlook does its best to not show you what someone’s alias is (but you can usually still get to Open Outlook Properties, which shows you the traditional Outlook address book view, with alias in the very top section). Lots of reports from Microsoft’s internal systems will refer to an employee using their alias name, so it often helps if you can decipher an alias into the person behind it.

Resolving an alias to a name one-at-a-time is all very well, but when looking at a column of alias names in some spreadsheet, it’s a bit of a palaver to turn each of the FORENAMS into something meaningful.

Bulk alias resolver in Excelclip_image008

Fear not, worthy reader, for a solution is to hand.

  • Simply download this macro-enabled Excel workbook, and open it/save it somewhere locally
  • Click on the Enable Editing, then the Enable content button, so the macro can do its stuff
  • Now paste your list of chosen alias names in column A, then click the resolve button
  • The macro will now go through each alias in the first column, and resolve the name, then stick it in column B, if it can. If the name doesn’t work, then column B will just be the same as the alias in column A

This can be handy if you’re building Excel reports and want to add names to a table instead of aliases – you could sort the list of aliases alphabetically, run them through the resolver, and then reference the table with a VLOOKUP formula so you could hide the column of aliases from your report and show instead the derived real names.

Tip o’ the Week 403 – Office Insiders and training

clip_image002The Windows Insiders program is well known as an early-access scheme for Windows, with millions of users trialling out new versions regularly and getting new functionality ahead of general release. A new “fast ring” version of Windows 10 came out just the other day, in fact.

Did you know that Office has a similar programme? Office Insiders is geared towards Office 365 subscribers who want to opt-in to early releases.

clip_image004Regardless if you are or are not in the Insiders group, you can see what’s new in the latest version of Office you’re running (assuming you’re on Office 2016 and subscribing to Office 365).

clip_image006

Try looking under File | (Office) Account menu, and check under the Office Updates section to make sure you’ve got the latest versions available to you.

Click on What’s New and you’ll see a pop-up of the latest features, with a “Learn More” link to find more. To see the latest for Office Insiders, check here.

One new feature that’s previewing for Insiders but available to anyone on the web is the new Office Training Center, which offers help in a number of features, templates and the like. There are short videos showing tips on how to use Office apps in conjunction with Office365 – check out some of the “try new things” category to see if they really are new to you.

Tip o’ the Week 396 – Handling dates in Office apps

clip_image002There are many times when you may need to deal with dates in ordinary applications – and there are a few shortcuts that you can make it easier.

In Outlook, any time there’s a date field (like when you’re setting a reminder, or clip_image004entering the start date/time for an appointment) you can choose or enter a regular date, or put in an expression – like “2 days” or “next Tuesday” – and Outlook will figure out the offset from today, and will set the appropriate date.

In some date fields (like an appointment start time), if you say “4 days” then press enter or TAB, it will evaluate the new date; if you return and put “4 days” again, it may add those extra days to the last date. Try a few other things like “next Christmas”, “3rd Sunday in November”, “2mo” , “7d” or some special days – there are some surprising ones there, like “Lincoln’s birthday”, and other events with static dates … though nothing that might change the actual date from year to year (like Easter, or Thanksgiving).

clip_image006In Excel, press CTRL+; to insert the current date into any cell – add a SHIFT key to insert the time instead. Excel are many date-oriented functions, but you don’t always need to write functions – simple maths can work on date fields – calculating the number of days’ difference between two dates, for example, or adding a number of days to a start date.

clip_image008In the desktop OneNote app, if you want to edit the date and time at the top of a page, click on the field and you’ll see a clock or calendar icon appear next to it – click on that  is set to, click on that to change the value; handy if you’re updating some reference material and want to make it clear that it’s recent.

Another way might be to insert the current date or time into the text: to do so, press SHIFT-ALT-D, or SHIFT-ALT-T for the current time, or SHIFT-ALT-F for the current date and time. The last one is really handy if you’re taking notes about a phone call, and want to quickly note the time that your insurance company said that everything was all fine, or when you started the indefinite call to the airline. The same shortcuts apply to the desktop OneNote 2016 application and also the OneNote store app.

clip_image010Word also supports SHIFT-ALT-D and SHIFT-ALT-T like OneNote, though inserts a date or time field rather than a simple bit of text, and is slightly different to the Date & Time command on the Insert tab, which gives a bit more control over the formatting at the point of insertion, rather than requiring the user to insert the field then go back in to edit the format.

Since Outlook uses Word as its text editor behind the scenes, the same shortcut keys will also insert date fields into the text of an Outlook email.