518 – The App(s) of Office

clip_image002Once upon a time, there were Microsoft Office mobile apps, for Windows.

Ever since the demise of Windows Mobile and the collateral damage caused to Microsoft’s previous Universal Windows Platform apps strategy by not having a universal platform any more, their future has been in some doubt. In fact, since late 2018, it was reported that the Office “Mobile” apps for Windows were being de-prioritized in favour of the desktop variants (with the exception of OneNote), and separate mobile apps for the surviving mobile platforms.

clip_image004If you search the Microsoft Store app on PC, you won’t find any trace of the Office mobile apps for Windows PCs any more but if you want to see what the future looked like from a point 5+ years in the past, you can still access the direct links get the UWP apps for Word, Excel and PowerPoint.

In these enlightened days, Microsoft builds quite a lot of apps for iOS and Android, more especially the latter since it has a larger number of users (and seems to be growing its share in key markets) as well as being more open when it comes to the both the end-user and developer experience (though Apple may be changing its tack a little).

Recently, the Office team has shipped a whole new, unified Office app for Android and for iOSmore details in the team’s blog, here.

The app brings together Word, Excel and PowerPoint, but also adds a bunch of other related things – like Sticky Notes, and some related and useful technology like the ability to manage PDF files, extract text from an image and more.

Back in Oct 19, MJF wrote about this strategy and more recently has suggested more features are on their way.

516 – More Teams Sharing

clip_image002[4]When you use online meeting technologies, there are usually ways to share content with attendees. Even years and years ago, lots of people felt the easiest way to present a PowerPoint slide deck was to “share their screen” while running the PowerPoint application.

Some folk have the good sense to “present” clip_image004[4]that PPT fullscreen while screen-sharing, whereas others would merely flick through the slides within the PowerPoint app, consuming 30% of the screen real estate with menus, slide sorter, and other visual detritus of not only the app, but their host operating system as well.

Top tip – when you’re presenting, don’t be a doofus – please present, don’t share your screen then move through slides.

PowerPoint itself, OCS, Lync, Skype for Business – they’ve all tried to provide easy ways to present content online or through a meeting. Not wanting to throw in the towel to the screen-sharing crowd just yet, Teams has a few more tricks up its sleeve too.

clip_image006[4]clip_image008[4]Try for yourself – go to the Calendar node (remembering that you can switch between them by pressing CTRL+ the number from the top, so CTRL+4 in this case will jump to Calendar – though current versions of the Teams client will allow you to reorder the nodes by dragging & dropping them), and on the top right of the screen, click Meet now. This will give you a one-person playground to try stuff in. Read more here.

When you’re in a meeting, if you wave your mouse around or click/tap on a blank area within the main window, you’ll see the meeting controls toolbar, which you’ll use to control your audio/video, look at the text chat or participants list within a meeting, and also the Share option.

clip_image010[4]

clip_image012[4]clip_image014[4]Rather than sharing Desktop or Window, check out PowerPoint – if you don’t see the slide deck you want to present in the list of the most recently used ones, click on Browse and you’ll be able to navigate to it throught Teams channels and libraries (if your content is already in there), or you can upload it from your elsewhere.

The Teams client will render your presentation on each viewer’s machine, using less network bandwidth than screen-sharing does, and allowing more seamless multi-user control – so if you have multiple presenters in a single meeting, they can take over presenting the deck without having to be given overall control of the original presenter’s computer.

clip_image016[4]If you decide to put your PowerPoint file into a Teams channel and share / present it from there, it’s worth double-checking the formatting though; under the covers the Teams client will use the same rendering as if were previewing the file in a web browser.

You may find some slide transitions, animations or even some text layout will be a little different to how you’d see it in full-blown PowerPoint – to check that everything is OK, just navigate to the file within the Teams channel, and preview it from there.

If you do find the slides get mangled, you may be able to tidy them up within the Teams preview, or else you have permission to do the dastardly desktop sharing method.

For more information on sharing content within Teams meetings, see here.

514 – tweaking Outlook’s Ribbon

