#38: Get ahead: get a proper monitor

clip_image002

As WFH became normalised during the pandemic, a lot of people went from having access to a reasonable working environment in an office, to sitting on the sofa or camping on a kitchen table. A trend of working from a laptop in coffee shops had already been underway and got additional legitimacy when things opened up again.

For the lucky ones with space at home, the increasing trend for WF there sometimes means they have a better environment than in the office – no desk sharing, putting up with co-workers’ smelly/noisy/annoying habits, perhaps even a faster internet connection. This doubtless contributes to the reported reluctance to return to the rat-race in the office.

Make the most of your screen

One huge downside of working off a laptop is that the screen – even for the biggest ones – is small.

There’s little doubt that productivity gains can be had by having larger monitors or more of them. Carnegie Mellon Professor Randy Pausch from gave a seminal talk on time management in 2007 – prescient, since he was dying of pancreatic cancer at the time and had only months left to live (his Last Lecture is also worth watching). In that session, he advised that maximizing screen real estate is one of the best things you can do.

The simplest way to improve screen area for a home office desk is to buy a decent monitor. Find one with adjustable height (so you can be looking straight at it, not down at a laptop screen) and position the laptop in front of you, below the monitor.

clip_image004

Extend the desktop to the big screen and make that your main display (so new windows, the task bar, Start menu etc will appear there rather than on your laptop).

clip_image006

Side-to-side

It’d be even better if you can use a proper keyboard and mouse, maybe with a suitable docking station, then park the laptop to the side. Ideally you should prop it up so that its display and your monitor are similar in height – there are plenty laptops stands available, or you could even just put it on a pile of books…

clip_image008

Big screen x little screens

If you’ve had a home office setup for a while, it’s possible you’ll have one or two old monitors that won’t be worth much at resale so you could always bring them into action in a true “multi-monitor” setup (without delving into additional hardware to allow more, Windows 11 supports up to 6 displays).

clip_image010

Then again, a single large monitor might be a bit more feng shui, and there are plenty of good displays out there. A single, widescreen, curved monitor could give you the same kind of functionality as having two side-by regular widescreen ones, with less cabling and fuss.

Modern displays often have USB hubs and lots of other features such as display modes where two inputs are shown side-by-side (so you have two different PCs on display, or a PC on one side and an Xbox on the other half, or take two inputs from one PC into one physical screen – the computer would see it as two side-by-side monitors, which might have benefits when it comes to app layouts).

Managing the placement of windows is a lot easier with the groovy window snapping stuff introduced in Windows 11 (hover over the maximize icon on the top right of your window, and you’ll see options for where to snap it onto the screen… it’s more than just left/right since if you have a mahoosive screen, you’ll likely have several windows side-by-side). If you need more control, or you’re running Windows 10, try the Fancy Zones utility as part of PowerToys.

clip_image012

Dell Ultrasharp and Display Manager

Dell have long made some of the best PC monitors; particularly their more expensive Ultrasharp range. If you’re shopping for a new screen, there are various ways to save money too – they have a Dell Advantage program where you can get specific vouchers (eg Microsoft employees can get theirs by entering their work email here), and they have an Outlet store for refurbished goods.

clip_image014

If you have a Dell monitor already, there’s an app for Windows and Mac which could make your life a little better, especially if you routinely switch between inputs / PiP modes etc – the Dell Display Manager. Connect your PC and the monitor with a USB cable, and you can use the software on the PC to control how the monitor works, rather than monkeying around trying to press tiny buttons to drive the On-Screen Display menu. You can even set up shortcut keys to make it easier to dive in.

Tidy.

#37: What’s your LinkedIn SSI score?

clip_image002

Are you the kind of vainglorious blowhard who likes to tell everyone about all your latest achievements or humblebrag your gratitude for some amazing success / that latest certification? Some people think that’s what LinkedIn is for. With over one billion users, there are certainly opportunities for networking and sharing interesting content too, and not all of it leaves its reader feeling queasy.

