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.
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.
The simplest way to present slides on Teams is to use the 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 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 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. 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? |
Category: Productivity
575 – Who’s meeting?
![]()
Who has responded? Have most people declined?
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.
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… 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.
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
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 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
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.
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.
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
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.
– 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 Time – GMT+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. 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.
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. 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…
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. |
570 – Automation for all
All were replaced in time with rebranded but otherwise similarly targeted variants:
2020 saw a fast move to hosting everything digitally and for the most part got away with it. 2021 was always going to be different, and the first big do of the year took place this past week – a spring Ignite. When you don’t need to book a conference centre 12 months in advance and get thousands of people to fly in to attend, why not do some of the big events more often or a different time of year? For a summary of what was being announced at Ignite 2021, check out the excellent Ignite Book of News. Charles Lamanna’s keynote on Power Platform highlighted some news around Power Automate – one of the key components of the Power Platform and formerly known as Microsoft Flow, Power Automate began as an online service that could make workflows to stitch together actions that happened across multiple online applications –a new booking alert email to a hotel mailbox could add an appointment to a Google Calendar and send a notification to someone on Microsoft Teams, and so on. Just announced is that the fairly new Power Automate Desktop will be included in Windows 10 and is free to download and use now. This tool brings automation concepts right down to the desktop, allowing any end user to create flows that span multiple apps and services; it’s not unlike an advanced Macro Recorder, where the user can perform a task that is regularly repeated, and the software will keep track of the steps they’re making. With PAD, however, it’s more than just repetition – they can go back and inject data into those steps, like take the email addresses from column B of this spreadsheet and send a specific email to each one, with logic determining what should be different for each message (so a lot more granular than a simple mail merge).
This capability has come about through Microsoft acquiring Robotic Process Automation specialist company Softomotive in early 2020. The impact of RPA is explored when looking at how this technology could remove boring, repetitive tasks thus freeing up clever and creative people to do something better with their time and attention. On one hand, automating processes could be a threat as we’ll need fewer people to do the same things, but a more optimistic view is that it will increase productivity and satisfaction. If you have 17 minutes free, then check out a great TEDx talk on “White Collar Robots”. There’s a great demo of Power Automate technology being used in real-world scenarios, on Microsoft Mechanics. See more videos from the makers on Microsoft Mechanics – YouTube |
568 – The Race for Space
The “space race” continued for some years afterwards (the US had Skylab in the 1970s and built the Shuttle, while the USSR built Mir, the first proper space station), before numerous countries decided to pool resources and build the International Space Station. After unveiling Azure Space in late 2020, the 20th February 2021 – 35 years to the day after the first Mir mission – saw the launch of the ultimate in Edge devices, ensuring Azure reaches the ISS with HPE’s Spaceborne Computer-2. That will be furthest Cloud-Edge computing node until we finally become an interplanetary species, and once again leave the confines of low-Earth orbit. Edge back on Earth If you want to make the most of the space on your screen, you should try moving your Windows taskbar to the side rather than the bottom of the screen – follow the science – as it makes more efficient use of the screen real estate, especially if you have a big widescreen monitor. Open Taskbar settings here and choose Taskbar location. If you’re a vertical taskbar fan, then you’ll like a new feature in the Edge browser, also designed to maximise the use of space – vertical tabs.
By enabling the vertical tabs feature, a single click will show them to the side of the browser window. Click the < caret to the top right of the tab list and they’ll collapse to icons only until you mouse over again, and the full width will be shown.
If you’re using the beta or dev version of Edge, you’ll be able to show the Vertical Tabs button in the Appearance section of the To enable vertical tabs on the current public release, enter edge://flags/#edge-vertical-tabs into the address bar of the browser and switch on the “experimental” feature; you’ll have to restart the browser for it to take effect, but after that point you’re free to try switching the arrangement.
|
566 – Who’s Better, Who’s Best?
|
564 – Do Mention It
The same behaviour is commonly available in Teams as well, though it may be more limited as to who you can mention – in the chat for a meeting or in a Teams channel, you’ll typically only be able to @mention the people who are taking part or who are already members of the team. Like other uses of the @mention idiom, tagging someone will insert their full Display Name, as defined in the Microsoft 365 environment (or the address book if you like) – which can make mentioning people in a chat feel a little directorial or formal, especially if the format of their display name is something like FamilyName, GivenName (DEPARTMENT).
In most uses of the mention, you can edit the full name of the person, though it’s not quite consistent how to do it – in Teams, for example, merely pressing backspace (after the display name has been resolved) will remove the last word … so if you want to tag a colleague and their display name is Jane Doh, then a quick tap will reduce that to simply Jane. If they were Doh, Jane (IT) then it’s a little more complex to lose the formality – holding CTRL+SHIFT while pressing the left arrow will select a word at a time, so you could ditch the last part of the name then simply CTRL+Left arrow would skip the middle part, then CTRL+SHIFT+Left arrow/Delete will remove the first part again. Lesser platforms might allow a user to set a nickname that is used in place of their display name; that’s not (yet) an option in Teams etc, though in Outlook when you mention someone, you could insert a nickname in-between other names then remove the original ones, leaving only the short name you’ve added, but still hot-linked to their contact card etc. It’s a bit clumsy but might be preferable to calling them by their more formal name.
Just click the sort/filter option found to the top right of your Inbox or other folder, and choose Mentioned Mail to show only messages where you are mentioned. As with all such features, it works for some people and work cultures/environments better than others. For some external best practice guidance, see here or here. |
561 – Password clean up
Or just scan them all in then recycle… Maybe it’s time to finally sort out all the passwords you use for different websites. Even though Multi-Factor Authentication is gradually replacing the need to enter a username & password every time you access a resource, there’s still often a need to create a username and password combo when you sign up for something. If you’ve used Edge or Chrome to remember your passwords, you might find there are many hundreds of them, and being weak carbon-based lifeforms, we’re quite likely to use the same ones for many sites. Naughty!
Microsoft Edge offers some password management capabilities – as well as being able to remember passwords within the Edge browser, and sync them between different machines or mobile devices, Edge is also getting to be capable of suggesting and storing complex passwords for new sign-ups.
In some senses, storing passwords and allowing them to be automatically filled in feels like a security risk – anyone with access to your unlocked computer or phone could potentially access your online services. Using Autofill and Authenticator, though, the default setup is to require biometric authentication – so you’ll need a fingerprint or camera, or unlocking with a PIN, before the auto-fill will happen. Also, it’s more important to have complex passwords that are hard to break or guess, and to have different ones for each and every site or app you use. This is the final ToW for 2020. Let’s hope ’21 brings us all better luck. In the meantime, have a great holiday season, stay safe, see you on The Other Side! |
558 – Sharing your holidays
Really progressive people might even be sharing their calendar details with you, so you can see what they’re doing – useful, as all-day busy events obliterate everything else if details are not shown. If you’d like to tell other people you’re going on holiday, then you should create a 2nd appointment and invite your colleagues to it; but there are 3 important steps to take when you do this so you don’t muck up their calendar and annoy them to boot. When creating your second “FYI” holiday appointment:
While we’re setting the appointment up, it’s OK to not use Recurrence too – some people think that the way to make a multi-day appointment is to set a one-day meeting that recurs every day for a week. Don’t do that. Just set the start and finish Now all you need to do is create a suitably informative and entertaining Out of Office message and you’re all set! |