585 – Heading to Viva

clip_image002Back in the mid/late 20th century, the mainstream car market in developed countries was quite localized, where certain brands were seen as the default. Italians drove Fiats and Lancias; even until fairly recently, pretty much all you’d see in French towns were Citroëns and Renaults. The biggest blue-collar rivalry for Brits, Aussies and many Americans was undoubtedly… are you a Ford family, or a GM family?

In the UK’s 1970s, Ford had the Fiesta (small), Escort (mid), Cortina (large), Capri (sporty) and Granada (executive). GM operated in mainland Europe as Opel (Kadett/Rekord/Monza/Senator etc) and in the UK, as Vauxhall (Chevette/Cavalier/Carlton etc). Brits of a certain age may fondly? remember the Escort-sized, everyman family car: the Vauxhall Viva. The announcement of the employee wellbeing platform, Microsoft Viva thus brought a misty-eyed moment of reflection for some…

clip_image004Since the unveiling in February 2021, Viva functionality has been gradually added to a variety of Office 365 experiences from Topics (based on what was called Project Cortex), Learning (highlighting online learning materials from a selection of company-curated sources, including stuff from LinkedIn Learning), Connections (a modern take on the company intranet) and the first module which was available, Insights, which is accessed via an app in Teams.

The Insights-defined “Virtual Commute” and calendar-blocking Focus Time has been mentioned previously in ToW #577, but it’s had a new shot in the arm as well as announcements about forthcoming improvements, such as the ability for Teams to quieten notifications when you’re in a focus period, and quiet time when Teams and Outlook will shush pinging you outside of working hours.

Now rolling out to Viva Insights is a set of mindfulness and meditation exercises curated from Headspace, who produce a load of online video as well as Netflix series and in-flight channels. See more about Headspace in Viva Insights, here.

clip_image005

584 – Office Apps expansion

clip_image002Subscribers to Office 365 / Microsoft 365 obviously get a load of services like email, OneDrive storage, SharePoint and so on, as well as client apps like the full-blown Office suite. Over the years, the app experience has got quite a lot closer with the web clients sometimes advancing faster than the desktop or mobile apps, meaning that it’s increasingly viable to live your life entirely in the browser.

clip_image004The Office home page – on www.office.com when you’re signed in using your M365 account, or maybe even installed as an app on your PC – shows a list of available apps if you click the grid icon in the top left. Initially you’ll see the most popular or your own most recently used apps, but try clicking on “All apps” for the full list of what else is offered.

What you’ll see depends on what kind of subscription you have and what previews you might have opted into, as well as what apps may have been published by your subscription’s administrators (eg internal HR website or IT support desk sites could be listed there).

clip_image006

To keep things interesting, you can also install most of these web apps as Progressive Web Apps on your PC – using Edge, go to the Settings “…” menu in the top right, and look for the Apps menu option. They will then appear in the Start menu, can be pinned to the Task Bar and run in their own discrete window, just like a “real” program would.

One app which could roll back the years for a lot of people is Visio. Microsoft bought the diagramming software company at the turn of the century, for what was the largest acquisition to date – check out the list of other deals and see if you can remember many of those other $100M+ names…

Microsoft Visio became a premium addition to the Microsoft Office suite, latterly being sold as an add-on like Project. The software has continued to evolve over the years and has its own band of fans who use it for mind mapping, flowcharting, network diagrams, room layouts and so much more. You can even build Power Automate workflows using Visio (see more here).

clip_image008It was recently announced that Visio is coming to a good many Office 365 subscriptions next month, for no extra charge. The “lightweight” web app approach is not going to supplant the full application for more complex purposes, but it still offers a wide range of templates that can be used to start some fairly snazzy drawings, all done in the browser.

If you’d normally turn to PowerPoint to try to create graphical documents like flow diagrams or simple org charts, keep an eye out on the All Apps list to see when Visio makes an appearance, and give it a try.

clip_image010

583 – Zooming PPT

clip_image002The Pandemic may have exposed millions of new WFHers to the delights of video conferencing, but the Zoom in this week’s ToW has nothing to do with the eponymous meeting company, rather it deals with a very cool yet somewhat obscure feature in PowerPoint, called, er, Zoom.

