679 – Wordlament

Posted on April 28, 2023 by ewand

Even if you weren’t taken with the viral word puzzle game Wordle, you’ve probably seen the coloured grid that people would share on social media. Sometimes bragging on how ~~lucky~~ smart they were in getting the answer in a couple of goes, or complaining that it was too hard and that they missed out.

It also gives whingeing poms a new thing to complain about on Facebook groups, every time the Wordle answer is a 5-letter American spelling like FAVOR or LITER.

If you’re still playing Wordle each morning, you might have happened across the numerous other -dle games out there, like Quordle (same idea as Wordle but you 9 goes instead of 6, but need to solve 4 squares), Octordle (like Quordle but x8), Kilordle (x1000 – it’s getting silly). Lots of other “guessing things” online games jumped on the bandwagon, too – there’s Heardle (play it while you can – it’s shutting down on 5 May), Worldle, Cardle and, missing out on the ‘-dle’ suffix, Framed. Who needs to be productive anyway?

Wasting time while keeping your brain occupied is a time-honoured tradition, with crossword puzzles featuring in newspapers for over a century. One of the best word puzzle games to appear on mobile phones, originally launching in 2012, was Wordament. Published from a skunkworks project where two guys built it in their spare time (before moving on to be part of Minecraft), it has gone through several evolutions since, and is now available as a Windows app (in the Store, here), on mobile (Googly | Fruity) and it’s also playable in a browser.

In each of these settings, you do need to suffer some pretty intrusive advertising unless you want to pay a few £ a month (or £10 a year) to make them go away.

If you want to maximise your time-wasting, you can even play Wordament – and other “Games for Work” – within a Teams meeting.

There are other fun games to play during Teams meetings, too – the familiar “Bingo” being one that could be enjoyed by only those participants “in the know”.

678 – New Old Things again

Posted on April 21, 2023 by ewand

In ToW 632 – New Old Things, the topic of the old version of OneNote getting some spiffy new features was raised. This week carries on the same theme in a different direction – some altogether new versions of old applications, which might be worth taking a look at, even if they’re not quite fully featured yet.

In the beginning there was Skype. Well, actually, before that there was MSN Messenger and its variants. Business environments then got Live Communications Server, Office Communications Server, eventually Lync, and finally the confusingly branded Skype for Business.

Teams came along from the left field around 6 years ago and from a real-time collaboration product point of view, swept all before it (at least in Microsoft), eventually replacing Skype for Business, as the pandemic turbocharged its adoption and appeal. Skype is still with us, with reasonably recent releases and even integration of the new Bing and GPT driven AI.

The thing is, the original Teams client grew up pretty quickly and though it has had lots of improvements, it’s never been especially resource-light, or quick. The Teams team (herein lies one challenge with its name) took the decision to start over and build a new Teams client, shiny and slick and running like greased lightning.

If you feel like giving it a try, you may see a Try new Teams slider on the top left of the main Teams client window; clicking that will restart Teams by closing the old app and starting the new. There are some features not quite there yet, but the list is being updated frequently as functionality improves. If you switch to the new Teams preview and don’t like it, you can quickly switch back – but you’re either/or running one or the other.

Outlook has a longer heritage – it came out first with Office 97 so has its roots in early/mid-90s code, and even if the core of the app has been re-engineered and the UX has had numerous polishes over the years, there are still occasional peeks at a Windows 95 era application lurking beneath.

There has been a push for some time to make the Outlook Web client a more viable alternative for many users, including showing Outlook Web in an Edge sidebar even when clicking a link from the PC desktop client. Functionality differs between the full-fat desktop, the web client and the various mobile apps.

There’s a “new Outlook” on the way, now too – previously codenamed “project Monarch” it’s supposedly been in the works for years, yet looks a lot like the web client that happens to run in a window – it’s available in preview now. It may end up replacing the variety of desktop, web and mobile apps, though that could take a while. In near terms, the new Outlook will likely supplant the default Mail & Calendar apps in Windows 11.

You may see a Try the new Outlook slider on the top right of the main Outlook window; flicking that will restart Outlook in its new guise, however unlike the new Teams, it is possible to run both new and old, side-by-side.

One way would be to make the switch, then on the new “Outlook PRE” icon that appears on the taskbar, choose to Pin it. Then flick back and you’ll now have both old and new Outlooks available together. You could configure the New one to remove your main M365 email account, and just have your Outlook.com / Hotmail or now even a Gmail account, while leaving all your work emails in the old Outlook UX.

