#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

#28: Recalling history

tl;dr – press WindowsKey+V on your Windows 10 or 11 PC. If you don’t have Clipboard history turned on, enable it. You’re welcome.

Microsoft unveiled a new range of Surface laptops recently; the foghorn headline is they’re not just PCs, they’re Copilot+ PCs with lots of AI goodness. There was also a lot of news from the Microsoft Build conference this week – Copilot might have mentioned once or twice, but I think they got away with it.

clip_image002

The really big news for PC watchers is concerning the most recent attempt by Microsoft to move away from Intel to ARM processors; tried before with the Windows RT and Surface RT cul-de-sac, then later the Windows 10X project and the Surface Pro X which was ultimately superseded by an Intel-powered replacement.

clip_image004

Apple showed that it was not only possible but desirable to move from power-hungry Intel to lightning fast ARM chips, delivering huge improvements in battery life at minimal expense of application compatibility. The new Surface Laptop 7 purports to deliver power and performance that will finally take the fight to Apple in-house ARM silicon.

As well as flashing the new hardware, Microsoft also announced a bunch of new capabilities coming to Windows, delivered by snazzy new hardware and the Copilot Runtime which will allow advanced AI computation to take place locally on the device, without having to round-trip to the cloud.

One such AI-powered feature is “Recall”, which captures what the user is doing on the PC over time and will use a local AI model to analyse the data, so you can ask it to bring back whichever document, web page or app you might have been using when you were doing or thinking about something.

So far, the use cases being discussed are a little basic (like “I saw a recipe for a goat’s cheese pizza but can’t remember where it was”) but it could prove really useful when in the wild.

clip_image006

Remembering history

There are plenty of other places where history is recorded as you do your thang on a PC. Office apps remember documents you’ve been using in the past either by presenting the Most-Recently Used (MRU) list or letting you search across common document areas.

clip_image008

Outlook will cache the email addresses you’ve sent to before, browsers like Edge have an extensive and searchable history of pages you’ve been to, and even Windows Explorer’s Home tab shows you all the documents you’ve opened recently alongside ones you might have pinned as favourites.

One history feature which is presumably switched off by default due to some sort of privacy worry, is one where when you start using it, you wonder how you’ve lived your life to date without it: Clipboard history. In a nutshell, CTRL+C and CTRL+V have been widely-used shortcut keys for copy & paste since before Windows was an apple in its creators’ eyes. Using WindowsKey+V to initiate a Paste, will present you a list of the last few things you put on the clipboard.

clip_image010

It was covered in Old Testament ToW #670.

Remember Windows Timeline? It was a feature which recorded what the user was doing across many apps, browser sessions and different devices (even on mobile), synched to the cloud and presented in a logical, searchable timeline view. While it still exists in Windows 10, it wasn’t part of Windows 11 and since it relied on Cortana (RIP), the feature which remains has very much had its wings clipped.

“Recall” Chicken Licken

The old fairy tale of the chicken thinking the sky is falling (originally an Indian story about a hare, not a hen, and known by a variety of names around the world) was revisited in relation to Microsoft’s “Recall” feature which is part of this new range of Copilot+ PCs, enabled by the additional NPU chips (and not to be confused the Outlook’s “Recall” feature which purports to un-send a message but rarely works as expected, especially if sending to a lot of people).

The story behind the new Recall is that the PC will keep a history of everything the user does by screen-grabbing every few seconds, so that the user can later ask Copilot for help in remembering what they’ve done previously.

clip_image012

Cue, heavy breathing from all sorts of commentators who’ve never even laid eyes on this thing being used. The UK’s Information Commissioner’s Office – the Gov data watchdogissued a short statement and was widely reported as “looking into” the potential privacy concerns, however Microsoft was clear to point out that:

  • Recall will (initially) only work on these new (ARM) Copilot+ PCs and is in preview. Other PCs with Intel CPUs and Neural Processing Units (NPU) hardware will get the feature in time.
  • Recall will be enabled on initial PC or user setup, but can be switched off using the Settings menu and sys admins can centrally disable through policy; ditto, the length of time Recall will store data for can be tuned (and the amount of storage it uses).
  • Specific apps (and InPrivate browser windows) can be excluded from the screen-grabbery
  • It holds all the data in an encrypted store on the local PC and is only accessible by the user (i.e. not synced to the cloud, not readable by Microsoft or by any company administrator).