Way back when, there were numerous product incubation groups in Microsoft, who tried out new features as addins or companion products; over time, most of them have disappeared or the prototype products they produced made their way into the mainstream (or just quietly went away). Innovation continues within the various engineering groups, of course, and some is curated in the Microsoft Garage.

One OfficeLabs project that showed promise was pptPlex – an addin to PowerPoint that made it easy to create and present “non-linear” presentations, offering a kind of “Seadragon” type experience of zooming into content. The actual pptPlex software is long-gone but if you want a reminder of what it was like, or even to recall how funky Office 2007 looked, check out this video tutorial.

clip_image004But like other Labs innovations, the ideas were re-born in other ways, in this case in the PowerPoint Zoom feature. This lets you essentially embed a thumbnail of a slide into another one, optionally even replacing the mini-version of the slide graphic with a custom image; in the example shown below, rather than a miniscule chart of stock price, we’ve put the company logo instead, but clicking on it drives a nice zoom transition to a separate slide which has the real chart.

clip_image006It’s probably easiest to see by example so check out the download here – to experience the Zoom effect, put the file into Slideshow mode.

For more info on using Zoom, see here.

580 – Let’s Lens

clip_image002For some years now, Microsoft has produced an application for mobile devices, which allows easy scanning of bits of paper, photos from physical whiteboards or importing of contact info from business cards.

The “Office Lens” app was originally produced for Windows Phone before being ported to iOS and Android. Later, a PC version came along but with the death of Windows Phone it hardly seemed worth keeping going, since scanning docs and business cards etc is so much easier from a handheld device. As a result, Office Lens on the PC is now gone – dispatched at the end of 2020; if you had installed it previously, you could still use some of its functionality, though the smarter online services that sat behind it are no longer available.

clip_image004Instead, the old Office Lens mobile apps on the surviving smartphone platforms has been renamed “Microsoft Lens” – along with the release of some improvements and new features.

There are tweaks to the algorithms used to detect edges of documents when scanning pages or turning a receipt snapped at an angle into a square-on image. It’s not always perfect, but you can drag the apices to tidy up the process, and save pages as images on their own or multiple pages of a document into a single PDF file, straight to OneDrive or local on the phone.

clip_image006There is also a new “Actions” feature which lets you interact with reality – grab text from something you point the camera at, and potentially feed it into the Immersive Reader so the phone will read it out to you. You can also extract a table from the physical world, or scan a QR code or barcode from something in your hand.

clip_image008The QR scanning is pretty slick, focussing on URLs or files, quickly enabling you to follow the link or view the doc (and ignoring some types of QRs used for encoding a membership number or serial number of a device, etc).

Similarly, barcode reading just brings back the number, whereas some other apps will provide a bit more context – Lightning QR Reader for Android, for example, can read any text encoded in a QR code and will also give some more details for barcodes, like decoding ISBN codes on books to let you search for more info on that specific title. Still, Lens provides a neat & quick solution for scanning or capturing all kinds of info.

clip_image010Microsoft Lens (on both Android and iOS) is described as a PDF scanning tool, but it’s also got a ton of extra functionality which is worth checking out if you haven’t used it for a while.

579 – Archive that email

clip_image002There was a time when archiving email meant taking a few Megabytes of data away from the restricted space within your mailbox, and possibly storing it for posterity in an a PST file on your PC, where the mail would stay until eventually the file is either corrupted or deleted with no backup being taken first, whichever inevitable event happened first.

clip_image004Thanks to Moore’s Law, mailbox capacity is now less of a constraint. Having too much clutter and the distraction that it causes is a more pressing issue than not having enough space.

There are tools – some mythical and magical – to reduce volumes of unnecessary emails, and automatic processing via features like the Focused Inbox or Clutter can help to filter out stuff that is getting in the way, but fundamentally the decision on whether to delete, defer, delegate or just leave it lying about, rests with the user.

There is still an AutoArchive function in Outlook, but you probably don’t want to use that.

clip_image006Instead, look at the simpler “Archive” feature, which is available for Microsoft 365 users and appeared first in the web client before making it into desktop Outlook. If you haven’t used the Outlook Web App for a while, it’s worth having a look since it has evolved massively over the years, and often leads the way for new functionality and integration, compared to its desk-bound precursor. There is a view that eventually, the web client will replace Outlook on the PC.