If you want to keep old and new Outlook with different account setups – business in the old, private in the new, for example – go straight to the Store and install the New Outlook app, then configure it as you like when it starts.

677 – LinkedIn’s Blue Tick

Posted on April 14, 2023 by ewand

The world’s fascination with what’s happening at Twitter and its charismatic leader (but not necessarily its CEO?) appears to remain high. One headline making topic was what to do with the “verified” blue tick service, previously offered to high-profile individuals but now turned into a monetization strategy. The full hour-long BBC interview with Elon is certainly worth watching.

In related but somewhat less controversial news, LinkedIn has just launched a verification feature which lets a user validate that they are who they say they are, and best of all, it’s free.

There’s no obvious verification badge akin to the blue tick quite yet, though you may see some other info about people when you see their profile picture – a green blob means they’re online, a green hollowed-out blob means they’re not active but they will see messages on their phone. If you don’t like to show the green blob/circle, you can always switch it off, so no visible blob means someone else is either offline completely or just going incognito.

Verification is rolling out gradually but will eventually be available to everyone, either by validating their corporate email address, by using the Microsoft Entra verification service (if your company subscribes to Azure Active Directory, that will be an option soon), or by validating your ID using the CLEAR program favoured by smug airport travellers.

Work email verification is probably the easiest for most people to use – sign in to LinkedIn.com and click the Me option on the toolbar at the top right and then View Profile to look at your own profile page. Now, click the More button and select About this profile – that will show you what verification options are open to you. Email verification just means entering your company email address, then clicking the link that is emailed to you. Once that’s done, return to the About this profile section and you’ll see that your account has been verified.

Visitors to your profile page wil see a prominent banner showing that you have been verified, and giving some details of how (without giving away the actual email address or details of Government ID etc). The Show verifications option gives some info about the means and timing of the verification.

LinkedIn says it might change the way verification is displayed on your profile, in due course; maybe the plan is to make it more visible in search results too. Time will tell.

676 – Calendar spring cleaning

Posted on April 7, 2023 by ewand

As spring continues to emerge from its wintry slumber in the northern hemisphere, it could be worth spending a little time tidying up your Outlook calendar as well as spring cleaning your nest. The following applies to Outlook on the PC, though similar colour-coding concepts exist for Outlook Web App and on other platforms.

You could start by looking for “Ghost meetings” – those are ones where you’re the organizer, but none of the invited attendees have accepted your invitation. A good example is a 1:1 meeting when the other party is on holiday – they might have declined a meeting but you left it in your calendar.

To quickly view Ghost (or maybe Zombie?) meetings in your calendar:

Download this ZIP file and open the downloads folder where it is saved.
Right-click the ZIP and choose Extract All then right-click the resulting file and Unblock it, so Excel will let you run the macro within (don’t worry, it’s perfectly safe).
Now open the file in Excel. If asked, tell it you want to edit the file and allow macros to run, then hit the Scan Calendar button. You’ll now get a list of meetings to go and delete, or possibly to nag the invitees to respond.

Another trick is to colour-code your appointments, either by setting categories on them individually or by using rules. This way you could quickly differentiate an appointment (ie something you put in your calendar to block out time) from a meeting (ie an appointment which you invited others, or to which you have been invited).

Setting a colour category is a quick exercise once you have the categories defined – right-click on an entry in the calendar to pick a category, or you can set it from Categorize option on the Ribbon while creating or editing an appointment or meeting.

Rules are set by creating instructions that apply to the view you’re using; go to the View menu on the ribbon and choose the View Settings menu item.

This presents a somewhat old-fashioned looking dialog box which lets you change the view, including using Conditional Formatting, where you define rules that will mean the select colour applies.

In “My Meetings”, if your name is the organizer, then the meeting shows as green.

Explore the conditions dialog a little and you’ll see all kinds of things you can filter by. It includes a powerful advanced mode that will let you set a condition on any property of the meeting or appointment (so you could have different colours for meetings whose locations were in different buildings etc).

The “External meetings” condition above does require further hoops to be jumped through to get it set up, but it’s a one-and-done exercise. It involves adding a custom form to Outlook, which in turn exposes a new property called “Sender Address Type” – if the value is SMTP, that means the message – or calendar meeting request in this case – came from outside, so you’ve been invited to a meeting organized by a 3^rd party. The same field could be used to colour code your inbox so as to prioritize emails differently too.

