Office 2016 for the PC is nearly here. Many Office users have been already running a preview version, detailed here, but according to Julia White, the rollout of the final 2016 release will begin on 22nd September.
With many new capabilities that might appeal to IT admins, and with distribution increasingly being done as part of Office365, end-users might be forgiven for missing what the differences are over 2013 or even noticing that the upgrade has taken place.
In Excel and PowerPoint, there are new charting types, additional polish to numerous capabilities in data presentation, analysis tools and the likes. OneNote goes largely unchanged, except for some high-DPI capabilities on very large or very dense screens. Outlook has some tweaks for being shown in portrait mode on tablet devices, and also gets some changes to how it goes about connecting to the Exchange/Office365 back end. Office apps also now support multi-factor authentication, so it’s possible to get users to strongly authenticate when trying to open a specific document, for example.
I’ll tell you what I want
One nice end-user additions to most Office apps (sadly, not OneNote) is a new feature called “Tell me” – a text box that sits to the right of the menu bar, which lets you tell the software what you want it to do. Think of it like Help on Steroids, or Clippy’s Revenge.
Click on the light-bulb on your menu, (keyboard warriors press ALT+SHIFT+Q, or just ALT then Q), and type what you want the Office app to do… and rather than just showing you help about how to do it yourself, it may jump straight to that command.
Try this – press ALT+SHIFT+Q and type forward (and as you’ll see, that is the top option anyway, after only a few letters, for… at least, it is in English…); press ENTER, then send a copy of this tip to all your friends. Simples.
You can enter help requests too, and Office will try to figure out what you’re doing, and if all else fails you can search the Help files for your phrase, or perform a “Smart Lookup” – which searches the web and displays the results in a pane to the right of the application.

Outlook has a history of incremental smart additions, like the attachment detector that first appeared a few years ago now – if it thinks you’re trying to send a message with an attachment, but you haven’t attached a file, you’ll get a pop up to check …
Well, attaching files got a bit different in Outlook 2016, and it’s one of the neatest new features, even if it’s not rocket engineering.
When attaching a file within Outlook 2016, you can drag & drop files as before, but if you click on the paper-clip icon on a message, you’re presented with a list of most-recently-used documents.

If the document you’re selecting lives on a SharePoint site, then (depending on how you have Office configured) the default paste behaviour may be to include a link to that doc rather than to paste the original into the email – so you can do what people have talked about for years, and that is send around pointers to the current version rather than attached copies which will go stale.
Obviously, sometimes people won’t be able to access the online variant, so it’s still possible to decide to attach a copy instead, in the traditional sense.
Be careful when sending attachments to external users as it could be quite easy to send them a link to a shared document (which they won’t be able to access) instead of a proper attachment.
Maybe a future “attachment detector” will sense that you’re trying to email a shared document to an outside recipient, and offer to replace it with an attachment instead.
ß Who knows, maybe there’s a hidden Easter Egg already in Office 2016 already…?
There are some features in Office that might appear to be Eater Eggs but are actually designed to be useful, if hidden, functions. Try typing =rand() into a Word doc, or =lorem(100) (or number of your choice), to generate lines and lines of lorem ipsum guff.

What Sidetone does is to play your own voice back into the audio stream you’re listening to, so if you have a headset that covers your ears entirely and blocks out background noise, you don’t completely isolate yourself and end up shouting to compensate.
Advert blocking in Internet Explorer was covered back in 