clip_image002Thirteen years ago, Microsoft launched Office 2007. Back when people looked forward to new releases of office productivity suites with a mix of excitement and dread, new features arrived by the boat load. While many functions stayed in later releases as core parts of the product, others led a wafer-thin existence then vanished.

One major change was the introduction of the Ribbon – a then-new way of organising the complex menu structure that sat within the individual Office apps. Despite complaints from some users, it quickly became established as a good way of presenting, in context, useful features that might otherwise have stayed buried in some deep menu structure. Competitors copied it too.

clip_image004

clip_image006Outlook – like other Office apps – has evolved its Ribbon over time, and introduced a simplified version that takes up less screen real estate. While your average user has moved on from squinting at a 15” CRT monitor, it’s still desirable for some to keep the less-used menu options hidden and to focus on the content. To switch between the standard and simple Ribbons, click the little caret mark at the far right corner of the main Ribbon UI.

clip_image008

So far, so good, but it you like the “Classic” Ribbon, there’s a lot you can do to get rid of some of the guff and keep the useful features more prominent. Looking at the first Ribbon image above, about 40% of the space is consumed with a handful of addins that might be useful, but not necessarily deserving of such prominence – your own list may differ, but the stuff on the right side tends to be a series of groups with a single, large icon in each.

clip_image010To clean up the ribbon, right-click on it and choose the Customize the Ribbon… option. You’ll now get a dialog box which lets you organise things – individual commands are displayed in Tabs (like Home, View, Help etc) and on groups within the tabs (New, Delete, Respond, and so on).

If you reduce the number of groups on a tab, the remaining ones may spread out and show larger icons or more detail – handy on the Home tab, if you like to use Quick Steps, which will expand out of one column.

clip_image012Let’s try moving some of the clip_image014less commonly used groups from the home tab – start by creating a new Tab and then right-click on it to rename it Add-ins or something like that.

Once you have the new tab created, it’s simple to start dragging and dropping defunct groups from the home tab onto the new one – things you might use occasionally but they don’t need to be on the main screen. Customisations are particular to the Ribbon you’re looking at – so if you organise the Classic one then switch to Simplified, you’ll still see the old arrangement until you customize that one too. You might want to export your finished layout too.

clip_image016

Looking at the restyled Ribbon above, all of the groups from Delete to Tags have been stretched to show more prominent icons or reduce the menu level a little, and Quick Steps has grown from one to four columns wide. Much more useful.

clip_image018If you’re a Quick Steps fan, another trick is to right-click on one of your existing steps (where you’d normally customize that step or jump into the dialog clip_image020for managing the whole lot), and choose Add Gallery to Quick Access Toolbar; meaning your array of quick actions is only a couple of clicks away, regardless of what is shown on the Ribbon.

507 – Momentum of Teams

clip_image002

It’s been a busy few weeks on the Teams team. As an aside, what do you call a team that’s set up in Teams? Is it a Teams Site, or a Teams team, just a “Team” or …? Documentation talks about creating a team, which is fine when you’re already in Teams, but talking with someone about Teams teams can be a bit like a tongue twister.

It was recently announced that Teams has 20 million daily active users, up from 13 million since July. Talk to enterprise customers who have adopted Teams, and many have a user base that really loves it. There may be more to the story, but as many Office 365 users get Teams as part of their subscription, it’s inevitable that its usage will grow. It’s great to hear stories of how customers are using technology like Teams to positively change the way they work.

clip_image004At the Ignite Conference in October, some forthcoming functionality was announced, from nascent integration into Outlook (coming next year) to some nearer-term stuff like the ability to create Private channels within a Team, which has already rolled out.

clip_image006Outlook Tasks and To-Do integration is also expected next year, and the app is increasingly being used as a focal point for other sources of data too – such as using PowerApps to bring business reports or other custom functionality into the same canvas.

See the recent clip_image008whitepaper on using PowerApps with Teams.

The App Studio in Teams allows enterprise developers to build their own extensions and addins quickly.

clip_image010There were quite a few Ignite sessions devoted to using Teams for calling and for meetings. clip_image012One innovation to look forward to is the ability to not just blur your background, but to add a specific background image, either from a library or one of your own.