To see how you could use the Sender Address Type to alter how your inbox is displayed, and for the instructions on how to install the form so that field becomes visible to Outlook, crank up the time machine and head back to Tip o’ the Week #275 – Prioritising External Email – Ewan Dalton’s Tip o’ the Week (tipoweek.com). Great Scot!

675 – Does size matter?

Posted on March 31, 2023 by ewand

When disk size was measured in Megabytes and network bandwidth even less, size of files really mattered. When non-floppy floppy disks were sized in 1.something MB, IOMega Zip drives promised 100x as much storage for only a few times the outlay.

The dramatic growth in capacity and drop in cost of storage has radically outpaced Moore’s law, where a gigabyte of disk storage might have cost $100 in 1997 and only $10 by the year 2000. Nowadays, if you bought your gigs on a spinny platter, they’d cost you less than $0.01 each. For most end users, solid state storage has largely replaced the traditional hard disk and even with 10x performance, the price is still only a few cents per GB.

That said, storing data in the cloud costs money over the long term, and has a potentially negative environmental impact – a Stanford report from a few years ago estimated that saving and storing 100GB in the cloud for a year costs the equivalent of 0.2 tonnes of CO₂, or about the same as a one-way flight from Seattle to San Francisco. So reducing unnecessary cloud storage can be worthwhile.

If you’re writing an email in Outlook, you can see the current size from the File | Info menu.

In Word, Excel and PowerPoint, you can see the document size and other useful info in the same place (varying details depending on which application).

A previous Tip dealt with the scourge of bloating PowerPoint files, where it’s not uncommon to have unnecessary large images lurking within the template you’re using, but there’s a simple trick that’s common across all Office apps – compressing picture size.

Especially if you’re embedding photos from a phone or even screen-grabs from a high-res display, individual files can be in the multi-megabyte* category. In many cases, you might resize your image so doesn’t take up such a huge part of your document, but the app will still be storing the full resolution of the image – including any bits you’ve cropped out – behind the scenes.

To compress pictures in your document – and let’s use PowerPoint as an example given that it’s the chief culprit – simply select an image and in the Picture Format menu which appears, choose the Compress Pictures option.

This will let you determine the level of detail to keep for this image – if it’s a simple presentation, then it probably doesn’t need a very high definition picture. You also select whether to keep or discard any cropped areas, and importantly, whether to apply to just this one or by clearing the top option, applying to all images in the file.

Try taking any large PowerPoint file, delete cropped areas and apply Web or Print resolution to all images, and you might see it drop to 10% of its previous size.

The Compress Pictures option is also available from the folder picker in the old File | Save As dialog, and there are other options to change the default resolution available from within the File | Options menu.

*Remember kiddos, there are 1000 MB in one GB; smart alecs might believe that a kilobyte would be 2¹⁰ bytes – 1024 – but for 25 years international standards have defined that as a kibibyte or KiB, trying to assert with less ambiguity that a kilobyte is actually 1000 bytes, therefore a Gigabyte is 1,000 x 1,000 x 1,000 = 1,000,000,000 bytes, whereas a Gibibyte – srsly – is 1,024³,or 1,073,741,824 bytes).

674 – Here’s the (co)pilot

Posted on March 24, 2023 by ewand

UK telly viewers in the early noughties may recall the surreal comedy show, Trigger Happy TV, with recurring characters like the aggressive squirrels or the guy with the massive phone (and that Nokia ring tone).

It was also known for some great soundtracks, like the fantastically titled Grandaddy song “He’s Simple, He’s Dumb, He’s the Pilot” (also used elsewhere). Tech news over recent weeks tells us that the pilot – or Copilot – is anything but dumb, even if it can be simple.

For Microsoft watchers, “Copilot” is a growing set of capabilities which are being built to add OpenAI functionality to other applications. With all the hoo-hah about ChatGPT and the generative AI that is now integrated into Bing (and available for everyone who wants it, not just early adopters), it’s easy to get different strands mixed up.

GPT-3 and now GPT-4 are the core language models which could underpin any number of applications’ use of what looks like artificial intelligence. ChatGPT is one web app built to hone some of the parameters of GPT-3 and put a chatbot front end to it. The new Bing and all the other stuff announced over the last few weeks is not using ChatGPT, but they do share some of the same technology underneath. Capisce?

