Category: Apps

#72: Sending pages from your pocket

Posted on (Updated by ewand

Browsing on mobile devices is the main way people use the web. As mentioned in ToW #62, the last decade has seen a complete shift from PC & Mac being used for nearly 70% of web traffic to the dominant platforms being Android and iOS.

One nuance the stats don’t take into account, though, is that most of the 30% who’re still on Windows & OS X will also be browsing on whatever phone they have. It’s not uncommon to see people sitting in front of a desktop or laptop, while using their phone for other things – be that reading stuff in a mobile web browser or using a dedicated app.

Sharing is Caring

One feature common to all the main mobile browsers and their desktop equivalents is the ability to send pages (or tabs) from one to the other, assuming you’re signed in on both using the same account. While the meedja appears to work on the assumption that everyone+dog has an iPhone, around 2/3 of mobile browsing is done with Google Chrome and variants, and over 70% of the browsing devices are running Android.

For those reasons, we’re going to use Android and Windows as the use case for this week’s tip, but the same things can also be done on Mac + iOS. Probably.

Mobile apps -> desktop

If you’re sitting on the sofa flicking through stuff, there will be times where it’s easier to look at the content on a bigger screen. Sure, you might be able mirror the device on the big TV, but who ever does that?

Let’s say you’re browsing an eBay listing and want to send it to your laptop so you can see the pictures better. One option is to try using Google’s Quick Share to send something straight from a phone app to the PC, once you’ve set up the software and signed in.  Mac users need to jump through some additional non-official hoops.

Quick Share is the new name for “Nearby Share” –  start by clicking the sharing icon on the top of the eBay app (or from whatever app you’re looking to share something).

Article content

How the app behaves will differ from one to another; in the case of the eBay app, it will offer to send a link to this listing to some other app on the device, including the ability to share it elsewhere.

Article content

The list of apps (and contacts) will vary depending on usage. If you have Microsoft’s Phone Link already set up between your phone and PC, you can just fire it to your PC using the Send to PC command, and it will open a new browser page right away. If using Quick Share, you’ll get a prompt to open it.

Mobile browser -> desktop

Another more general and consistent use case is when you’re on the phone using a web browser rather than an app. Clicking the Share icon in Chrome will let you copy the link to the phone’s clipboard or send it to a variety of other contacts or apps (just as in the previous eBay app example), or “Send to devices”: in this case, any other device where you’re also logged in to Chrome with the same Google ID. You could also screen grab the page or generate a QR code, so if you want to share the link with someone nearby, you can do that more easily than faffing about with Bluetooth.

Article content

After tapping this option and choosing the relevant PC, you’ll see a notification show up in Chrome.

Article content

You’ll also see “Your devices” if you expand Chrome’s History either in the menu or by pressing CTRL+H…

Article content

From Edge to Edge

Some small proportion of Microsoft fans might be running the mobile Edge browser on their Android or even iOS phones. It’s a surprisingly good mobile browsing experience with built-in ad blocker, password saving integration with Microsoft Authenticator and an inevitable smatter of Copilotry.

Edge Mobile was built on the Chromium browser engine and released a year before the main desktop Edge was ported to Chromium too. As a result, many features in Google Chrome are also carried over (since it, unsurprisingly, is also based on Chromium), except that you’d be running Edge on your mobile device and signing into Edge on your PC or Mac using a Microsoft Account.

Similar to how Chrome does it, Edge will also let you send links to your PC or Mac – the quickest way is to go to the “hamburger” 3-line menu in the bottom right, and choose “Send to devices” to get a list of potential target computers. The menu that appears on the mobile browser may be several pages wide; swipe left and right to see the others and press and hold anywhere on the menu to edit it, allowing you to reorder the icons or hide/show them.

Article content

Just as Chrome behaves, having sent the link to one or multiple PCs, a notification will appear in desktop Edge inviting you to open it…

Article content

… and if you have the browser on PC and phone both set up to sync with your Microsoft Account, you’ll also see previous pages browsed on the phone by looking in the History page (CTRL+H) in Edge on the PC, which makes it easy to go back to pages you had previously viewed on the phone without needing to deliberately send them across.

Article content

#71: Trying to search on LinkedIn

Posted on by ewand

a cartoon image of a man sitting in front of a desktop computer screen, showing him trying to search

Since you’re not reading this on LinkedIn, you’re maybe not one of the believers – Stay strong! It’s been nearly 9 years since Microsoft announced its plan to blow $26Bn on acquiring the social network for business users, supposedly in competition with Salesforce, Facebook, Google…

At the time, Forbes commented:

This new deal means Microsoft can embed LinkedIn with Skype, its email system and other enterprise products so that, in the words of one Silicon Valley expert, it will be able ‘to recreate the connective tissue for enterprises.’

It seems the Skype integration never really did pan out. Outlook and LinkedIn never got especially close, and Salesforce’s nightmare of Microsoft poring over all that data and not letting anyone else get access to it never really materialised. Even Microsoft tools don’t really have very good access to the data.

One of us (but not really)

At the time, the LinkedIn acquisition was Microsoft’s largest and seen as quite risky, with the backdrop of a failed $45B bid for Yahoo! and not-exactly-successful integrations of multi-billion buyouts of Nokia and others.

There was some consternation on how LinkedIn could possibly be worth all that money – one of the most popular internal Microsoft Yammer communities has even been reborn in LinkedIn, for current and former ‘softies alike …

Article content

(though Groups in LI seem to be less functional than Facebook Groups, so the place to go is FB’s Microsoft Old-timers, which has about 30x as many members).

In truth, LinkedIn has been very successful – as pointed out by the excellent Jack Rowbotham:

Article content

It’s said there are over 1 billion users. LinkedIn revenue was reported as growing 9% year-on-year in the FY25 Q2 results. Though revenue numbers are combined with other groups, Statista reckons that totals about $16B annual revenue. Not bad.

Maybe what has been LinkedIn’s biggest reason for success in the Microsoft family is that it’s never really been fully assimilated. Sure, management sits at the top table (and co-founder Reid Hoffman is on the board) but LinkedIn has been kept (or kept itself?) at arm’s length; Microsoft friends and partners are not LinkedIn friends and partners. LinkedIn employees have linkedin.com primary email addresses, not microsoft.com ones (even if they may also have a lesser-user microsoft.com address…) There’s a certain defiance of separateness even after almost a decade, a bit like Dynamics used to be or as GitHub also is.

Even the platform it runs on is not quite fully on the bus – after announcing a plan to gradually move to Azure and run on Azure Linux instead of CentOS, that has reportedly been binned in favour of a hybrid model.

Searching for stuff

To paraphrase Yoda: Search not: Find, though that is sometimes easier said than done. Along with holding itself apart organisationally and technically from the rest of Microsoft, LinkedIn has a somewhat stubbornly different look and feel to everything else that comes from Redmond.

Searching on LinkedIn starts with entering whatever you’re looking for in the search bar on the home page.

Article content

There are few operators you can use – AND/OR and putting stuff in quotes can help to guide things, but you will need to use the Posts / Companies etc filters to zone in to the right content, and you can only do that after the first search has been run. Note that AND, OR and NOT must be in capitals and they specifically call out that + / – isn’t supported.

So, if you want to find something – a previous post in a newsletter you’d read, for example – there isn’t an easy way to do it without first searching everything, then telling LinkedIn that you don’t want “people” but something else. Even going to the newsletter home page doesn’t give you the ability to search its contents, which seems like an own goal.

If you’re looking for a Post you may get a button offering “From my network”, and clicking on that will invoke a filter to select your top  connections, people you follow or your own posts.

Article content

But you might not get that option. If you don’t, then you need to select Posts and then use the Date, Content type or, in this example, “From Member” filter. If you’re looking for your own content, you need to type your own name and have it resolve, before clicking on show results.

Article content

More help is available on Search on LinkedIn, and you might notice that some filters stick sometimes (but not always) so if you’ve already set the Posts and From:me filters up, then others searches will keep them until you clear the filters, or they somehow just clear themselves.

Article content

When you do get results, depending on what you search for, you’ll be presented a list of things that look like they match, but there’s no highlighting of the search terms to see where that match is, so you’ll need to open them up individually to see if they match.

For the more adventurous, you could hack the URL to add search terms and set the filters – eg

https://www.linkedin.com/search/results/content/?keywords=vermouth%20AND%20recipe&postedBy=%5B%22me%22%5D

There are some special characters in that URL – %20 is space, %22 is “ and %5B and %5D are square brackets, so you could actually enter

https://www.linkedin.com/search/results/content/?keywords=vermouth AND recipe&postedBy=[“me”]

… and the browser will sort it out.

Or just search, get a wide range of initial results then use the filters. It’s less “correct” but it’s bound to be quicker.

#65: Enshittifcation 2025 pt 1 – progressing well

Posted on by ewand

A computer on a table AI-generated content may be incorrect.

The “word of the year” for 2023 was “Enshittification” – as defined by author Cory Doctorow:

“Here is how platforms die: first, they are good to their users; then they abuse their users to make things better for their business customers; finally, they abuse those business customers to claw back all the value for themselves. Then, they die.”.

Similar concepts have been written about previously.

An Australian dictionary summarized it nicely in 2024 as “The gradual deterioration of a service or product brought about by a reduction in the quality of service provided, especially of an online platform, and as a consequence of profit-seeking.”

There are numerous variants of enshittification which we’ve all observed, usually concerned with improving revenue streams for the service provider at the expense of the quality of the service or organizations failing in some way.

· Changing the business model of the service because the original premise isn’t sustainable

· Killing products or removing features which cost too much to provide

· Failure to adapt with technology, stifling innovation, leading to stagnation and irrelevance

· Decline of a service or community due to poor leadership, user behaviour or rise of another

· Trapping customers, making it inordinately difficult to cancel or migrate from the service

Sometimes these moves are long planned – capture the market by operating at a loss then pay back your investors later by reaping the rewards of early market advantage, potentially even turning the screws on your customers (see Amazon, Netflix). Companies might be overaggressive competitors, looking to quash alternatives (Amazon, Microsoft), and it’s just a fact of life that some things don’t work and walking away from them angers or disappoints customers who used them (see Google, Microsoft, many others).

2025 In

This year is barely 20% over but we’ve already seen numerous changes to popular online services. Netflix is cranking up subscription pricing again (among others); Microsoft has added Copilot features to Personal and Family plans, jacking the cost up significantly to pay for it. Spotify has been teasing a lossless service for years, but might get around to launching it this summer. Hands up who thinks it will be an extra cost over the standard tier?

Even if a service provider puts out notice that they’re going to make some degrading change (or if, as WindowsForum.com does about all the upcoming Microsoft cuts, others collect the news and report it), it can still feel like a shock when you notice it’s not there any more. Microsoft calls it “deprecation”.

As mentioned in ToW #62, there are lots of occasions where a feature changes very much for the worse (from a user’s perspective) but there’s nothing much you can do about it other than seek an alternative.

Search caching

One relatively quiet change that happened in both Google and Bing during 2024 was the removal of cached pages in search results. This was a handy way to find a web page which, for whatever reason, wasn’t online any more … though could be used to find out how a page looked before some recent change. “Link Rot” means that lots of pages link to sites that have disappeared.

Both Google and Bing used to have cached copies of pages that could be viewed by clicking an icon next to the item in search results.

A screenshot of a computer AI-generated content may be incorrect.

Google discontinued it without notice in February 2024, so people who noticed would turn to Bing, Yahoo or Baidu as they all still offered the cached feature. The reasons for removal? “It was meant for helping people access pages when way back, you often couldn’t depend on a page loading. These days, things have greatly improved. So, it was decided to retire it.”

Bing followed suit in December, saying, “This week, we’ve removed cache links from Bing search results. As the internet has evolved for better reliability, and many pages aren’t optimized for cache viewing.”

Both reasons smack of “we’re doing this because it makes your life simpler and the feature wasn’t needed any more anyway”, but in reality there will be cost savings and potentially legislative reasons too. Why offer the service if you can’t monetize it? What’s next?

Google has since wired in a link to the Internet Archive – a free, useful resource though sometimes a bit slow and not always complete – if you click the “:” to the side of a search result, then click through to “More about this page ->”.

A screenshot of a computer AI-generated content may be incorrect.

Turn to specific addins

One of the use cases for looking at cached results is to see how something was previously described before it was updated; or maybe to see how much something was being advertised for, previously? Have you ever seen a product marked as “SOLD” and wondered what it had priced at before?

It may be worth looking at the various extensions / app stores to see if there’s an enterprise developer who’s built something that might help. One such is the excellent AT Price Tracker, for the UK Autotrader website.

A screenshot of a car AI-generated content may be incorrect.

Who’d want to be trying to sell luxury 3-ton EV-SUVs at the moment?

AT Price Tracker will show a summary of what the same advert has been listed at previously; traders could remove it entirely and re-post to fox the logic of the app, but it’s presumably under the radar enough for most not to even notice it.

Unless Autotrader decides to get some enshittification in and block whatever access the addin has.

#63: Trouble with your network?

Posted on by ewand

buffering

We’ve all been there. Just when you need it to work, your home internet connection goes down or huffs off in go-slow mode. You’ll have seen others who, even 5 years after enforced home working, haven’t quite figured out how to make their networks, er, work. Or the colleague who always appears to be having trouble with their internet, so they can’t switch on the camera…?

What to do if your network appears to be up the swannee?

STEP ONE – THE THREE-FINGERED-SALUTE

If you’re lazy and uninterested in the root cause of a problem, then a quick way to resolution might be the have-you-tried-turning-it-off-and-on-again trick. Most broadband routers have a button to reboot them, or even just pull the power for 10 seconds and then put it back in.

Sometimes, service providers will tell you to reboot your router if you are getting an error – streaming apps on smart TVs appear to be adept at this. Technology gurus will scoff that there’s no way that could be the problem, it must be something with the app provider (until they reboot the router as a last resort, and the app starts working).

The original “Three Fingered Salute” was a moniker applied to CTRL+ALT+DEL, the unmaskable hardware combination on early PCs which forced a reboot. Nowadays, Windows handles it with more grace.

STEP TWO – CAN YOU SEE OUTSIDE?

Once you’ve waited 5 minutes for your broadband router to restart (and assuming that hasn’t fixed the problem), the next thing to check is if your computer can talk to the outside world. If not, that means the problem is somewhere between your keyboard and the internet service provider that the modem connects to. Trying to log a fault with your provider’s support desk will generally mean they’ll make you try unplugging and restarting everything in your house first, so be prepared.

Make sure you’re actually connected to the network and have a valid address; in Windows 11, go to Settings / Network & Internet and look at Properties of whatever the connection is. You should see the local network address of your machine, and the gateway through which everything is sent and received. The format of the numbers might vary but should look something like:

A screenshot of a computer AI-generated content may be incorrect.

[If you’re getting a 169.xxx.xxx.xxx address then something is going wrong with your computer and getting an IP address; if it’s in your house, try removing and replacing the network cable, or rebooting the PC and/or router. If it’s in a hotel or public wifi area, give up and set your phone up to do Tethering].

PING!

Now, fire up a command prompt (press WindowsKey+R then enter cmd) and enter ping 192.168.1.1 (or whatever address your default gateway is).

A screen shot of a computer AI-generated content may be incorrect.

The ping command literally bounces a short piece of data at the address you’re looking for; if that location is available (and not being blocked by some firewall or other) then it replies, and the fact that you got a response and the speed it took are displayed.

If you’re going to be playing with cables and stuff, you could enter ping -t 192.168.1.1 – the -t flag makes it continue pinging until you close the window or press CTRL+C. If you’re getting a reply at all, and the latency (time<1ms) is stable and low, then your connection to the router is just fine.

Latency is the enemy of a stable and reliable connection – when you see people having problems with Zoom/Teams meetings and their audio or video is garbled and choppy, that’s almost always a latency problem, either within their home network or somewhere further up the chain. Some networks suffer from it inherently – satellite connected, like in-flight WFi, are a good example – and anything that needs a stable, real-time connection (video calls, multiplayer gaming etc) is best avoided.

STEP TWOa – ARE YOU WIRELESS?

If you’re using a wireless network, it’s worth checking that something isn’t getting in the way unexpectedly. IT bods troubleshooting a problematic early business WiFi network found that it kept dropping out randomly, but more often around lunchtime – until they realised their neighbour in the office block had a kitchen on the other side of the wall, with a microwave oven that nuked their WiFi whenever it was used. Some home electronics could do the same, or even things like wood burning stoves.

Maybe your household is near other users who could be getting in the way? Try scaring them for a laugh but it’s also worth making sure your WiFi network isn’t clashing with theirs. It could be worth trying the ping -t trick above and move the machine around the place to see if there are some spots where you’re getting really high latency numbers, or to see if the ping reply doesn’t come back at all.

Try the WiFi Analyzer app from the Windows Store (if you’re on a PC; there are many others for iOS/Android and Mac):

A screenshot of a graph AI-generated content may be incorrect.

This app will show you all the neighbouring networks and which channel they’re operating on; if you’re sharing the spectrum with too many others then it might be worth reconfiguring your WiFi network to lock to a different channel; time to RTFM for the router.

An alternative to WiFi Analyzer is the long-established inSSider. The latest version needs you to register for an account, but the old one – which still gives a lot of useful info – is still available, if you’re careful to dodge the many links to other unwanted stuff:

A screen shot of a computer AI-generated content may be incorrect.

IT’S NOT ME, IT’S YOU

If the internet connection is still not playing ball, but initial signs are that the local network is OK and you’re fairly confident you don’t have sporadic hardware problems or similar, then it’s pretty likely the fault lies elsewhere. Get ready to face the inertia of service provider helpdesks who will assume that the problem is at your end… to prevail, we must arm ourselves with evidence and above all, keep calm.

To avoid over-doing things, we’ll pick that one up next week.

#62: Will the web become exclusively mobile?

Posted on by ewand

A group of people with chains around their faces AI-generated content may be incorrect.

Looking back over the last 50 years of technology progress, the internet must surely be the most significant change enabler. When the developing ARPANet adopted TCP/IP in January 1983, the ‘net as we know it started to really take shape. TimBL wrote up an idea of how to connect pages of info together, and within a few years the Worldwide Web started on one of Mr Jobs’ NeXT machines.

As the web evolved to become more consumer-centric and people got PCs in their home which could connect, life started to shift online, especially when broadband replaced dial-up in the early 2000s. Laptops and WiFi helped to unshackle people from their desks and enabled working and playing from nearly anywhere. Coffee shop owners of the world rejoiced; up to a point.

But the most significant trend has surely been mobile connectivity – initially providing access to the same stuff just on a smaller screen. Now, we’re beginning to see the web and info on it become desktop-free zones. The decline in relevance of the desktop or laptop computer has been coming a long time, as smartphone usage around the world exploded. In the future, we’ll potentially be forced to use phones where a better user experience could well be delivered on a big screen, as service providers try to reduce costs while trying to provide a secure, easy to use experience.

Desktop falling behind

Even in 2014, Windows accounted for nearly 2/3 of web traffic at the start and a bit more than half by the end of the year. Android was taking an early lead over iOS and the Mac had a steady-ish 5%.

Picture1

Data from statcounter.com

Contrast to the end of 2024 and two-thirds of all traffic is from Android and iOS, with Windows & Mac together just over 30%.

Picture2

Looking beyond which mobile or desktop OS you use, Chrome is the default browser cross-platform with two-thirds of all traffic, while on the desktop, Microsoft Edge has about 13%. Looking at mobile only, Edge has less half of one percent of usage (beaten slightly by Firefox, and Opera has 4 times the usage) though it’s available for both Android and iOS. You have to wonder when Microsoft will pull the plug, even if the mobile Edge browser is a decent effort (especially so if you use Edge on Windows PC too).

Apps taking over, not always for the better

It’s not just that content is moving to be more mobile-oriented; increasingly, stuff that used to be available on the web can only be done via using an app. To a degree, this could be part of an ongoing enshittification process – a topic we’ll delve into in a future ToW.

As an example, Google has removed the “Timeline” feature from Google Maps online. Discussed briefly in ToW #638, this was a great way of checking where and when you were – handy for doing stuff like mileage claims or remembering how long it’s been since you’ve visited someone.

A screenshot of a phone AI-generated content may be incorrect.

This particular change has some solid reasoning behind it; rather than The Chocolate Factory storing data about where you’ve been on its servers, they announced that the data would be held securely on the device instead. Is this Google being altruistic and privacy-sensitive, or just trying to avoid being held to account for something down the line? … You decide.

From an end-user perspective, losing access to Timeline in the browser is a bit annoying and too bad if you want to share your history across multiple devices – the data is local to one device only and that’s that. Just in case your phone gets lost, you might want to back it up now…

Un Appy with Online Banking

There are many other examples of websites trying to push you to use their apps (click a link on a mobile browser and it often will try to redirect you), but the biscuit is surely taken by at least one UK credit card provider.

Early digital banking services might have required special hardware or bespoke PC applications, but gradually all went into the browser, with some requiring a hardware token or other device to be used when signing in. Now, it’s very common to need some form of Multi-factor authentication like receiving a one-time SMS message to be able to login; even making a one-off purchase generally requires Strong Customer Authentication.

Users of Virgin Money credit cards have no web-based view of their account, with the options being to use the app or do everything another way. Viewing and download statements can only be done on the phone; the only alternative is to request a paper version be posted.

The in-app help used to advise that if you wanted your statements on a proper computer, then download the PDFs to your phone and email them to yourself. Fortunately, that advice has since been removed…

Happily, if you’re an Android & PC user at least, you could use the Phone Link app to browse the file system on the device when it’s connected. The phone will appear in the left pane on Windows Explorer…

A screenshot of a computer AI-generated content may be incorrect.

… and if you navigate to Phone Name > storage > Download, you’ll be able to view, copy elsewhere on your PC, and even delete the file from the phone storage.

A screenshot of a computer AI-generated content may be incorrect.

If you’re using OneDrive (the consumer version) for your personal files, you might want to enable the Personal Vault and put potentially sensitive stuff in there.

#61: Adios, Office!

Posted on (Updated by ewand

A person eating a dog AI-generated content may be incorrect.

Microsoft is seemingly ditching it’s “Office” brand, which first appeared in 1990 to describe the now-familiar bundling of 3 apps – Word, Excel and PowerPoint. Along with numerous other apps and services being added to the family, for some time the company has been pushing the online version – Office 365 then Microsoft 365 – as the default. Despite this, there is still an on-premises, discrete licensed bundle of the latest apps – Office LTSC 2024 if you really must.

Users of M365 – either personal, family or corporate bundles – can go to office.com and sign in to access all the software, services and data associated with it. This has now been renamed to cloud.microsoft and the accompanying Office / Microsoft 365 app (which is really just a PWA, a web app hosted in what looks like a Windows application) is now Microsoft 365 Copilot, in the headlong rush to call everything Copilot even when it isn’t.

A screenshot of a computer AI-generated content may be incorrect.

Somewhat confusingly, if the “Copilot for Microsoft 365” service isn’t available the following explanation is given on the support page for the app’s transition:

What about regions where Copilot is not available?

For regions without Copilot availability, the Microsoft 365 Copilot app will remove the Copilot tab from the Home screen across web, desktop, and mobile app endpoints. However, the app name and icon will remain the same as Microsoft 365 Copilot for branding consistency.​​​​​​​

… so, it will still be called “Copilot” even if the actual Copilot functionality has been removed.

M365 Personal / Family subscriptions

As well as being corporate fodder, Office Microsoft 365 has had a consumer variant for a decade: Microsoft 365 Personal gets you a single user who can have up to 5 devices where you have the Office apps installed (as well as the use of web versions), 1TB of cloud storage in OneDrive, and you get Outlook.com email without any ads. The Family subscription is around 20% more expensive and gets you the same as Personal, but for up to 6 people.

Former Microsofties can receive M365 Family for free if they’re in the Alumni Association, and with membership being less than half the price for M365 on its own, it’s worth joining if you’re eligible. If you know someone who is a current Microsoft employee or who’s an Alumnus, they might be able to get you a Friends & Family login to the eCompany Store, which lets you buy activation codes for M365 Personal or Family at a significant discount. And here’s a trick: you can stack the codes (ie. buy 3 of them for less than the cost of a regular single year’s subscription, then just apply them all to your account to kick the renewal date forward into the long grass).

Speaking of cost, M365 Personal & Family have risen in price quite a bit recently; partly because they include a load of new AI features and those cloud-based GPUs don’t buy themselves.

Welcome Copilot Users!

At the same time as potentially naming something Copilot that isn’t, Microsoft has rolled out some basic Copilot capabilities for Microsoft 365 Personal and Family users. See here for the details of what’s included and how, though if you’re really not on board with all this AI nonsense, you can opt to stay on “M365 Family Classic”, which is the same as it was before without the Copilot and Microsoft Designer guff.

You’ll be shown lots of Copilot banners if you log in to any Office app with a M365 Personal subscription or the primary user of a Family one (only the owner of the subscription gets the extra sauce, at least for now). There are ways to disable it should you want to, though not everywhere – Outlook.com displays a banner at the top of every email offering to summarize it for you…

Predictably, the User forums are full of “HOW DO I SWITCH THIS OFF” type questions. The short version is you can’t; click the X on the right to dismiss the banner but you need to do that for every. single. email. Or just learn to live with it.

And Microsoft wouldn’t be true to form if branding and packaging was simple… there’s still Copilot Pro, which gives additional capacity or the paid-for Microsoft 365 Copilot addon to business Microsoft 365 subscriptions. And Copilot functionality in Business Applications, Security, GitHub and doubtless many more…

#60: The problem with coupons

Posted on (Updated by ewand

Lots of online shops have promo codes that can be entered as part of the checkout process, to get a discount, free shipping or similar. Sign up to their newsletter and get 5% off your first/next order, they might say. It’s usually a reward for or enticement to repeat custom, or if you believe in more sinister motives, a ploy to get you to hand over your data and expose your very living soul.         

Use one of the many “coupon lookup” sites and you could easily find codes that can save significant amounts of money, especially if you’re buying expensive stuff. To the end user, it looks like free money but there’s a deeper and darker subtext. As we’ll learn, there’s never really such a thing as free money.

Don’t click the bottom one…

Sites like Coupert, Vouchercodes and more sometimes tell you what special offer codes are currently active; be wary of any which offer to “automatically apply all codes” or you’ll end up installing a browser extension, which you almost certainly don’t want to do.

1st party coupons

Microsoft has shoehorned “shopping” into Edge (similar to what Google does with Chrome, though Edge’s is a bit more internationally inclusive and somewhat easier to use), and has a Bing shopping site that’s similar to Google Shopping too.

If the feature is enabled in Edge, you’ll see a little shopping label icon in the address bar when you’re browsing something that the browser might have more insights on, and possibly be able to keep a track on the price too.

Both browser tools are convenient way to find coupons and codes, alongside price comparisons, price history etc, even if you could probably find keener deals and info by looking around yourself.

For vouchers and deals, the browser is basically scraping other sites which purport to offer them, though anyone who has tried such sites previously will probably find out many of the codes don’t work anymore.

Margins to share

Retailers typically have a high markup on stuff they sell, expressed often as a margin – if a clothing outlet sells a shirt for $100 and they are buying it from their supplier at $40, then they have a 60% gross margin. That seems a lot relative to the cost of the actual goods, but then the retailer has to run premises, pay staff, deal with returns and annoying customers – all of which will eat into that margin and give them a much lower %age of profit. So far, so good.

When dealing with online transactions, especially if the delivery cost is charged additionally, the overheads will be a lot lower and therefore the margin could afford to be less – that’s why many online-only retailers can sell the same things at a lower price than you’d find in the shops. But at least in trad. retail, customers might be browsing – they could be wandering through a mall and decide to drop in to a store and end up seeing something they didn’t know they wanted. In online retail, that’s so much less likely, therefore they try to attract buyers in other ways.

Online retailers find it sometimes helps to share the margin they make; hence the deals with cashback sites or credit cards, and by issuing voucher codes to incentivise customers to buy now while the deal is there. They may also have referral codes or links that give a small discount to the end purchaser and a kickback to the referring source as well.

Influencers and other “content creators” can earn money by talking about stuff and linking to places where you can buy it, potentially earning $thousands for driving extra buyers into the waiting arms of the online sellers. Sometimes they’ll have a voucher code that gets money off (and which the retailer can track so they know how much extra business is coming from that source). Sometimes the code is built into links on the blog or website, that when you click through (and subsequently buy), will share some margin back to the referrer.

Honey: The sweetest deal?

Along with the features browsers have built-in, there are loads of addins which can be used to help the shopping experience. Honey was a pioneer, so much so that PayPal shelled out a cool $4B a few year back.

Recent investigations have shown Honey’s business model to be on thin ice, though – ostensibly telling users that they can find the best deals with Honey, while getting retailers to pay them to offer only a limited set of the deals which might otherwise exist… so instead of Honey telling you of a sweet 10% deal you could get, they might be taking 2% off the retailer and showing you a 5% code.

Addins like Honey also sometimes pay to have their offering promoted – including paying money to influencers to have the Honey extension featured. To the chagrin of some – even leading to legal action – it appears that Honey has also been rewriting the referral links from other sites too.

So, Honey pays Spongebob Influencerpants to say nice things about them and feature on his site; all Sponge’s users run off and install Honey and are happy they’re getting something for little effort.

Later, when a user clicks on a link to buy some tat in the description text of Spongy’s latest video, instead of him getting the kickback from the retailer, the Honey addin is intercepting and rewriting the URL and pocketing the referral fee for itself.

Even if you think most influencers are gopping eejits, do check out Marques Brownlee – who is one of the smartest and most balanced of the oeuvre – and see what he says about the “Honey Scam”. Unsurprisingly, he recommends uninstalling the Honey addin with all speed.

Whatever the reality of this situation is, it’s certainly not cricket.

#57: Excel-lent Conditional Formatting

Posted on (Updated by ewand

clip_image002

A theme of previous ToWs has been that applications often have lots more functionality than users either know or care about enough to utilise. Two of the simplest yet most impactful ways of handling data in Excel (and in Google Sheets, LibreOffice / OpenOffice etc, which basically copied the functionality) is to create tables from data, and to use conditional formatting to help them stand out.

clip_image004

Select a block of data – and for the purposes of these examples, we’re going to use some sample sales data – and on the home tab, it’s a few clicks to Format as Table. Even if you don’t intend to use more advanced formulae and get into naming tables and ranges, just doing the simple formatting and declaring the top row as headers gives you great ability to sort and filter the data quickly.

If you’re lucky, the table may automatically interpret the contents of your data, too – like understanding date fields. As we’ll get to later, you can even sort and filter by the appearance and not just the actual contents.

clip_image006

Users working on data in Excel which is clearly tabular but has not been defined as a Table, should almost be considered criminals.

Conditional Formatting made easy

Back on the Ribbon, the neighbouring Conditional Formatting control lets you add more pop to an existing Table or any other data. Select whatever cells, columns or rows you want to apply it to, and on the flyout menu you’ll have access to hundreds of options to visually distinguish certain data.

clip_image008

For simple “how to” and a cheesy video, check out the help on Use conditional formatting to highlight information in Excel.

If you need to do stuff that’s more complex, there’s also the option to write a formula but it’s quite different to regular Excel formulae – and can take a bit of working out, especially if it’s more complex. See the “Use a formula…” further down that previous help page.

clip_image010

Fortunately, there’s an easier way if you’re a Copilot user (and if you’re not, Microsoft has started pushing a free 1-month trial – just make sure you put a reminder in your diary or you’ll fall into the trap of subscribing to stuff you might not want). Rather than trying to write a formula and figure out the logic of it, you can just ask Copilot and it will comply…

clip_image012

After it has been applied, you could edit the rule to change its range, tweak the formula or adjust the formatting by going to the Manage Rules option under the Conditional Formatting menu. Make sure the “Show formatting rules for:” filter is set to the right area so you’ll see this and any other rules which may apply.

clip_image014

These rules are very useful for highlighting things that stick out – like due date on a pipeline report which have now passed, or a number that’s radically out of kilter with all the others in an export from a credit card account. If you’re dealing with very large sheets of data, you could filter the view not just by the values but by the colours that your formatting has set:

clip_image016

… thus temporarily hiding any of the rows which are not of interest.

Finally, you can interrogate data within Copilot without having to mess about with filters and the like, for example:

clip_image018

To validate that this is actually true, a pivot table can show the data by different dimensions and allow totalling, sorting and filtering: in this case, sorting (descending) by the sum of all orders:

clip_image020

Pivot Tables are some of the best magic that Excel delivers; it’s been a while since they’ve featured in ToW – leave a comment if you think that needs addressing. See here for more examples of Copilot prompts in Excel.

#56: Hey kids, look who’s back!

Posted on (Updated by ewand

clip_image002

When does old become retro, and how does fashion decide when something uncool becomes drip? Brand equity rises and falls all the time; some just go out of date and are left behind, while some try to reassert themselves to speed up the cycle – see Jaguar / jaGuar’s recent hoo-hah and “Copy Nothing” brand rehab…

clip_image004

[Richard Ayoade in IT Crowd c 2006, Jaguar deleting ordinary in 2024, Reeves & Mortimer c1993]

(Eddie Izzard has some mildly sweary thoughts about the whole “Looking cool…” cycle).

Retro tech

It’s amusing when old tech becomes cool again – from hipsters rocking LCD digital watches, to GenZers toting feature phones like it was the 1990s. Some brands were never fashionable, like AOL: using an aol.com email address even 20 years ago was a marker of technological unsophistication. Amazingly, you can still sign up for an aol.com address today if you feel like sending email from the past.

Many other products and services were all the rage, then just weren’t – and one good example is Microsoft’s MSN, which now seems to be coming back from life support. Well, certain elements (which are not yet part of the revamp) were very pervasive and cool back in the day … remember MSN Messenger, before Microsoft bungled it into Skype? It was so down with the kids, even a youthful Stormzy was using it (and that’s how he got his name).

The Microsoft Network

MSN first arrived 30 years ago as part of the Windows 95 (“Chicago”) beta program; it was a “walled garden” network service providing proprietary content through a dial up network. Market leaders AOL and CompuServe had similarly restricted services – using them wasn’t really “being on the internet” other than you could browse pages written for those services, use email and later, instant messaging. Win95 initially didn’t even have a TCP/IP stack built-in, so without 3rd party software, you couldn’t be directly connected to the ’net.

MSN’s late 90s paid-for dial-up service became a regular ISP and there was a Premium subscription available to netizens who wanted additional security and the likes.

From that closed offering, the MSN brand morphed into something applied to lots of Microsoft’s consumer-oriented web experiences – from the Yahoo!-like attempt to establish a homepage, to in 2001 rebranding the first mass free email service which Microsoft acquired 5 years earlier, as MSN Hotmail.

Legacy users of the Win95 MSN service were ported over to Hotmail and given short @msn.com mail accounts. Other users could at one point choose a variety of domain names when signing up for a Live ID / Hotmail account, including @msn.com and @msn.co.uk. These have long since gone away and the only options now are outlook.com and Hotmail.com.

At one point, there were numerous “MSN …” apps for Windows and mobile devices, from MSN Travel to MSN Money. Most of these were subsequently killed off or renamed to something else, like Microsoft News.

Amazingly, you can still buy MSN Premium today – for £7 a month you get, er, lots of stuff that’s available, better and/or for free from other places, including other bits of Microsoft itself.

clip_image006Today, many of the buttons on the MSN Explorer app either don’t work, or redirect to a page about how Internet Explorer isn’t supported anymore. One of the purported benefits of MSN Premium is that it’s possible to sign up an additional 9 users for an @msn.com email address; given the number of users complaining that it no longer works (and getting radio silence from support), it seems that loophole has now closed.

Microsoft Stop Start

At one point, Microsoft appeared to want “Start” to become the new MSN brand; the homepage for Edge browser (unless you do yourself a favour and set it to something else) was “Start” and the single mobile app which merged MSN News, MSN Money and more was just “Microsoft Start”.

clip_image008

Now the Start apps have been renamed to just “MSN” on mobiles, alongside MSN Weather and MSN Money which avoided the previous cull; PC users don’t have an “MSN” app but might expect to see the same content on Edge homescreen or on the Widgets on their taskbar.

clip_image009

Screenshot 2024-12-04 082142

Sadly, renaming the app and service doesn’t appear to have done much for the quality of advertising or the myriad click-bait “news” providers, though it does appear to have gotten less insidious and you can at least hide sources you don’t want to hear from again.

clip_image011

The daily email newsletters are not bad – see https://www.msn.com/en-gb/personalize/newslettersignup to manage your subscriptions. Let’s see if Microsoft starts to re-launch other MSN services in due course…

clip_image013

#55: Quick access to fave notes

Posted on (Updated by ewand

clip_image002

A few themes have re-appeared on Tip of the Week over the years … saving time by using keyboard shortcuts, finding useful but somewhat hidden bits of Windows or Office apps, etc. One of the most prominent seams to mine, however, has been an undying for Onay-no-tay.

The UX Paradox of Office Apps

Usability research into Office applications once found that 87%* of the new features users asked for, were already in the product – they just didn’t know how to find them. As more and more features were added to apps – Excel particularly, it seems – end-users just didn’t know how to “discover” them. By Office 2000, dynamic “intelli-menus” basically hid options which were more obscure or which an individual just didn’t use, and while it made things look simpler and less cluttered, it made the problem worse.

A wholescale UX rethink in Office begat the “Ribbon”, which is now pervasive in other apps; if you’re interested in such things, check out Jensen Harris’ 2008 presentation on what led to the Ribbon being conceived. The talk offers a great historical perspective but also goes over the thought processes on how these things come about.

* statistic is made up but the story holds true. Who cares if facts and figures are correct as long as the lies are well presented? How do you think Excel charts and PowerBI got so successful?

Not Just Another Toolbar

Even with the Ribbon to make things more ordered, sometimes it’s good to be able to jump straight to a feature you use commonly; the customizable Quick Access Toolbar on the top left of many apps gives you the ability to pin certain commands, and can be an invaluable way of getting to functions you like without delving into Ribbon tabs and menus.

clip_image004

Click the down-arrow to the right of the toolbar and you can pick from a set of suggested functions, or by customizing it, you can delve into any part of the extensive menus and pin just that one feature there. There are commands which are not even on the Ribbon, but you could pin them to the QAT if you like them…

clip_image006

The QAT is present in Word, Excel, PowerPoint, Access, Outlook (classic) – but not New Outlook, to some users’ chagrin. It’s not uncommon to find a similar UI feature in 3rd party apps from the mid-2010s.

OneNote Favo(u)rites (again)

New Testament Tip of the Week #39 covered saving Favourites in OneNote: #39: OneNote Shortcuts, Favourites and Pins. Despite some of the guff being taken up with browser and mobile favourites, the good stuff in that tip was in (once again) recommending the fantastic OneTastic.

clip_image008

As well as providing an extensive macro capability, the OneTastic addin lets you pin a page or section to “Favorites”, and you can later go back to the same menu used to manage the pining, in order to access your previously pinned pages.

For extra goodness, try customizing the QAT and looking for Pin to Favorites…

clip_image002

Select it, click Add >> and hit OK. Now you’ll be able to access the drop-down for Favorites right there from the top left corner…

clip_image004[4]

Happy Friday!