Live captions – similar in approach to the subtitles in PowerPoint presentations that were recently discussed – is already available in a preview for some users.

Captioning and transcription is also available for Teams Live Events, if you enable the feature in the setup of the event.

506 – OneNote 2016 reprieve

clip_image002clip_image004OneNote is, for a lot of fans, the best application that Microsoft makes, especially in an educational setting. About 18 months ago, it was announced that the venerable and extensible (especially if you’re a OneTastic / OneCalendar user) desktop version was being put out to pasture, in favour of the more modern, erm, Modern version.

Office 2019 was no longer going to ship with OneNote – the desktop app was not being developed beyond OneNote 2016, but it would still be freely installable if desired.

Efforts would be focussed on the Modern / Store / “OneNote for Windows 10”, which shares a lineage with the mobile apps; there’s a lot to be said in favour of this strategy, since it would bring the UX of the Windows Store, tablet, phone and web apps into alignment. For regular ToW readers, this has been covered ad nauseam.

Well, blow me down, a brilliant Ignite session from @Ben Hodes only went and wound the clock back (and simultaneously painted it forward)…  [Check out Union Jack Man at 42:18 in the video stream if you want a laugh]

OneNote 2016 is getting some CPR, and will be installed by default with clean Office setups again, early in 2020.

Point of clarity – a clean Office2019 / Office 365 install doesn’t currently include OneNote 2016 … but upgrading from an existing Office install that already had OneNote, does. If need be, go to http://aka.ms/installonenote  to install OneNote 2016.

Some new features are coming, too – like Dark Mode, @mentions, To Do integration and more. The OneNote for Windows 10 code base is being back-ported to the older Win32 version; in time, the same underlying code will exist, even if there remains two versions of the product. It was previously reported that across the Office suite on Windows, the Win32 codebase will be favoured going forward, even though Modern versions were released for several of the traditional apps. We will have to wait and see.

clip_image006clip_image008Of course, lots of functionality exists in common between the two current versions of OneNote, even if the level of detail and the way to invoke and use it is a little different – take Record Audio, for example.

Did you know that if you insert an audio recording into your OneNote page, that any handwritten or typed notes you take while the recording is underway, will be linked to the corresponding place in the audio?

Later, if you click on a block of text or handwriting, you can play back the recording at just that point, or if you just start playing the audio, the notes you took will be highlighted as the playback progresses.

clip_image010In OneNote 2016, you can also have the application index the contents of audio recordings, looking for keywords. Enable it at  File > Options > Audio & Video.

No such function appears to exist in the OneNote for Windows 10 app; maybe that’s a good thing. After all, OneNote 2016 only lets you turn it on after an ominous-sounding warning…

502 – Presenting PowerPoint Subtitles

clip_image002If you’ve ever used PowerPoint to present to a group of people, you’ll be familiar with the Slide Show menu to some degree; unless you’re the annoying would-be presenter merely mirroring your primary screen and flicking through their slides without going into the full-screen slide show mode.

When they do it properly, you’ll often see presenters kick off by fishing clip_image004about with their mouse to click on the little slide-show icon in the toolbar on the bottom.clip_image006 It’s usually quicker to just hit F5 to start, or Shift+F5 to start from the currently-selected slide.

clip_image008Unfortunately, it’s still pretty common to then see the speaker be surprised because the config of their displays isn’t what they expect – especially the case if they’re sharing their screen on a online meeting, but their laptop is also connected to more than one monitor.

PowerPoint will typically be set up to use Presenter View by default, and the screen that’s being shared will be showing the speaker notes / next slides etc, while the full-screen content is being displayed on the 2nd monitor that isn’t being shared.

clip_image010To the right of the Monitor setup for presenter view, you may also see an intriguing option that has been added to PowerPoint – automatic subtitling, and translation too. It’s part of the ongoing Office 365 servicing that brings updates on a regular basis.

Choose the language you’d like to display, the location of the subtitles and when you start presenting, the machine will listen to every word you say and will either display what it thinks you’ve said in your own language, or it can use an online service to translate to subtitles in over 60 languages.