There’s a scoring facility on LinkedIn, hitherto visible only to subscribers of the $100-1600 per month (yes) “Sales Navigator” product: SSI. Nothing to do with nature sites or social security, Social Selling Index is a score to tell you how well you stack up against your peers when it comes to four pillars of social selling.

It’s available to regular cheapskate LinkedIn free users too – check your score out on https://www.linkedin.com/sales/ssi

clip_image004

When Microsoft bought LinkedIn in 2016, the $26B price paid seemed like quite a lot, even if competitors openly moaned about it. In the last fiscal year alone, LinkedIn brought in $15B of revenue so it seems like a pretty good investment all-in. The Microsoft FY24 results are due next week so we’ll see if its inexorable growth continues (hint: it’s been adding 8-9% compared to the previous year over the last 3 quarters, so it’s seems a fair bet).

What is “Social Selling” anyway?

In short, it’s a way of identifying sales prospects and using social media to connect and interact with them. Clearly, LinkedIn thinks it’s the most likely place for this to happen, though some industries and/or demographics might find Instagram or Tik Tok to be their platform of choice.

LinkedIn claims that people who are good at social selling create more opportunities, are more likely to reach their quota, and that 78% of them will outsell their peers who don’t use social media (bad luck if you’re one of the 22% that get outperformed by old style relationship sellers). You could use the Social Selling Index to see how you stack up against those who don’t use social selling skills.

The freebie view of your SSI score doesn’t really give you any explanation as to why it is what it is, nor particularly practical tips for how to get it higher… There are plenty of articles online offering tips on how to make your SSI go up, and the somewhat dry help page for Sales Nav does give a little more info.

It’s a calculation based on 4 pillars:

Establish your brand – basically, how complete is your LinkedIn profile and how much stuff you post/share. Pepper your profile with the right buzzwords and your score might go up. Treat your LinkedIn profile like it’s your CV/resumé with at least a bit of detail of your experience, add a profile photo etc, and you should do OK.

Find the right people – how well are you growing your network with new connections? Finding new prospects and connections might be easier if you’re a Sales Navigator subscriber as the searching tools are more granular, but you can still get a long way with the built-in search and filtering tools. If you don’t want to pay for Sales Navigator, you might still find value in the less spendy LinkedIn Premium.

Engage with insights – a rating where LinkedIn looks at how you engage with other people’s content (liking, commenting) and how much you share yourself (whether it’s reposting or creating something new). Being active in LinkedIn Groups also helps.

Build relationships – supposedly “connecting and establishing trust” – though likely measured by how many interactions you have with people, like commenting on their posts or sending them messages, maybe even commenting or liking back on other people’s comments on your posts.

Normally, you’re the only one who can see your SSI, but if you get an Enterprise license for Sales Navigator, then your admin can see everything and you might be able to see how the other members of your team are doing:

clip_image006

If your company is paying for a Sales Navigator license for you, then it’s always possible you could find that maintaining a certain level of SSI as one of your compensable OKRs.

So, being consistently busy on LinkedIn is likely to make your social selling index go up, even if the things you do are not necessarily examples of good social selling… the maxim of “Empty vessels make most noise” may still apply to LinkedIners who spend all their time doing stuff of low value.

You’ll find lots of online resources explaining why Social Selling is A Good Thing, and how to do it better. There’s even a book about Social Selling on LinkedIn should you feel like some summer holiday reading by the pool.

#36: Navigating Windows by keyboard

Designer (19)Now and again, it’s useful to be able to use Windows without mouse or touch, especially should the unexpected happen. Accessibility needs aside, it’s been possible to move around and control Windows since the very early days, just by using combinations of keystrokes.

ALT+F4 is maybe the most memorable (for closing a window), apart from CTRL+ALT+DEL.

A few other window management keystrokes worthy of mention:

WindowsKey+up/down/right/left arrows – maximize the current window to fullscreen (up), back from fullscreen to previous size or minimizes it (down), and snaps the window to one side of the screen or back (left/right).

