#58: Tales of Yuletide cheer

Posted on December 20, 2024 (Updated December 19, 2024) by ewand

A tradition of Tip o’ // of the Week at the end of each year, has been to post some completely non-tech related stuff to help transition from “work” mode into the general lethargy of the festive season. Here’s something of a greatest hits, along with some new nonsense. Top tip if you’re reading this on LinkedIn: hold the CTRL key as you click on links, to pop them into a new tab rather than lose your place on this post.

Drink!

As if the festive season doesn’t present enough opportunities to over-indulge, making some cocktails to ease into the evening can be an effective way of doing it. Clearly, drinking responsibly is to be advised or you never know where that might lead.

One of the most popular of all Tips arrived 2 years back; it was certainly the most fun to write.

A martini glass with a drink in it

Description automatically generated
662 – How to make the perfect martini

Some of the ingredients to the ideal martini might take a bit of sourcing, so you may need to stop reading this immediately and go shopping. Recommended gins include Berry Bros no 3 or Tanqueray 10, vodka is Grey Goose or Belvedere, use Dolin for vermouth or Lillet Blanc is you’re Vesper-ing (with a few drop of Angostura bitters too).

A group of bottles on a table

Description automatically generated

The two brothers who took over the Angostura bitters company decided it was time to rebrand; one designed the bottle, the other the label. They didn’t think to consult each other and the label was too big. 150 years later, it still is.

For espresso martinis, fill a cocktail shaker of glass with ice cubes and add one measure of vodka (even cheaper stuff – save the Grey Goose for better cocktails), one measure of coffee liqueur (Kahlua is OK, if a bit sweet; make your own if you have time, or Mr Black’s if you can find it). Just before serving, add the same measure again of hot, strong espresso and shake it like crazy. Pour into waiting glasses to get a nice crema. Top with a few coffee beans (three: definitely not an even number).

For more cocktail related fun and games, check out Richard Godwin on Substack.

Eat!

For delicious snacks to go with your cocktails above, try roasting some spiced pecans – in fact, they make a great accompaniment to a small salad with pear and blue cheese.

Spiced pecans

Pre-heat oven to 200C / 400F / Gas Mark 6
In a bowl, mix up 1.5 tsp of salt, 3 decent pinches of cayenne pepper, 3 tsp of Worcestershire [pr. Wooster] sauce and a good slug or 3 of Tabasco.
Add 225g of pecans and toss them well with the mixed goo.
Pour onto a baking tray and arrange in a single layer
Bake for 5 or 6 minutes, turning halfway through so they don’t get burnt on one side
Try to not to eat them all before they’re cooled. Put what’s left in an airtight tub and they’ll keep until the New Year (hah).

The above also works well with almonds or a mixture of the two. That way, you can save the pecans for…

Maple roasted pecans

Pre-heat the oven to 160C / Gas 3 / 325F
Mix 170g pecans with 2 tablespoons of maple syrup and 1 tsp of almond essence
Pour onto a tray and arrange in a single layer
Bake for 12 minutes, turning halfway

Green soup

For something more healthy, perhaps a starter on a big-meal day or a quick turkey-free lunch before the port and cheese of betwixtmas, how about a simple 3-ingredient green soup from a blue-mouthed celebrity?

A bowl of green soup

Description automatically generated

658 – Sweary 3-ingredient soup

Chef Gordon Ramsay covered this simple recipe back on a show called F-Word (F for Flash…?) but the online videos showing you how to make it in 5 minutes have been taken down. He published it in the book, Gordon Ramsay Makes it Easy too. Or just follow the approach above; combine with a bit of goat’s or blue cheese for unctuousness and a couple of bits of walnut or pecan for extra texture.

Steak

The most popular (by some margin) post on an old TechNet blog called “The Electric Wand”, was how to cook a perfect fillet streak (and applies to other types too), later repurposed to the ToW hosting site – How to cook the perfect fillet steak.

In short, get the meat to room temperature, dry it with kitchen paper, apply oil and seasoning to the steak directly then cook it quicky on a searing hot pan for a short time on each side. Let it rest on a warm plate for at least as long as it cooked.

Rest

That’s it for Tip of the Week in 2024 – have a Merry / Happy whatever-you-call-it, and see you in the New Year!

#57: Excel-lent Conditional Formatting

Posted on December 13, 2024 (Updated December 11, 2024) by ewand

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.

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.

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.

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.

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…

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.

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:

… 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:

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:

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 December 6, 2024 (Updated December 5, 2024) by ewand

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…

[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 3^rd 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.

Today, 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”.

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.

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.

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…