If the Archive option shows up in the web UI (with suitable icon), the folder should also be visible in desktop Outlook in the main folder tree. Just like you have an Inbox, Drafts, Sent Items clip_image008and so on, it will have been created for you but you may need to expand the view to locate it. And no, you can’t rename it…

Check out the Archive folder properties, and you can see its size on your own machine or on the server (assuming that you’re not storing everything in your mailbox within your Outlook cache).

To fire an email into the Archive folder from the desktop Outlook client, just press backspace if you’re currently viewing the message in the preview window. The default shortcut key to archive a message in Outlook Web App is E though you can reconfigure the app to use different shortcut schemes, in case you’re more familiar with other web clients. To see the shortcuts in Outlook web app at any time, just press the ? key.

clip_image010

577 – Wir Fahren auf der Autobahn (virtuell)

clip_image002Fans of the fathers of elektronische music will get the reference to the seminal track Autobahn, written to mimic the repetitive noises of driving along the motorway. Since most of us have not being doing much of that for a while (and nobody misses being stuck in a traffic jam on the M25 on a Friday evening), a new addition to Microsoft Teams from the previously announced Microsoft Viva could be a welcome distraction.

clip_image004Start by looking for the “…” menu on the left-side icons bar in the Teams client, and you’ll see additional apps that can be added to the menu (and once there, you can right-click on them to pin in place); a previous update to Teams lets you drag the icons’ placement to your own preference too.

You can jump between the apps in Teams by pressing CTRL+n, where n is the corresponding location on the bar (ie CTRL+1 for the top app, CTRL+2 for next down etc).

Open the Insights app to see the first-released Viva application, which has also been recently updated.

clip_image006

Viva Insights lets you send praise to colleagues, do some quick & mindful breathing exercises, check on actions you may have mentioned in email (eg “I’ll get back to you on Monday…”) and block out time that’s currently free in your schedule to give you a chance to focus on work you’re supposed to do, rather than meeting with people to talk about it.

Newly added, is the Virtual Commute – go to the Protect Time tab, or look in the top-right settings menu “…”, to set up the time to finish your work day.

clip_image008

You can now have Teams remind you that it’s time to go home, even if you’re home already.

Jared Spataro wrote recently about the need to give yourself breaks between meetings and to transition from “work” to “home” modes.

If you’d like to jazz up your Teams background image rather than showing your real backdrop, check out the Viva backgrounds now available in the custom backgrounds gallery for Microsoft Teams.

clip_image009

576 – Presenter guidance

clip_image002Remember when presenting to a room full of people was a thing? At some point, we may get back to needing to do that, but in the meantime we’re probably presenting to smaller groups of people using Teams or some other form of video meeting.

It’s still worth tailoring your presentation style, especially so when you can’t necessarily see the audience – that guy who’d be dozing off in the front row of the presentation room? He’s now doing that on mute and with camera switched off. Creating compelling content is another huge topic which is even more important than the means by which you present it.

clip_image004Firstly, when it’s time to present your slides in a Team meeting, please don’t just share your screen. Most of the time, the PowerPoint sharing experience that is built into Teams is good enough.

If you have a specific reason to share the screen or app then please at least “Present” in PowerPoint, since simply showing a PPT window is a massive waste of screen real estate and your attendees won’t be able to read it.

clip_image006If you’re wary of presenting in a multiple-monitor setup (in case your slides end up on the screen you’re not sharing, and the non-existent speaker notes gets displayed to the meeting attendees), then go into Set Up Show on the Slide Show tab in PowerPoint and choose which monitor you want the slide presentation to appear on (and share that one in Teams). Worst case, just disable Presenter View in that same dialog, and then PowerPoint will only use one monitor.

The simplest way to present slides on Teams is to use the clip_image008PowerPoint Live feature from within the Share icon – it will show you a list of recently opened PowerPoint decks, or let you browse your machine for one if it’s not visible.

This view will let you share content in a more efficient manner, and also gives the option of letting other presenters easily manage the transition from slide-to-slide, rather than having to rely on trying to take control of the presenter’s PC in order to advance them, and avoiding the “Next Slide Please” request. Attendees can privately move around your deck if you allow it.

