Anyone who has delved into writing formulæ in Excel will probably have had to manipulate strings of text at some point, possibly to clean up formatting or to convert what Excel thinks is a simple block of text into more meaningful data that we know it to be, like a number or a date.
There are simple ways of bulk handling text without resorting to writing a formula – copy all the names from the To: line in an Outlook email, for example: paste into a new spreadsheet and you’ll end up with a single line of text containing all of the display names and email addresses in one cell, which you may want to split up, to be of much use.
Separate the text into multiple columns by selecting the first cell, then go to the Data tab and look for Text to Columns, which presents a fairly powerful if somewhat old-fashioned looking dialog box, to step through fixing up your text.
Since we might want to create a table of names / addresses, select the cells spread across the columns, copy or cut them to the clipboard, then on a new line below, right-click and look for the Transpose option under Paste Special. Once that’s done, feel free to delete the original top row, or clear the contents of the first cell as we might come back to that row to add column names later.
There is some other cleaning up to do with this text, though; the Text-to-Columns function chopped everything at the “;” but there’s a space which follows the semicolon, so all the Display Names after the first one have a leading space. We could repeat the Text-to-Column feature on the selection again, but use a Space as delimiter now – unfortunately that would mangle the display names into multiple columns, and if we had a smattering of users with middle names or 3 or 4 part names common in many countries, it could make things look even worse.
Using the leading “<” of the email address as the delimiter is probably simplest, as it will separate the name(s) and email addresses out, though it does still give us a few tidying-up challenges, as there are spaces we don’t want and a trailing “>” at the end of every email address.
In cases like this, it’s easier to use a formula to clean things up – the Trim function being a good place to start; it removes both trailing and leading spaces in string, so the name can be fixed up into a new column.
Since we know the email address has one errant character – that trailing “>” – left behind from the earlier text-to-column operation, there are a variety of ways to strip it off. There’s the =LEFT() function, which keeps the left-most (n) characters of a string – so by combing the LEN function and knocking off a single character, we can chop the final character off.
After all this palaver, you might be thinking that some of this chopping around and formulaic string-handling can get a bit confusing as you start to nest operations within each other. Luckily, the Excel team has released some powerful new text-handling functions to try to simplify things a little:
So, using TEXTSPLIT on our original pasted text from the email, using “<” as the delimiter for the columns and “>; “ as the marker for the end of each row, gives us a near perfect solution – the only clanger being the trailing “>” on the last address.
You could use another formula to find and strip out any left-over characters like that, or just manually delete the last “>” off the original line you pasted in.
Ever since Microsoft switched the Edge browser from its own page rendering technology to instead use the open-source Chromium, it benefits from regular rolling updates and the version number keeps increasing to match. If you use Edge already, you can see what release you have by going to the “…” menu > Help and Feedback > About Microsoft Edge or paste edge://settings/help into the address bar.
The release number ticked over from 99 to 100 recently, causing a few legacy websites to fall over: when you visit any site, your browser’s User Agent String identifies to the web server what type of client it’s dealing with, including the version number (so the server can modify the page to suit the client, if necessary).
In Shades of Y2K, a few sites balked at a browser showing up with a 3-digit number – if you have problems with any, you could make Edge stick to telling sites it’s running v99 – go to edge://flags/#force-major-version-to-minor on the address bar. Mozilla – creators of the Firefox browser which also uses Chromium – tracked known issues in sites and which ones have been fixed.
As well as taking whatever goodies come from the evolution of Chromium, the Edge development team can devote more of their time building stuff with a view to making Edge better than other browsers.
One feature which made it into Edge a while back is sleeping tabs; meaning open tabs you haven’t used it for a while can be put into an inactive mode and consume less memory, CPU and ultimately, power.
Look in Task Manager (CTRL+SHIFT+ESC) and you’ll likely see lots of entries underneath the Edge application; some are processes in support of the overall app, Extensions and the like, but you’ll also see each Tab appear separately. If you think Edge is running amok, it’s worth looking here to see if some specific site is chewing up CPU and consuming lots of memory.
Tab sleeping has been updated and given extra capabilities to manage tabs which are inter-connected, reckoned to mean that 8% more tabs will be put to sleep. When a tab is dozing, it typically saves 99% of CPU and 85% of memory compared to when running.
Other updates which came into v100 include some changes to handling of PDF files and some tweaks to policy-based control and other improvements to the way the browser works.
The Performance view on sleeping tabs Is rolling out now; if you don’t see it in Settings, then sit tight, or try visiting the Edge Insiders site and install one of the test versions, either Canary (daily updates – not really recommended for the average user), Dev or Beta; pre-release and stable versions of the browser can be run side-by-side so there’s low risk in having both on your machine.
For more information on browser evollution, keep an eye on the release notes for the Beta channel and watch the release schedule for when to expect further browser updates. There’s a feature tracker too, to see what’s in development and learn what’s coming, and summary news is regularly shared via the What’s New blog.
Memoirs and autobiographies are the top selling non-fiction books for good reason, as people like to recall past events through the words and thoughts of someone who was there, in the room or even in the driving seat. World leaders who write their tell-all book on what happened 20+ years ago, better have great memories or perhaps a trove of notes and diary entries from the time. If they are fans of journaling, they would have of-the-moment musings, written down to help clear their minds at the time – on committing thoughts to her diary, Anne Frank wrote, “I can shake off everything as I write; my sorrows disappear, my courage is reborn.”
Turning to technology and looking back to relatively near-term history brings up all kinds of product that was ahead of its time or was ultimately overtaken by other developments that nobody saw coming. Sometimes, the perfect blend of genius, timing, execution and luck combines and creates a durable and wildly successful category – like the Smartphone and the plethora of services and apps that were created.
Inversely, one of those tech innovations that was just a bit ahead of its time was the Tablet PC; a fully-functional Windows PC that was blessed with a pen and touch screen so you could take notes by hand just like on paper, yet by flipping it around it could be used to run Office apps and all the other stuff you’d need a PC for, 20 years ago.
In hindsight, the idea of the Tablet PC was 10-15 years ahead of the technology that was needed to really make it work – the pen and screen digitizer were a bit too low-res; the processing power and memory was not up to the mark of providing the kind of user experience that the vision hoped for. The battery life was too poor while the whole thing was too heavy. Nowadays, with devices like the Surface Go and the iPad Pro, the reality is much closer – even if the dream of writing meeting notes by hand has been made somewhat obsolete by transcription and the fact that fewer people use a pen to write any more.
One new app that was built for the Tablet PC to take advantage of its pen, was Windows Journal, a relatively simple yet effective note-taking app, with surprisingly good handwriting recognition built in.
To read more from someone who was in the room – figuratively and, at times, literally – around the time of Tablet PC, the Journal software and the Office app originally called Scribbler which went on to become OneNote, check out Steven Sinofsky’s Hardcore Software post. It’s a fairly long but fascinating read.
Using pen and paper for taking meeting notes might be less popular now, but many of us will still jot down reminders or lists on Post-it notes, perhaps doodling on paper to help creativity and flow. If you have a pen-capable computer now, the newly released Microsoft Journal app is worth a look.
Billed as an app for digital ink enthusiasts, this new Journal presents a modern take on the original Windows Journal idea – an infinitely scrollable canvas for jotting down anything, though with AI capabilities in the app providing quiet yet powerful functionality. Journal started as a research project (from the “Garage”), but has now graduated into a fully-fledged, supported app. Read more about it here.
|Even after 2 years of mostly enforced remote meetings, it’s still amazing how many people have yet to master some of the basics of online meetings – like management of the mute button and general audio interference, positioning of screen/camera so you’re not looking up their nose or side of their face, professing to having bandwidth issues as the reason for not enabling video, and many more. One “room for improvement” function is that of presenting PowerPoint slides and not looking like an idiot.
Firstly, have a practice with Teams if you’re not sure how things are going to work out – just go to the Calendar tile and you’ll see a Meet now option in the top right; that creates a new instant meeting in which you can play.
Don’t share your screen to present slides in PowerPoint (unless you really insist). Instead, save your PowerPoint to OneDrive for Business or SharePoint, and you’ll see a Present in Teams button in the top right, or a larger button on the Slide Show tab.
Choosing this opens up a Presenter View akin to the one in PowerPoint, which is the default if you have multiple monitors and you start a Slide Show. This view lets you see Speaker Notes, jump quickly to specific slides rather than paging through them, and be more interactive with the meeting than you could ever be if you were simply sharing a screen showing a PowerPoint slide on your computer.
Perhaps the most useful aspect of this mode in Teams is that you can still show the Chat or People pane to the side of the window – allowing you to keep an eye on attendees who might have their hands raised, or who ask questions in the meeting chat.
There are some other controls of note – the eye icon lets you decide if attendees can flick through your slides or whether you want to lock them to seeing only the slide you’re currently presenting. Useful if you have a Big Reveal coming at the end.
Next to that icon, there are some others which define the presenter mode – Content Only on the left, shows just the slide you want. Next to that is Standout, which takes your video and overlays it onto the slide rather than having it appear as one of the surrounding gallery of other attendees. And next to that is a new preview PowerPoint feature called Cameo, which integrates with the Teams Client.
A downside of the Standout mode is that you don’t get to control where your image goes on screen, or how big it is – so you might well obliterate some part of the content you’re presenting. This new feature gives you a way to solve that.
In PowerPoint, go to the Insert tab and on each slide add a Cameo (or a Camera as the object it creates is described in some controls), then place and size it as you want.
If you select the new object, the Camera tab will give you more customization options.
You will need to add a Cameo to every slide you want to show up on – potentially useful if you want to only appear for intros and Q&A but perhaps leave the content on its own for other parts.
Since each slide has its own Camera object, they can be of different shapes and you can even use the groovy Morph animation effect to transition too.
While in Presenter view, try using a “laser pointer” to temporarily show traces around something on your slide, with mouse or Surface pen to control it. There is a pen or highlighter to make more durable Ink markups, and if you double-click/tap each icon, you can set options like size, colour, adding arrow tips etc.
One downside of the Presenter View is that it shrinks the content on your own screen to the point of possibly making it difficult to read, especially if you’re showing the People or Chat pane as well – in fact, the content is only about 20% of your screen real estate.
Using Pop Out might help if you have a larger second screen connected, though chances are you’ll be using the camera on a laptop so ideally want to be looking at that display.
Since nobody really uses Speaker Notes anyway, you could try Hide presenter view, which means you’ll lose the slide thumbnails and speaker notes, but still keep the other controls. Go to the View control on the top left of the window and choose Full Screen to increase it even more.
For more details on using the new Cameo feature, see here – it is in preview which is rolling out through Office Insiders first so you may not see it right away. If you are presenting using simple app or desktop sharing rather than the PowerPoint Live model described above, there are some other options in how you appear alongside your content.
As well as launching the PowerPoint Live sharing from within PPT itself, you can choose to share recent presentations while in Teams – just scroll down past the various “share screen / app” options and you’ll see more. This topic was covered previously on ToW #576.
Many years ago, computer operating systems competed for the attentions of those who cared about such things by bundling other apps and experiences that might previously have cost extra – media players, web browsers, simple word processors and the like. After the turn of the millennium, as consumer digital video started being a thing, editing packages were added to that list and Microsoft joined the fray with its Movie Maker offering, initially included as part of the much-maligned Windows ME.
Movie Maker is sadly no longer with us, and if you find something online that purports to be Movie Maker then it very likely isn’t. Bowing out finally in 2017, Windows Live Movie Maker (because everything was Live in the days, just as everything was .NET before that) had been developed to be a freely-downloadable and pretty capable video editing package, offering simple to use features to crop and adjust video, add incidental titles, music and the like. It was replaced with some much more basic video editing capabilities in the Photos app, also appearing as “Video editor” if you search for that from the Start menu.
There must be a lot of stored up love for Movie Maker, as searching the web for it will give you hundreds of “Movie Maker alternative” downloads, many of which are even published in the Microsoft Store.
Be careful of the “Free+” labels in the store, though… it probably means that after you spend an hour figuring out the often confusing UI of whatever app you’re trying out, it’ll knobble your video by only allowing you to save the first 2 minutes, or slapping a watermark on it unless you pay extra for the not-quite-so-free version.
If you’d like a fully-featured, completely free† video editing application and are prepared to put in a bit of work to figure out how to use it, then look no further than Shotcut. It’s open source, cross platform, and has numerous extensions and addins to enable pretty much any kind of effect you may want.
† It’s in the Store, too, meaning it’s clean and keeps itself updated too but costs $10 since you no longer need to visit the ad-supported website to get updates, thus supporting the developer. Comme ci, comme ça.
Another video editor of interest which manages to do a good job of having lots of powerful features but without being bewildering to use, is Clipchamp. It, too, is in the Store, though it’s actually browser-based so you can just go to the site, sign up for a free account and start playing.
The free version is missing functions from the paid-for ones, and also only lets you export video at DVD-quality resolution of 480p. Great if you’re planning to watch your vids on a 1990s CRT television.
If you want to use the more 2010 HD-era 1080p (the max res for Clipchamp, unlike the 2020s 4K that Shotcut and every modern smartphone can support), then you need to pay extra; a not-inconsiderable $19 per month, at least. A fact not lost on Brad Sams and Paul Thurrott at First Ring Daily, who commented on the fact that Clipchamp is being included in forthcoming versions of Windows 11 as a built-in app. Maybe pricing will change in time.
Yes, Microsoft acquired Clipchamp 6 months back, and hopefully its evolution will mean that in these tough times, it becomes a little less swingeing to use it properly. Find out some more about using Clipchamp, here.
Oh, one more thing. Sign into the Clipchamp app with a Microsoft.com email address rather than a Microsoft Account, and you’ll get an activation link sent via mail. Click that and you’ll be in the high-fidelity, first-class-travelling set of Business Platinum, for free. Bonus!
Words evoke times and places for lots of people, and “Pop” certainly has plenty of associations and meanings. For some, it’s the (often cheaply-branded, sickly-sweet) fizzy drink of their youth (see also skoosh, in certain parts of the world), it might be forgettable teeny bop music or perhaps an intransitive verb used to describe how something stands out.
It’s also a familiar word used in annoying UX concepts like a pop-up in your browser, or a toast on your desktop. Applications often put out toolbars or separate content in side windows, to help users make the most of their functionality: especially handy when the user has more than one display.
In its evolution over the past couple of years of explosive user growth (270M MAU!), Microsoft Teams has started to move away from the one-window-to-rule-them-all idea of having all your chats, activities, documents etc in one place, and started offering to pop things out into their own window.
If you’re in a meeting and want to have a side channel going on with a subset of participants, just start a multi-party chat, then right-click on it within the recent chats list, or from within the chat window itself. See more here. Other Teams apps also feature the top-right pop-out icon too.
As well as offering a variety of Gallery and focus views, including the ability to place where the gallery is displayed (if at all), there’s also been an addition to hide your own camera preview, in case you find yourself distractedly checking yourself out during meetings.
You could therefore dismiss all the other sidebars – like chat, or participants list – make the gallery go away, focus on presented content in full screen and hide your own preview – all in the name of being able to see what someone else is sharing.
There is probably more popping still to come. There is a public preview for Teams – which can be enabled by your Microsoft 365 Admin, here – and that enables the early stages of some new features which are being tested. Microsoft has its own internal test programs too.
Once the preview-enabling policy has been applied by Admin, then individual users will have the option (from the … / About menu) to enrol their machine in the preview; after doing so, signing out & in again, and a “Check for updates” cycle should see them have the latest available preview version.
The holy grail for popping out in Teams meetings would be the ability to separate the content being shared so you could have that on one screen, and see a large video gallery of attendees, with chat sidebars etc on another.
In the meantime, keep an eye on what’s new in the main branch of Teams, by looking on the Teams blog.
Lists form a big part of lots of peoples’ lives – whether it’s a to-do list for productivity afficionados, shopping lists for remembering the essentials or compiling top-five lists of favourite things, just, well, because.
A while back, Microsoft released a new app for Microsoft 365 users called Lists, which was essentially a front-end to SharePoint, itself a staple of the Office 365/Microsoft 365 offering since the beginning, and providing much more functionality than simply a place to stuff documents. The original SharePoint Portal Server 2001 (codenamed “Tahoe”) is nearly old enough to buy itself a beer in its homeland, and relatively advanced logic and custom data validation & handling has been a major part of its appeal for a lot of that time.
Recently, the Lists experience was made available – in preview – for non-M365 users who could sign in with their Microsoft Account. A “lightweight” version of the app, it’s still pretty functional and pitched at individuals, families or small businesses who need to keep lists of things.
Taking a slightly different tack, the To Do application is a good way of making other sorts of lists – that could be Tasks or flagged emails as well as simple tick-lists to mark off what needs to be done. In something of an overlap with Lists, To Do can share its lists with other people – think of To Do as primarily for personal use that you might share, whereas Lists is for managing shared endeavours first and foremost.
If you’re a user of both Amazon’s Alexa services and Microsoft To Do, you might want to integrate them together; using the Tasks In The Hand skill. Once enabled and correctly configured, you can use Alexa to manage that service’s built-in To-Do and Shopping lists, and these are then synchronized to the Microsoft To Do app.
You can rename the lists which are subsequently created in To Do and which sync with Alexa, though you can’t yet manage additional ones. You could simply use the Alexa app to manage the lists rather than synching them with To Do, but setting up synch gives you more flexibility – To Do integrates with other software and services, like being able to show lists in the Microsoft Launcher app on an Android phone.
“The years go by so fast, let’s hope the next beats the last”– a sentiment that rings so true over the last couple of new year celebrations. Whether setting resolutions to do new things, read more, lose weight, be a better human etc, we all tend to reflect, even if just trying to do the same things as before but a bit better. Steve Clayton’s Friday Thing for the end of December had some great tips on things to do and try in the coming year.
If we can’t reduce volume of professional communications (be that emails, Teams messages, whatever – just look at Steve cleaning his mailbox and removing >100,000 Sent Items from a single year), then maybe we could do a better job of managing the stuff that we have to deal with. Much ink has been spilled on how to be more effective and how to get things done, but one useful time/focus management principle to revisit is sometimes known as Eisenhower’s Matrix, of which a variety of depictions exist:
The premise is that any task has separate degrees of importance and urgency; we tend to prioritize urgent and overdue things versus things that are actually important. Discipline in task management can give us the clarity to not worry about seemingly urgent yet non-important tasks, and to stay focussed on things which are important, regardless of their urgency.
Carve out 75 minutes if you can – because this stuff is important – to watch Randy Pausch’s lecture on Time Management, with the context that when it was recorded, he knew he only had weeks left to live: talk about prioritizing important vs urgent.
How you put time and focus management into practice will differ depending on your own style and what tools you want to use. For the Windows / Microsoft 365 user, there are a few quick wins to consider:
ToW has talked before about appointments and meetings in Outlook – in summary, an appointment is something you put in your diary, a meeting is one to which you invite others (or have been invited to by someone else).
Thinking of meetings you have organised, you can do a few things to make them stand out, like configuring your calendar view to show your own meetings in a different colour.
… click Conditional Formatting, add a new rule and click Condition… to set it up.
Go to the Advanced tab, click on Field and choose All Appointment Fields, then Meeting Status, then set equals Meeting organizer as the condition, set your colour, font etc choice and save it all out.
Ghost meetings – you’re organiser, nobody else shows up
How many times have you joined an online meeting that you organised, waited a few minutes and then realised that the other party/parties have actually declined but you didn’t notice? Sure, you can see in the tracking tab of a meeting, but might not check until you’ve already started the meeting and wonder why you’re on your Jack Jones.
At this time of year, it’s quite likely you’ll have regular meetings with colleagues, customers or partners, and that instance has been declined by all of the invited attendees: the only real solution is to look ahead at your calendar, check the tracking responses and delete meetings which nobody else will attend. What a palaver.
Never fear, dear reader. Here’s an Excel spreadsheet with a macro which will list all the future meetings where you are the organiser and all of the attendees have either not responded or have declined, so you can easily decide which ones to go and remove.
Download the ZIP file from the link above, save/open it on your PC and you’ll see there’s a single XLSM file within. Open that in Excel, allow changes and enable Macros so it will run, then click the Scan Calendar button to show you a list of meetings that you might be able to delete since everyone else has already bailed out. It will take a couple of minutes to run but will eventually show you a list sorted with the earliest at the top.
The Hokey Cokey / Hokey Pokey is a childhood party tradition many of us will recall, where you put something in and take it out again, or a step forward then a step back. The transition from Windows 10 to Windows 11 aims to simplify the user interface to a large extent, hiding things that some people think just get in the way, while beautifying the stuff that remains.
Power users might grind their teeth at some choices – like the context menu when you right-click on a file; it’s more spaced out (in terms of screen size) but designed to be clearer and more relevant, hiding some of the chaff that 3rd party applications might install.
It even adds some hitherto hidden features, like Copy as path, which puts the full path & name of the selected file into the clipboard, ready to be pasted into a file selection dialog, for example. Some common commands – like cut or copy – have been replaced with icons at either the top or bottom of the dialog. If you want to use the old-style menu with the full set of options, you can do that too by selecting Show more… or pressing SHIFT+F10.
You can disable the new menu if you prefer the old style – just run a single command from an elevated command prompt then use Task Manager to restart the Windows Explorer application (or reboot).
Another piece of Windows that’s had a refresh is the notification function – first appearing in Windows 8 and having redesigns with every variant of Windows since, this is an attempt to summarize alerts from multiple apps in a similar way to how smartphones do it.
Windows 10 shows a little callout in the corner of the screen with the number of notifications to read; click on that or press WindowsKey+A and you’ll see a pane slide in showing notifications on the top, and a load of Quick Actions icons below.
Windows 11 has cleaned the UI up somewhat, with notifications and Quick Actions being separated out – look for a simple bubble with a number in the corner of the screen. Clicking on that or the date/time in the system tray (or press WindowsKey+N) displays notifications.
Pressing WindowsKey+A or just clicking on one of the network / sound / battery icons on the system tray will display the Quick Settings pop up, which can be tweaked by clicking on the pen icon. You can easily remove settings you don’t use – like Battery Saver, maybe – and swap in others from a fairly short list. Perhaps that list will grow in time.
Also worth a note is that WindowsKey+W brings in widgets from the other side, showing news, weather, calendar etc.