It’s fantastic. See more here. Go and try it now.

clip_image012There’s an older add-in which achieves much the same thing, if you’re not using O365 – see here for more info. The Presentation Translator addin also allows the audience to follow along and even interact with the presenter using the Microsoft Translator app on their phone.

Windows has a closed captioning setting page that applies to other apps that support it, too, if you’d like to show subtitles on video that has the content already defined.

Closed Captioning is legislated by several countries, for traditionally-broadcast media as well as online video.

You may also want to add captions to videos that you plan to embed – more, here.

Tip o’ the Week 500 – Greatest Hits

clip_image002Another milestone in Tip o’ the Week – 500 weeks. A bit more than 5 million minutes. A judicial sentence that would have meant a very serious crime. 500 weeks ago, Jay-Z and Alicia had an Empire State of Mind atop the US chart. Some months later, Newport State of Mind was a viral hit.

On days like these, it’s easy to reflect on previous glories and favourite moments. Brits of a certain age, start playing that TOTP chart rundown tune (without getting distracted by YouTube clips of what was actually in the charts back in the day – some of it was undoubtedly great, some just bad noise)… and get ready for probably the 5 best Tips of the Week since the whole sorry enterprise started nearly 10 years ago…


Horizontal lines – this one is incredibly handy when you’re formatting an email or document and need to demarcate a section of content. Simply type three (or more) dashes “—” and press enter. Bingo, thank Autocorrect for that piece of magic. First seen all the way back in Tip o’ the Week #16: All wiyht. Rho sritched mg kegtops awound?


OneCalendar / OneTastic – a fabulous addin to the pensioned-off OneNote 2016 (and its predecessors), the OneCalendar function shows you a calendar view of note pages, arranged by when you edited them. It’s brilliant if you use multiple notebooks, and you want to recall something you knew you did on a particular day (like the previous week’s regular call). OneCalendar spawned OneTastic, a suite of other useful addins and macros for OneNote.


clip_image004Sadly, neither feature in the new, Modern app OneNote (which you can start with Win+R, onenote-cmd: <enter> if you recall ToW 445). Though the modern app version is getting better all the time, it doesn’t have the same kind of addin architecture so OneCalendar/OneTastic is relegated to the legacy version. Still you can take notes in the new OneNote and as long as you have the same notebooks configured within the old one, then you can use either OneCalendar standalone or activate it by launching the old OneNote, just for searching your notes.

Actually, as ToW 393 covered, searching in old OneNote is better, anyway. ALT-O – who knew?

OneCalendar was first discussed back in Tip o’ the Week #98 – OneNote calendar front-end


clip_image006Copy as Path – a well-hidden but most useful Explorer trick that is of particular use when you’re fishing around for files to then add into another application; sharing, sending, uploading, that kind of thing. Within Windows Explorer, right-click on the file in question whilst also pressing SHIFT, and you’ll see Copy as path, which plonks the full path and filename of the file onto the clipboard, making it a snatch to reference it within the other application.

Originally uncovered in Tip o’ the Week #101 – Finding files for dialogs


WindowsKey + V – a fairly new entrant to this chart, a feature that arrived with the October 2018 update to Windows 10, and was redesigned a little in May 2019: it shows you the clipboard history, so you can recall URLs, screen grabs etc that you might have copied a few steps ago. Hugely useful once you remember it’s there, once you’ve enabled it. See more in Windows help. First look was in Tip o’ the Week 482 – Paste History


404 – not so much of a tip, as a practical joke played in email. It doesn’t work quite the same in the browser, but you’ll get the idea. Also has some of the best tangential links to random content.

Guess what? It was in Tip o’ the Week 404 – [%subject%] not found %&


Thanks to all the regular readers who provide feedback, ideas and encouragement!

Will anyone still be here for ToW1000?

Tip o’ the Week 499 – Cortana resurrection?