You can also start the sharing from within PowerPoint, as long as the source slide deck is saved to OneDrive or Sharepoint, as the content is rendered as a web view. Go to the Slide Show tab clip_image010and you’ll see a Present in Teams icon; click on that when you’re in a meeting, and it will automate the whole sharing process to start presenting your current slide deck.

Assuming you’ve managed to create slides which are not a mess and are comfortable about how you’re going to present them, the next step might be to polish your own performance.

You could use Rehearse Timings to do a dry run of your presentation, and it will record the time it takes to cover each slide (and will also save that timing so clip_image012you could auto-matically advance the slides during a future presentation).

If you’d like an unbiased assessment of your presentation style, try out the new Rehearse with Coach feature – as well as getting some real-time tips during the rehearsal, you’ll get a report when completed, praising for a job well done or admonishing you for speaking too fast, just reading the slides out loud, using, errm, non-inclusive language etc – all of which might be used to help improve your delivery for the next time.

clip_image014

Have a play with the Presenter Coach – presuming it’s an automated service rather than a real human listening in, it’s fun to try and see how the recommendations given – see how many profanities you can get it to recognise?

575 – Who’s meeting?

clip_image001Organising a meeting in Outlook means sending out requests to participate – effectively you’re creating an appointment or event in your own calendar, then converting into a meeting by inviting other people to join you. If you’re putting something in your diary and want other people to know about it, but without expecting them to join you (eg you’re going on vacation and presumably don’t want your teammates to tag along), simple tricks can reduce the annoyance you might foist onto your co-workers…

  • clip_image003Create a separate appointment for sharing (rather than forwarding one already used to block out your own calendar)
  • Under Response Options, clear the default “Request Responses” option, so they don’t need to respond
  • Set Reminder to None so people don’t get a notification fired, unless you think you’re important enough to make sure they know at the time, that you’re away
  • Show As: Free, so your appointment doesn’t block out their calendar and get in the way of other people who are trying to book proper meetings with them. Think of this as an FYI for colleagues’ calendars.

Who has responded? Have most people declined?

clip_image005When you open a meeting you’re organising and which you do want people to respond to, you’ve always been able to see (in the Tracking tab) how many people have accepted or declined etc. A couple of years back, Outlook added the feature of Tracking if you’re an attendee, so anyone in the same tenant as the organizer can see who else has accepted etc.

If you are organising or attending a large business meeting with lots of attendees, it’s useful to be able to slice and dice the attendees more effectively – have most people declined and should I move the date, for example – click on the big Copy Status option at the top of the list.

clip_image007It’s now easy to paste the info into a blank Excel sheet, and before even changing selection, hit the Format as Table option on the Home tab; confirm the selection area is OK, tell it you want to add a header row and choose a style that suits.

If you right-click the table and select Table > Totals Row then if you filter the headings – like the responses, for example, you’ll be able to quickly see how many Accepted, Declined and so on.

What could be interesting, too, is showing attendees names alongside their role, department, which office they’re from, their actual email address etc…
clip_image009

Well, thanks to the magic of macros, use this Address Book Resolver spreadsheet, and just paste the responses from the Copy Status… step into cell A1, then hit the Resolve button.

Some attendees might be external users (so won’t be known to your address book), and some of the names in the first column might not be unique enough to resolve, and will be highlighted (alongside external users) by a red Unknown in the Job Title column.

clip_image011If you manually look up an unresolved internal user in the Outlook address book, and find the correct alias name for that person, paste it into the first column instead of their name, and re-run the Resolve function.

To use this sheet for resolving any list of bulk display names or alias names, just paste them into column A (and hide Columns B and C if you’re not using the output from a meeting invite tracking list).

To prepare the spreadsheet for use, download the Address Book Resolver file as above (here it is again). Open the ZIP file and open the enclosed XLSM file or save it somewhere on your machine, then open it. Make sure you Enable Editing, then Enable Content so you can run the Macro that does the lookups.

This is an evolution of the Alias resolver sheet posted back in ToW 417.

573 – Searching in Outlook

clip_image002A reader recently got in touch to ask for help in finding stuff in Outlook. The search capability within the application most of us use most of the time has evolved considerably throughout its life, with a prominently placed search bar now adorning the top of the main window. When you click into it, lots of helpful filtering and searching capabilities are offered in the ribbon below.