ALT+TAB / SHIFT+ALT+TAB – cycles through the current open windows (and add SHIFT to go backwards). Releasing the ALT+TAB combo then jumps to whichever window is highlighted; press CTRL+ALT+TAB to just display the open windows, let you move between them and jump to one by clicking on it or pressing ENTER.

ALT+left/right arrow – moves back and forward, as in clicking the back/forward arrow icons in a browser

WindowsKey + number – jumps to the nth application on your taskbar; if you pin an app/window to the taskbar and it stays in the same place so you could use WindowsKey+1 to jump to Explorer, Win+2 to go to the browser etc.

See more here. Many more.

Powered Up

As previous ToWs have mentioned (here, here, here etc), the collection of utilities called PowerToys is well worth installing; one of its default apps is a shortcut guide showing some key WindowsKey + nnn options. (Press WindowsKey+SHIFT+/ to display temporarily).

clip_image002

On the topic of PowerToys, one of the utilities is a special “Run” app which does a good bit more than the standard WindowsKey+R command which displays the old fashioned Run dialog;

clip_image004

PowerToys Run has a load of special characters to make special searches; enter ?? something will search the web using your default, or (optionally) put o: something searches your OneNote notebooks for that term.

Somewhat controversially, the default activation keystroke for PowerToys Run is ALT+Space, which has been a Windows shortcut to display the context menu of the current window. Pressing that combo followed by M or R would be used to move / resize (using the arrow keys) or N and X would minimize / maximize that window.

clip_image006

In a curmudgeonly article, El Reg complained that old school keyboard warriors would be most upset. The also suggest that the pre-Win95 icon for that corner of the window was a Spacebar, supposedly to illustrate that you press ALT+SPACE to open it.

clip_image008

Never fear, keyboard fans – you can simply remap the activation key to something else (like WindowsKey+Space) and the ALT+SPACE combo will continue to work like it’s 1987.

clip_image010

#35: Do you really need a VPN?

 

Before widespread internet access, companies would use modems and dial-up services so remote workers could access their internal network as normal, but connecting (slowly) over a phone line. As mobility and broadband became more pervasive, Virtual Private Networks (VPNs) provided a way of accessing data that is held within your place of work – or home, perhaps – when you’re out on the road, establishing an end-to-end secure link over the internet between you and the destination.

At the same time, many of the services we’d rely on moved fully online – like email, shared documents or even business applications, potentially hosted by a 3rd party like Salesforce, Dropbox, Workday or Microsoft. Each of those would be protected using an encrypted and authenticated SSL/TLS connection, just like any other secure website connection.

What do you still have in your home or in your business premises, which you’d need a VPN to access? For organisations with local services or apps, Microsoft has long championed an automatic VPN back to your company HQ, called DirectAccess, but that is now having the sun set on it in favour of a more modern Always On VPN. Many businesses now are all in the cloud, so have nothing internally to connect to – but even as a home user, there may be some relevance.

Securing the connection

When you link using a VPN, everything between you and the endpoint is encrypted through an established “tunnel”, and therefore invisible to the intervening points on the network.

clip_image003

The invisibility of what’s happening in the tunnel could be useful to the user, for example where there’s a policy denying access to certain websites; if you VPN (and that was allowed) then the network owner wouldn’t know what you were sending up and down the connection since it’s encrypted, and therefore might not be able to block your access.

The VPN model illustrated above has all your internet traffic going back to the VPN endpoint and then out onto the internet from there (so it looks to the website you’re accessing like you’re located wherever the VPN endpoint is). There’s generally a performance penalty in doing this since there are additional “hops” involved, and it also means that whatever you’re getting up to on the public internet will be happening through your company’s firewall or your own home router.

Some VPNs give you the option to split traffic, where it routes only certain data down the VPN tunnel, while everything else just goes out onto the internet from the hotel/airport etc network as usual. That reduces the load on the VPN endpoint and its network (since casual browsing traffic isn’t coming in and out, only stuff destined for the internal network it is attached to), and is a bit quicker for the user since they just get their public internet stuff done nearby.