Some sites will substitute blank space for the missing ads, but for content like the Other Stuff you might want to click on (such as the Taboola-type clickbait guff that’s normally at the bottom of the page), site may just quietly ditch whole sections without you ever knowing.
Sometimes, the Tip o’ the Week is all about one topic, and sometimes it’s a theme that spans several things. Today’s is just such a
familiar preview that tells you a bit more detail. If you click on that section, you’ll see the new calendar view, with a link to Date and time settings which will take you to the system Settings > Time & language > Date & time options. In here, under Related settings, you can add clocks for an additional couple of time zones, if you need to – give them a label, then you’ll see those additional times
displayed atop the calendar and the larger display of the current time.
of the same thing. Handy for those of us who regularly work with people from all over the world, and want to make sure you’re not booking conference calls in the middle of the night. Outlook allows you to easily show a second time zone in your calendar – just right-click on the border to the left of the calendar itself, choose Change Time Zone and in the resulting dialogue box, tick the box to show an additional time zone and give it a label.
If you use OneNote (the desktop version – does anyone prefer the Store app?) in a shared fashion, then you’ll see coloured blocks when other people update sections of the text
, though it’s not so easy to figure out when you last edited a page (in short, you can see the date you edited a page by looking under History tab, Recent Edits or Find by Author, but it’s not always that obvious).
OneNote has a couple of other neat date tricks that have also featured before on ToW – like the ability to insert today’s date or time, on the Insert tab – if you hover over the first two, you’ll be reminded that ALT+SHIFT+D or T inserts the Date or the Time, but hovering over Date & Time doesn’t remind you that ALT+SHIFT+F, does.
But the date control also has some other smarts – you can put additions to dates, for example, so you could type the end date to be “tomorrow” and it will automatically figure out the offset from today and set it appropriately. The duration of the meeting will also be set, so if you subsequently went back to the start date and typed “tomorrow”, the end date would be a day further out. Clever eh?
It’s quite useful to have a catalogue of names that can be put to different uses. Codenames are frequently reused, and there was a time when every new product had to have a snazzy moniker – remember 
or better still, use the excellent 
Fortunately, with OneDrive and Office365, reinstalling isn’t the major effort it used to be – with a huge mailbox, nobody should need PST files anymore and fret about whether they’re backed up properly. No need to worry about My Documents when OneDrive (on your home machine) can accommodate Terabytes of data, and OneDrive for Business (on your work PC) will sync all of your stuff too.
OneTastic adds loads of functionality, including a macro language and the
If you use lots of notebooks, there’s a neat feature in OneCalendar, which might help – take a look in Settings
and you can specify which notebooks OneCalendar will show you changes from – so you might want to restrict it to the less busy notebooks and all your own personal stuff, or maybe even get into the habit of turning some on & off when required.
For new upgraders, the first thing you might decide to do with Edge is to restore your favourites from IE – click on the multi-line icon on the toolbar, then the star (which represents Favourites), and click Import favourites to bring yours from IE. Some degree of username/password history will come across as well, though you may need to select the username on the first visit to a web page (as cookies are not migrated across).
high-level settings, but don’t stop there –make sure the language pack isn’t still searching Windows Update, and that each of the components has been downloaded.
make sure the language you speak is correct.
which will mean she’s listening out for you to say that all the time… and will jump in with a spoken response to your every query. Just make sure your Windows Phone isn’t nearby or you’ll end up cheating on one Cortana with another. Let’s wait for the 
on the icon that’s pinned to the taskbar by default, or else simply press the WindowsKey+e. Out of the box, you’ll see a couple of changes to simplify File Explorer when compared to Windows 8, namely to show recent files and folders and the Quick Access pane, as the main display of the Explorer window, rather than
just showing a list of drive letters or network locations.
can start typing the name of key folders and recent files, and you’ll see the name show up in autocomplete – so to get to Downloads, just start typing down and then with a single press of the down cursor key then enter, you’ll jump straight there. This may seem trivial but to hardened keyboardistas, any reason to
If you still like using the pointing doodah, you can click on the caret to the side of the icon that shows whatever folder you’re in (and it will change as you move around), and you’ll get a short cut menu that also includes regularly used folders.
Another neat one, for some at least, is that if you select a folder within Explorer, and go to the File Menu, you’ll get the option of launching a command prompt or PowerShell window with the focus directly on that folder
the link, the download bit will be getting very constrained too – so you could see your overall network performance drop dramatically. Take a look using the Network Speed Test app (
Depending on your version of Windows, the specifics may vary a little, but they generally start by looking for the Task Scheduler in control panel – something that’s existed since the very earliest days of Windows NT, though used to be a command-line only thing. Now with Task Scheduler, you can create jobs that do something on your machine according to a load of conditions – running at user logon, or at a time but only if someone’s logged in, if it’s been idle for a while etc.
– just create a new task, tell it when you want it to fire (midnight, when everyone’s gone to bed, and 9am, when everyone’s left the house could be good times?) and set the action to run.

Assuming it’s running at the time, you should be able to see the OneDrive icon in the Windows taskbar, and if it’s busy uploading you’ll see just how it’s getting on by clicking on the icon. 
Back on terra firma, if you do need to write emails that may not need to be sent or read over a weekend or during the night, you could try Offline mode: simply go into the Send/Receive tab of the main Outlook window, and click the icon in Preferences.
message that this rule will apply to every message…
If you get cold feet on sending, or decide you need to edit your missive, just go into the Outbox folder, and if the email shows with the recipient name or address in italics, then it means it’s waiting to be sent – if you open up the mail and then just save it again, it’ll stay in the Outbox but won’t be sent until you edit it again and press the Send button again.