clip_image004It’s worth getting to grips with a few simple text search terms, though, so when you’re typing some search term you can direct Outlook to particular items. Helpfully, using the options in the menu will actually build the query that is fed to search, so you can type them in future. Simple quick wins include things like using from:name to show only clip_image006emails that originated from a particular sender.

Or has:attachment, which will only show you mails that have other files attached. Combined with a few other criteria, you can filter the results of your search pretty hard, rather than sifting through them. Adding some other smarts like received:”last month” can streamline some more. For more info on search terms, see here.

The scenarios our reader posed, though, were specifically around searching in the calendar – eg, do I have a meeting in my calendar with a particular person? Or what recurring appointments are due to expire this month?

If you navigate to your Calendar and click the down-pointing arrow to the right of the Search box, it will display a clip_image008small form with series of other fields you can complete, in this case relevant to appointments rather than messages.

Click + Add more options to bring up a picker that lets you add even more – such as whether the meeting is a recurring one, or if it shows in calendar as Busy or not. Selecting the options builds the query as before, so you can see a variety of defined names – like organizer | organiser (depending on your locale) or requiredattendee:.

Coming back to the original question; if you want to find all future meetings in your calendar with anyone called Tony, you could type something like requiredattendee:tony start:>today. And if you want to find out which clip_image010recurring meetings are expiring soon, start by searching is:recurring start:>today. That will show you a list of future recurring appointments, but not give all the info we’re looking for since the default results view doesn’t show anything about the pattern of recurrence – so right-click on one of the column headings of the search results and select Field Chooser, where we can add some extra columns to the view.

clip_image012Now, in the pop out window, change the filter from Frequently-used fields to All Appointment fields, and scroll down to find Recurrence Range End. Now drag and drop that field into the column list, then click on it to sort descending so you’ll now see all the meetings that are set up with a recurring pattern, ordered by when that pattern is due to end. For added context, you could put Recurrence and Recurrence Pattern on there too.

clip_image013

Don’t be alarmed if some of them are due to keep happening until a very long way into the future. We’ll probably have stopped using email by then.

History Lesson

Before Outlook arrived as part of Office 97, users of Exchange Server had an email client and a separate calendar app (Schedule+; that’s why some diehards still say things like “send me an S+”, meaning send a meeting request). Both would maintain a connection to the server and would chat back and forth, only downloading data when a message or attachment was opened. Although this put something of a penalty on the network, it meant there was no need to cache large amounts of data on a PC hard disk. Outlook replaced both the mail and S+ clients, but maintained the same synchronous connection to the server.

Outlook 2003 and Exchange 2003 changed the default model, since PC hard disks were getting much bigger and cheaper, so it made sense to have Outlook deal primarily with a cached copy of the user’s mailbox, bringing all kinds of performance benefits to both end user and to the operators of the server back-end. One really notable improvement was the ability to run fast searches against mailbox data that’s in the cache, rather than having to execute searches on the server.

Prior to the cached mode, the best-case scenario for running a search was the server returned messages that fit a particular query asked by the client – mails received this week, mails with FOO in the subject line etc. If the server had indexed the relevant properties (received date, subject etc), it was pretty quick at sending back the results. If the user wanted something more in-depth, it was a punishingly slow process as each message would need to be picked up and inspected to see if it met the query – so searching for every email with a particular word in the message body text would be laborious. Three cheers for cached mode and client-side indexing.

clip_image015If you look at Advanced Find in Outlook today, though, you’re staring into a time vortex that transports you right back to the late 1990s, as it hasn’t really changed, even if the speed of getting results back will be noticeably better since you’re almost certainly pulling them out of a local copy of your mailbox.

The first couple of tabs on the Advanced Find dialog let you search for mailbox items that fit some common criteria – but the third tab is a window into how Exchange stores and categorises messages, appointments, tasks etc.

clip_image017You can start Advanced Find from the Search Tools menu option as above. Or press CTRL+SHIFT+F.

Aside: most apps use CTRL+F to invoke Find – try it in Word, Excel etc – but in the mail client, CTRL+F forwards a message instead. Find out why, here.

The idea here is that you can build a query based on properties of messages – and when you select the Field from the extensive drop-down list, it would let you choose appropriate filters (some, like Flag Status or Receipt Requested would only have a couple of possible values, but others would let the user enter text, date or numeric filters).