Some companies – mostly VPN vendors or security consultancies, it must be said – would advise that every time you connect your laptop to a public WiFi network (as found in coffee shops, airports, hotels etc), then woe betide you if you don’t access everything through their subscription VPN service. Such services would say you should routinely connect to their endpoint (in whichever country you want) so that everything between you and their server is encrypted, and the local network provider to you has no clue what you’re doing.

NordVPN, probably the market leader for 3rd party services, pushes itself heavily through advertising and tie-ups with leading podcasts and credit card companies, etc.

Securing the connection is one thing, however there’s still the small matter of being tracked in everything you do, potentially having unwanted software downloaded, which a 3rd party VPN might not protect you from, so it’s no silver bullet.

If you don’t use a VPN and you’re accessing a shopping site or online banking, the network provider (eg the Hotel or airport) could see which URL you’re accessing, but since the first thing you’ll do in nearly every browser session is to establish a secure connection between your computer and their website, any prying networking provider would only see that you’re sending gobbledygook data back to a single address out there on the net.

clip_image005

There is a possibility of having a man-in-the-middle attack which steals your data through subterfuge, though there are numerous steps taken to prevent this. If you’re using a VPN then you’re protected, unless you’re unwittingly VPNed into the man in the middle directly, in which case, the whole game’s a bogey.

Pretending to be somewhere you’re not

Some VPN users will use them to appear that they are somewhere else – eg if you’re travelling but want to access a web service which is locked to a given region, like TV streaming services. Lots of Brits in America use VPNs to access the BBC’s iPlayer, for example. There is a “yes, I have a TV license” checkbox, but we all know how effective those kind of prompts are.

Since the traffic from the VPN device or service appears to be from whatever country it’s in, that might be used to circumvent geographic blockers. Streaming companies often have legitimate reasons to restrict access based on where you are (as opposed to just being greedy and horrible).

Since some VPNs are offering ways to not only defeat the geo-blocking, but potentially provide a way around password sharing restrictions, the arms race will continue where content providers will try to stop people using certain services and VPN services will get smarter at not being blocked.

Further reading

If you’re on the road and want to access stuff back in your home, your broadband router might even have a VPN service built in (though do take care that it’s not using out of date security standards). Another option could be to set up an endpoint with OpenVPN. If you have Synology NAS appliance (and they are very good), you can enable the OpenVPN service relatively easilysee here.

Some other things to check out:

· Should You Use a VPN? – Consumer Reports

· Do I Really Need a VPN at Home? | PCMag

· Is a VPN really worth it? | Tom’s Guide (tomsguide.com)

So, back to the original question – do you really need a VPN?

Probably not. But maybe.

You be the judge.

#34: Bringing AI to the Whiteboard

clip_image002

 

One of the joys of in-person group meetings is when someone grabs a whiteboard marker and starts laying out their still-forming thoughts to the enthralled audience, almost as popular as the person who always asks a question 2 minutes before the meeting is due to end. Thankfully, there is a digital whiteboard for use in virtual and hybrid Teams meetings, too. And like seemingly everything else, it’s getting a sprinkle of Copilot-y Goodness.

The Whiteboard app has appeared in previous ToW’s (before the Great Reset) here. As a quick summary: if you’re a Microsoft 365 subscriber, you’ll find the Whiteboard tucked under More apps in the grid on the top left on numerous sites…

clip_image004

… or available directly on https://www.microsoft365.com/apps/ or just launch it directly from https://whiteboard.office.com/. A Windows app is available in the Store, though it’s really just a wrapper for the web experience.

Whiteboard is intended as a multi-user collaboration tool, available in the browser as above, or in Teams, by using the Share button (NB: if you look under the Apps button to the left of Share, you won’t easily find this Whiteboard, but there are other “Whiteboard…” 3rd party apps which will show up: YMMV).

clip_image006

One very cool new feature is the ubiquitous Copilot option; it can help get you started on a brainstorming exercise, for example. Start by giving it an idea of what you’re trying to work on