There have been AI features aimed at making developers’ lives easier, such as Github Copilot (available since 2021), which uses another OpenAI tool called Codex, itself built to harness GPT-3. For developers on Power Platform, there have been AI functions for years too, though some capability has been recently added.

Everyday users of Dynamics 365 and Office applications will soon get Copilot capabilities to help automate boring tasks, like “work”. Do bear in mind that announcing something and making something available – in limited preview form or generally – are different activities. Copilot for Office apps like Outlook might be a few weeks or months away for most of us, but who can’t wait for AI to automatically read and reply to all their emails?

The future with our robot overlords never looked so appealing.

For a growing summary of Copilot announcements, see the hugely popular LinkedIn post from Jack Rowbotham.

673 – Where is my mouse?

Posted on March 17, 2023 (Updated March 17, 2023) by ewand

The “mouse” was invented 60 years ago, as a means of moving a cursor around on-screen. Through many generations of hardware, it evolved from using wheels to rubbery balls, before eventually going sensor-based and even losing the tail that may have helped coin its original name

Since many people now use laptops with touchpads, they won’t even use an external meecely peripheral but the term “mouse” is still often used to refer to the pointer that it controls. Finding that pointer on your desktop can sometimes be a challenge, especially if you have multiple screens on your computer, and particularly if at least one of them is a snazzy ultrawide job.

The free PowerToys addons to Windows 11 includes a section of Mouse utilities; install the full PowerToys suite and you can usually enable each feature individually, and set what mechanism you’d use to invoke it. Perhaps the most useful is the “Find my Mouse” keyboard shortcut – just press the CTRL key twice in quick succession, and the screen dims with a spotlight on where your pointer currently is. Press CTRL once again to remove it and go back to normal.

There are loads of settings to tweak how some of the utilities work – Find my Mouse could be enabled by shaking your mouse if you’d prefer. There’s also a highlighter feature that indicates if you’re pressing a left or right mouse button, or a crosshair view which, when turned on, sets a permanent crosshair display (again, configurable in numerous ways) that remains in place until you repeat the key combo to switch it off.

Mice can jump high – who knew?

A new mousey feature in the latest release of PowerToys is called Mouse Jump – erstwhile known as FancyMouse – and lets you teleport your mouse pointer from one side of a potentially massive desktop to another.

This is particularly handy if you have multiple screens set at different heights, and in order to traverse from one side of the desktop to the other would take you multiple swipes of a physical mouse or strokes of a touchpad.

Press the activation key and you’ll see a shrunken version of the desktop in a small window; click where you want the pointer to vamoose to on that depiction of the display and it will teleport to the other side of the desktop.

672 – Why your meetings are clashing

Posted on March 10, 2023 (Updated March 10, 2023) by ewand

Look at your work calendar for the next two weeks or so; if you’re a part of a multi-national organization that routinely has meetings with people all over the world, your nicely ordered diary might be a maelstrom of overlapping and clashing appointments. Welcome to the start of the 6-monthly Daylight Saving Time Shuffle! Of course, you might have clashing for other reasons.

Meetings in Outlook – apparently, other PIMs are available – are created in the time zone of the organizer. If you’re in London and have set up a weekly 4pm meeting, most of the time that’s at 8am for the people in San Francisco, but for the next 2 weeks it’d be 9am and therefore possibly conflicting with whatever else they had planned for then.

The topic of time and its zones has been covered ad nauseam on ToW passim, but it’s worth a quick reminder of what is ahead (and other countries / regions still do vary – see a summary of the global daylight saving time dates and regions, here), especially since the US has a habit of doing things differently to the rest of the world:

12 March 2023 – Most of the US, Canada, Carribean enters DST (if observed)
24-26 March – most of the rest of the Northern Hemisphere enters DST (if observed)
2 April – Australia, New Zealand leaves DST

Practically, that means that today, a noon meeting in Seattle would be 8pm in London and 7am (tomorrow) in Sydney, but in a little over 3 weeks that would have moved to noon/7pm/6am and eventually settled back at noon SEA and 8pm LON, but now at a refreshing 5am SYD.