Not all of the fields are used for much these days – eg InfoPath Form Type harks back to the days when the now-defunct InfoPath could be used to create mailable forms – but having a poke around in Advanced Find can give a curious user some insight into how Exchange and Outlook organises their data.

#571 – Save the Daylight

clip_image002In the Northern Hemisphere, spring feels finally underway – and following a long locked-down winter, it can’t come soon enough. For many of us, even if meteorological spring started nearly 2 weeks ago, the promise of summer starts when the clocks go forward to daylight saving – or summer – time.

If the country or state you’re in observes summer time, then you’re either about to enter (if in the northern half of the marble) or leave it (if southern). To keep us on our toes, this movement back or forth often happens around the world on different dates. To keep us on our toes, some countries have less-than-hour gaps between time zones, and in the past, others have decided to change time zone permanently.

clip_image004In olden days, some people wore GMT or World Time watches, which allowed the user to tell what the time was in different locations. With the World Time example here, the red arrow hand points (on a 24hr scale) to the current time; when the user rotates the outer bezel so that the nearest location is pointed to by that hand, the other locations listed on the bezel will be aligned with the 24hr number of the current time in those places…

– eg if it’s 2:30am in Iran, then lining Tehran up with the red hand would put both London and Paris at midnight, since they’re both at GMT+1.

eh? In October 1968, the UK decided to move to British Standard TimeGMT+1 – all year round. This particular wristwatch was produced between 1968 and the end of 1971, when the practice was reversed – so for a while, it was correct that London would be in the same time zone as Paris and Rome. Except the watch wouldn’t know when Paris and Rome went into summer time, thus putting them an hour further ahead… oh well, never mind.

clip_image006There may be trouble ahead

In a global working environment, especially one where everything is done online rather than having people in the same location, the friction of time zones changing has never been more obvious. Usually, you’ll only move through time zones relative to everyone else when you travel – flying across large distances, or maybe just driving across a bridge or dam.

But now, a digitally-oriented meeting can shift its time for some of its attendees, relative to the others – depending on where the originator is based.

clip_image008The excellent Alarms & Clock app, which is part of Windows 10, lets you pin cities around the world to a map, showing their approximate location (bet you didn’t know Brissie was south east of Sydney?) and what the time is currently, and if you click the Compare icon to the left of Add new city, you’ll see a grid indicating the relative time in all of your pinned cities. You can jump to a specific date, so if you’re planning a meeting with people in different time zones, it might be a good idea to check what the impact of Daylight Saving Time (DST) changes might be.

Those parts of the US which observe DST, are due to move an hour forward this coming Sunday (ie March 14th). In common with doing things differently to everywhere else, that brings the US (and Canada) one hour nearer most of Europe for the next two weeks, until the end of March. Much of the southern hemisphere comes out of DST the week after that, so by then Sydney will be two hours nearer London than currently.
More info.

The impact of this can be seen in peoples’ calendars, when regular meetings somewhat inexplicably start to clash with each other – if a UK organiser set a recurring meeting for 4pm GMT, that would normally compel Seattleites to be there at 8am, but since they’ll be only 7 hours behind for a couple of weeks, that shifts to 9am in their calendar, potentially clashing with some existing 9am Pacific Daylight Time meeting.

Conversely, a 9am PST / 5pm GMT meeting as created by the person in the US a few weeks ago, would now start at 4pm in the afternoon in London. Great news if that meeting is a Friday afternoon, as it brings beer o’clock one hour forward.

Although Outlook does a pretty decent job of juggling the differences between time zones, there is no obvious way to show what time zone a meeting had been created in (eg show me all meetings that are going to be affected by this shift for the next 2 weeks). A simple trick if you want to check on a specific meeting, is to start a Reply to a meeting you’ve been invited to, whereupon you’ll see the time zone of its creator…

—–Original Appointment—–
From: originator

Sent: 14 February 2021 08:03
To: people

Cc: more people

Subject: meeting that could have been an email
When: 12 March 2021 08:30-09:00 (UTC-08:00) Pacific Time (US & Canada).
Where: Microsoft Teams Meeting

While It won’t help you identify the meetings that are causing the clashes, it might help restrain you from firing angry missives at the organiser of the meeting, if you know what’s causing it.