clip_image008

… and it will come back with headings which can be quickly added as Post-it style notes clip_image010

Selecting one of them and choosing Categoris|ze …

clip_image012

… will arrange them into subject blocks.

clip_image014

And selecting any one and selecting Suggest will go a level deeper and bring up some additional points.

clip_image016

As a discussion starter, it’s brilliant. Give it a try and see what kind of inspiration you might find.

The main Whiteboard info page is here. There are some cool templates available for getting started with some pretty detailed layouts for workshops, Kanban boards etc; more info here.

RIght, now there’s only 5 mins to go, the meeting is starting to wrap up – for goodness’ sake, keep your hands down.

#32: Microsoft Designer gets everywhere

clip_image002

Assuming you haven’t woken from cryonic stasis (leaving aside all the practical difficulties of doing that) then you’ll already know of the hallucinatory ChatGPT and its image-creating sidekick, DALL-E, which will spit out a computer generated image from a text-based description of what you want.

Predictably, there are many memes on whether AI is a good thing or not, along with worries that it’s coming for your jobs/freedom/happiness etc. In many ways, it’s just another wave of technology which is certainly impactful, but its benefit will be seen by how we creatively embrace it.

clip_image003

Also doing the rounds is the trope of “I want AI to do my laundry” which is poignant if not really a new thing (see Keynes c1930, or Bertrand Russell’s “In praise of Idleness”, c1932). Technology is invented to supposedly give us more time but often displaces one form of work for another. Now, AI prompt engineering will be a creative skill, to a degree replacing the need for designing, drawing or painting skills.

Meanwhile, Microsoft has been busy embedding DALL-E technology into other apps and services, broadly packaged under its “Designer” branding. You can generate images for embedding into LinkedIn articles, for example …

clip_image005

… though with some mixed level of success, depending on what you want…

clip_image007

Alternatively, just go straight to the Copilot prompt…

clip_image009

Even the venerable Paint has gotten a new Image Creator function which does much the same thing, though annoyingly defaults to a 1:1 aspect ratio, regardless of the orientation of the canvas. In the main Copilot/Designer UI there is a little icon to change the ratio of your image from square to landscape, however it ends up generating a new image entirely.

clip_image011

Restyle it out

Remember all those early 2000s makeover TV shows which gave frumpy looking people another view on what to wear? Well, there’s a Restyle capability in Designer that’s so much fun to play with, you could easily spend the rest of the day mucking about with pictures to see what selfies look like in art style, how the dog would be if made of Plasticine, and so on…

clip_image013

Take your source image…

clip_image015

…then choose one of a variety of styles, and be prepared for outright weirdness or outright flattery…

clip_image017

Right, that’s enough of the day wasted. Get on with your work!

#31: Easy and Excel-lent Data sources

clip_image002

Most people who have spent time using Microsoft Excel will realize that it probably has more capabilities than they’ll ever understand, much less use. There are so many functions used to collate, display and interpret data that it’s no wonder people turn to using it for all sorts of things.

There have been numerous attempts to make user-friendly data tools for Excel, from web-scraping 3rd party sites to the short-lived Money in Excel for American users which bit the dust before it was barely out of diapers.

More recent releases of Excel include several Linked Data Types which can retrieve and manipulate data from “reputable sources of data, such as Bing”… (which, incidentally, had its 15th birthday recently). Companies with suitable data governance can expose internal info for analysis, or regular end users can get started with share prices, currency conversions and geographical data.

clip_image004

In the Data tab in the current versions of Excel on multiple platforms, you’ll see 3 or 4 types of data that can quickly be inserted – they will perform a lookup on external information and return a data set in the background which can be displayed and otherwise interacted with using formulae, lookups and other standard data tools in Excel.

clip_image006

Getting real-time data is pretty straightforward – create a blank table with a single column in which you’ll enter your key data items that you want to expand on – for currency conversions, it would be a pair of currency symbols (USD:EUR or GBP/USD etc) that you then select and mark as Currency from the data tab. That then lets you easily add other columns for specific lookup data, and that can be referenced itself through other formulae too.