clip_image002Cortana was supposed to be the differentiator for Windows Phone. 5 years ago, before Alexa had wormed her way into kitchens of millions of people and forced Google to respond with their range of devices, Siri and Cortana were the assistants in town. When Windows Phone carked it, Cortana transferred her attention to Windows 10, though there have been a few redesigns after feedback from users, such as preferring to have the search dialog shorn of Cortana-ness.

clip_image004In latest news, rumours have surfaced of some kind of Microsoft speaker to be announced, though it’s purely a design patent rather than any details of what it might do – Cortana? Or just a companion device for making Teams calls? Time will tell. The same source unveiled a patent for a Roundtable type device at the same time last year – ahead of the autumn Surface launch event – and nothing seems to have come of that yet.

clip_image006The much-trumpeted GLAS home thermostat (competing with Nest, basically) has dropped Cortana from the device, and the Cortana-powered Harman Kardon Invoke speaker (which, by all accounts, is a really good speaker) has sunk beneath the waves following a fire sale to get rid of stock. Cortana is reportedly disappearing from Xbox too, though a wider speech strategy is in place so she won’t go too far.

Cortana has been repositioned from being a consumer service or device, to a series of services that add value by integrating with your productivity applications and services. Additionally, efforts have gone into making speech/AI assistants interoperable.

In a recent Windows 10 build pushed to Insiders, Cortana is getting a new look – again – and will eventually roll out around the world, rather than be limited to a few locations as it had been previously.

clip_image008If you’re on the insider program for Windows 10 and using a UK language machine, you may find that the new Cortana app doesn’t want to talk to you, unless you set English (United States) as your Windows Display language.

Also click on each entry in the Preferred languages list, and make sure you have all the speech and proof-reading features installed.

clip_image010The original vision of Cortana’s usefulness is evolving so that when you enable the service, it now searches your email and calendars on a variety of sources (Office 365, Gmail etc) and will remind you when you say things in email (eg I’ll give you a call on Tuesday) – it’s vaguely spooky when you first start to use it, but after a while proves to be really useful.

As To Do and the Microsoft Launcher continue to improve and integrate, the original vision of Cortana might well come back to being more than a gimmick to ask for directions or the current weather – a genuinely personal assistant that will help you organise your life and get more stuff done.

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 497 – 21st Century Morph

clip_image002Morph was a clay stop-motion animated figure from the late 1970s, who featured on a BBC children’s programme, Take Hart. He was created by Aardman Animations, who later went on to create Wallace and Gromit, amongst many others.

Morphing is a special effect used to move between two forms or images, gaining ground from the late 1980s as software allowed smooth transitions between different pictures or moving images – used heavily in movies like Terminator 2, for example.

This week’s tip was inspired by Dan Scarfe of New Signature, who commented, “I think of my life in two halves: pre-morph and after-morph.” It’s not often a feature in a software package can have such a life-changing effect, and for most of us it will be less profound than on Dan. Still, it’s worth a closer look – and was first mentioned on ToW back in July 2016, a tumultuous time in British politics. Plus ça change

clip_image004The Morph feature is a Transition in PowerPoint – meaning it’s applied when moving from one slide to another, when presenting. These are powerful capabilities that need to be used carefully for maximum effect – there’s a temptation to add whiz-bang transitions and animations just because you can, but often, a subtle and steady hand works better. See some tips here.

If you want to animate shapes moving from one part of the screen to another, just copy the starting slide from within the slide sorter view, paste it to create the destination, and then move/size/colour the shapes as you see fit. Select the second slide and in the Transitions menu, chose Morph… and that’s it.

Example: blue rectangle 1 will move to the opposite corner of the screen, the number size will shrink and it’ll change to green. 2 will slide across to the top left and the number size will grow, while 3 will drop down and also grow. The star changes shape and orientation, adopts a textured fill, all while also moving to the lower left.

clip_image006clip_image008clip_image010Here’s a screen-grab taken during the transition – it’s smooth and, basically, magic.

Here’s some more info on using Morph. Download the PowerPoint PPTX file of this example, here.

Back to Morph, the plasticine man: turns out he did have a life in the 21st century as well – after a Kickstarter campaign, two whole new series of short videos were commissioned and along with lots of archive material, released on Morph’s official YouTube channel.