Fortunately, the Clock app on Windows 11 has a “Word Clock” feature that lets you pin cities to the map and you’ll see what the current time is (and what the time zone offset is currently). You can also get a tabular view of what the relative time will be at any given date.

Windows Clock app

671 – Excel-lent

Posted on March 3, 2023 by ewand

Even old dogs like Excel have some new tricks up their sleeves. The spreadsheet application category was defined by VisiCalc in the late 1970s, and was a driving force behind the success of personal computers; accountants and finance managers and the like could quickly do their own sums instead of waiting for a report from the Data Processing department which fed and watered the big iron. When the PC came out, Lotus 1-2-3 was king of the hill and Microsoft’s Multiplan was an also-ran, until Windows arrived and the new Excel program moved from underdog to top enchilada.

First off, if you’re going to use Excel to create a table of some sort, start by Formatting as Table. It makes it so much easier to manage the data later – sorting, filtering, formatting are straightforward.

If you choose that your table has headers, the name of the top row will also be marked with an arrow to filter the list, and also appears in any formulae you might develop.

Rather than referencing cells in a formula by A2 etc, you could put the cursor onto the field you want to reference, and the name of the column will be used, and when you enter that formula, it can be easily copied to every row.

Excel has other smarts, though – let’s forget about formulae in this case, and just type the First name in column B; dragging the bottom right corner of that cell all the way to the bottom of the table, will fill every cell with “Mary” but a little Auto-Fill Settings prompt will appear at the bottom. Click that and you can change it to Flash Fill.

Et voila! Excel has figured out the relationship between the text and applied the same pattern to all the other rows in the table. Repeat the exercise in this case by filling Green in the Last name and MG in initials. A quicker way of applying auto-fill is to put the cursor in column C and press CTRL-E, then repeat on column D.

If you find yourself working with tables and the columns aren’t wide enough to show the data fully, you can quickly widen one column by double-clicking on the bar to the side of the column heading; select several colums at the same time and double-click on one of the width adjustors and they’ll all be resized to fit. The same trick works on rows, by double-clicking on the height adjustor on the far left of the row.

If you want to select all the table, put the cursor in the very top left corner of cell A1 and you should see it change shape to a diagonal pointing arrow; click once to select the whole table. Another way would be to put your cursor in the table and press CTRL-A; that selects the entire data portion. Press CTRL-A again if you want to include the header row too.

If you have the table selected, press ALT and release it – you’ll see a load of letters appear over the menus, which jump to specific functions. Press and release H to go to the Home tab, then O to jump to the Format menu, then I for auto-width or A for auto-height.

The final magic Excel trick for today is autocomplete.

If you start typing a text value in a cell, Excel might look at others in the rows above and offer you an autocomplete option – just press tab or downarrow and it will fill in that value for you. Another option is to press ALT and and down arrow ↓ when you first enter or select the cell; it will show a drop-down list of all the previous values, and you can either use mouse or up/down/enter keys to select the one you want. Excellent!

670 – Clipboard history

Posted on February 24, 2023 (Updated February 24, 2023) by ewand

Some tips deserve multiple bites^*especially when the recipe changes between software versions. This one harks back to ToWs #457 and #482, yet it’s still seemingly little known. If you ever have to watch someone share their desktop on Teams and fuss about when copying and pasting stuff, this could be a useful tip to share with them.

*ToW readers will probably know there are 8 bits in a byte; did you know that half a byte is called a nibble?
There is no accepted name for 2-bits, though Bing AI suggested it might be a “crumb”.

The metaphor of cutting and pasting has been around since the early days of interactive computing, taking inspiration from the way that printed publications would be edited together by physically cutting parts of one page and gluing/pasting them onto another. They might have been kept on a physical clipboard between the snip and the stick.

The Windows clipboard is common across all applications, and has an opt-in feature to keep a history so you can go back to something you copied previously; turn on the history or interact with your previous clips by pressing WindowsKey+V. See more on using Clipboard history. You can also sync the clipboard across multiple devices too.

The same UI for clipboard history can also be used to insert special characters, emoticons and the like, into any application – in fact, pressing WindowsKey+. (that’s a full stop or period) brings up the smiley-picker, which is just another one of the tabs on the same dialogue as clipboard.

You can pin clipped items if you like, and pressing the ellipsis … gives the option of removing an item, or pasting it as text – handy if you’d like to paste a URL rather than a smart link that results in the title of a web page with hyperlink behind it.