clip_image007

Stock lookups work similarly, by entering the ticker symbol in one column and potentially going through a matching exercise to find the right one. Handy, if you have a workbook for calculating when you can stick it to the man and retire to a patch in the Tuscany hills: you can automatically look up the stock values and convert their currencies too, if required.

clip_image009

There’s some location stuff as well, invoked by entering city or area names; it’s more text-based reference info which is returned, though it might be possible to feed some of the data into a Map Chart for further visualization.

#30: Snipping Smarter

clip_image002

Wclip_image004indows’ Snipping Tool, used to capture an area of the screen, has been around for a long time in various guises, even threatened with cancellation at least once. Invoking the tool by pressing SHIFT+WindowsKey+S or just hitting the PrtScn button (if you have one) now displays a small dialog at the top of a dimmed screen.

You can choose to capture a static image (of a part of the screen, or the whole thing) or a record a video of a marked section of the screen, optionally with your own commentary – useful for sharing a quick “how to” video.

Another way of capturing the entire screen is to press WindowsKey+PrtScn, which can be useful when trying to grab menus and things that might disappear if you tried to interact with them – like the first image above, since the screen grab menu itself will disappear as soon as you click the mouse button.

As well as copying the snipped area to the clipboard, an updated Snipping Tool from about 18 months ago also saved them to a Screenshots folder, so it’s easy to go back and fish them out later. See 665 – Mind your screenshots for more details; it’s worth keeping an eye on that Screenshots folder so it doesn’t get overly large and/or contain stuff that you might not want to keep.

REDACT THE gggg TEXT

Some further updates to Snipping Tool have been happening of late; there’s some nice functionality which lets you extract text from the grabbed area to the clipboard (as paste-able text rather than an image), or to redact certain bits of the screen so as to preserve potentially confidential info.

clip_image006

The Quick redact feature tries to identify some data types, but to manually scratch it out, just select the text you want to hide, right-click and choose Redact.

clip_image008

When you’re happy, click the Copy button on the top right

clip_image010

And that will put the fully redacted version into the clipboard, either replacing what was there before or adding it to the list if you have Clipboard History turned on.

clip_image012

Another newish addition is the quick ability to feed your screen grabbed image to the Visual Search in Bing, effectively doing a reverse image lookup – just look in the menu on the top right.

clip_image014

#29: The power of CTRL

Designer (7)The familiar computer keyboard has evolved over decades, even though some languages have obstinately different layouts; Germans have QWERTZ and French users have AZERTY, while Brits used to their usual keyboard might struggle to find the backslash on an American machine, and accidentally hit Enter when looking for the hash key.

clip_image002

Most keyboards feature control keys on the bottom corners; designed as a “modifier” to be used in conjunction with other keys to activate certain commands, there are some well-known combos like CTRL+C and CTRL+V for copy and paste. There are outliers – German keyboards have Strg instead of Ctrl, and even an obsolete ISO standard says the key could be marked “”.

There are some occasions when the Control key is not just a straightforward modifier; aside from using Sticky Keys to keep it pressed, one somewhat hidden feature in the Edge browser turns Ctrl to good effect, for opening an image in a zoomable overlay window.

Many images embedded in web pages are much bigger than you might think; the source picture could be something like 2000×1500 pixels in size, but when displayed on the site, it’s reduced to 640×480. In such cases, you can use the CTRL key to magnify the original image without having to navigate away from the current page.

If the Edge window is in focus, move your mouse cursor over an image and try tapping CTRL twice; if the site can support it, you’ll see the image displayed in a pop-up window that lets you zoom in out (with the mouse scroll wheel or by stroking your laptop touchpad).

clip_image004

If you have the PowerToys addon pack installed, you may also have Find My Mouse enabled, and that too uses one of the Control keys as its activator. Happily, if a little confusingly perhaps, both can co-exist so you’ll expand the highlighted image while temporarily spotlighting where your pointer is.

clip_image006