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

#55: Quick access to fave notes

Posted on November 29, 2024 (Updated November 29, 2024) by ewand

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.

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…

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

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…

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…

Happy Friday!

#54: New Outlook is coming, ready or not!

Posted on November 29, 2024 by ewand

Windows Mail or Outlook users might have already noticed that a “New Outlook” is coming. If you’ve already made the switch, you’ll be familiar with the new app’s look and maybe some of its shortcomings. For many people, it will be an improvement once they get used to it. Well, “some” rather than “many”, at least initially.

New Outlook is going to become the default mail client from January 2025. A blog post from this week’s Ignite outlines some of the new and “coming soon” features in New Outlook…

Copilot integrations. Lots of them. Organise meetings better, prepare, follow up, take better notes, have Copilot draft messages for you etc. Copilot for M365 is getting lots of new stuff too.
Erm… The only actual mention of “Outlook” in the Ignite session catalog is in the session, “Boost productivity with Copilot in Microsoft 365 apps”

There are lots of new features being built for New Outlook; some are filling in gaps compared to older experiences, though many are integrating new online services and apps (like Microsoft Places).

And there are plenty of things already in Outlook Web App (and therefore also in New Outlook) which are a step forward from dusty old Outlook (or Outlook (classic) as Microsoft is renaming it) – Snoozing email, pinning individual messages in the inbox, soon-to-arrive sorting by Copilot-deemed level of importance. If you’re responsible for delivering New Outlook to your users, check out the adoption site for more details of how to get the best out of it.

The timeline for Microsoft 365 users moving to New Outlook as a replacement for the old Outlook application has also been highlighted – from 2025, the current “Opt In” will become “Opt Out” – ie. Users will default to having the new client but can choose to revert to the old one. This will be delayed until mid-2026 for Enterprise subscribers. One glaring omission is the date when this Opt Out phase will be removed …

A quick history lesson

Outlook has been the primary email client for Windows & Office, since Office 97 appeared 28 years ago. Outlook evolved over numerous versions and was joined by a variety of other, different apps using the same name, even if they didn’t share anything else – mobile apps, based on software from acquisitions, and a web client that came from email server teams in Exchange. Even the old Hotmail service adopted much the same UI and was renamed Outlook.com.

Another similarly named app was Outlook Express, a rebranding of the previous free “Internet Mail & News”, used primarily to connect to ISP-provided services using internet standards (IMAP, POP, NNTP). Outlook Express eventually went away and was ultimately succeeded by Windows Mail, or Mail and Calendar.

Both of these – the heavyweight mail & calendar app for Office users, and the “lightweight” one that came with Windows 10/11, are on the verge of collision. It will be a long time before Microsoft can completely yank the carpet from underneath Outlook, but if you’re a Mail and Calendar user then your time is running out.

What will happen on 1^st January 2025? Will Mail users be forced to move to Outlook – seems likely. Will there still be a way to revert to Mail even if they don’t care about “support”? Expect there to be unsupported back doors for a while, but eventually resistance will prove futile.

If you find yourself using New Outlook and feel like reverting back for a few more weeks, there’s still time to go to Settings | General | About and hit the button to Open mail instead.

What’s what with New Outlook

The New Outlook application isn’t really a Windows app in the same vein as the old Mail app (which is/was a UWP app, whose raison d’être disappeared when Microsoft’s mobile ambitions died) or the classic Outlook (a regular Win32 app). New OLK is a wrapper on the Outlook Web App which is provided by Outlook.com/M365, so most of the functionality is really happening in a browser that is embedded in the application. This is part of a long-planned move of unifying the PC, Mac and web versions of Outlook and probably, in time, mobile ones too.

Some licensing changes were snuck in with New Outlook, then clarified as the restriction was lifted somewhat. [In a nutshell; if you only have an M365 Basic license, you cannot use New Outlook on your mailbox, even though you could use Outlook (classic)… think of it like closing a loophole which may or may not have existed previously]

What’s wrong with New Outlook

OK, there may be a few gotchas and glitches and some things aren’t quite finished, but so what?

If performs well enough – which it kinda-does – then who cares? Well, for Windows users at least, there are some pretty sizeable gotchas which are going to be hard to fix, if not impossible:

Offline. Every other email app that’s been written for Windows for years has had the ability to store an offline copy of your mailbox. Outlook 2003 and later even defaulted to using that local copy when running against an Exchange mailbox. Some offline capabilities have been / are being added to New Outlook, to help make it useable when you temporarily lose a connection, but so far, it’s a long way from having a full offline copy of your mailbox.
Gmail / iCloud / Yahoo! etc mail. Old Outlook and Windows Mail could both connect to Google Mail (and a variety of others, including IMAP mailboxes from old ISPs), by essentially downloading the email and doing everything locally, most likely synched with the original mailbox. New Outlook doesn’t have the offline spuds to do that yet, so it needs to sync all your Gmail into “the Microsoft Cloud” first – see here for “details”.
There’s no obvious way to see how much storage you’re using (or where the data is being held) though at least for now, there’s no additional charge. Some people might get a bit worried about Microsoft hoovering up all the email from a 3^rd party inbox and storing the data in its cloud… even if their responsible AI and privacy pledges say they won’t do anything with your email, it’s now not under your control.

Cross mailbox functionality is non-existent.

Search. Though you can add multiple mailboxes into a single New Outlook window, in effect you’re just pointing to nn number of M365/Outlook.com instances, one-at-a-time. Oh, and you can’t re-order them once they’ve been added.

This means that if you have – say – a work M365 mailbox, a private Hotmail/Outlook.com mailbox and maybe an old Gmail account, all synced and running in New Outlook, you can’t search for something across all of them. Ironically, the Outlook mobile client (at least on Android) does a great job, not only searching across account but presenting a single Inbox view composed from all of them.

Since each account is a separate thing on the back end, there is no way that cross-mailbox search will work unless there’s either a way of orchestrating it on the service (very non-trivial) or until all mail data is downloaded locally and the search carried out there. See item 1 in this list – not going to happen at all, or at least not in the foreseeable future.

Calendar. Other small gotchas get in the way here, too. Though the Calendar view tries to present a single view of a schedule composed from multiple mailboxes, when you create a new calendar entry, it starts from whatever your default account is.
Start adding details – subject, changing meeting times, etc – and if you realize you meant to use a secondary account, then it’s simple enough to click the drop-down box at the top of the calendar item and choose the account you wanted.
And everything you’ve just edited will be lost, with a blank entry now created in your other calendar.

Drag & drop. There’s no way of dragging stuff from one mailbox to another and there’s no way of importing from or exporting to a PST file either, yet. If you’re leaving a company and want to make sure you have all your private calendar entries and contacts, along with any personal mail you have stored in your work mailbox, better use Old Outlook to do that move.
Also, if someone sends you an attachment, in Old Outlook, you could drag and drop it into a folder elsewhere on your PC; no longer. You need to save it to OneDrive or download it to your computer first.

Zoom is horrible. Especially on smaller laptop screens, it might be necessary to zoom in and out of the preview pane in mail. In Old Outlook – just as in Word, Excel, PowerPoint, Edge, Chrome and however many other applications, if you use a mouse scroll wheel while holding down the Control key, the content in the application window will smoothly zoom in and out. Ditto zooming in and out using a pinch motion on a trackpad, or pressing CTRL +/-.
In New Outlook, some zoom motions don’t work (pinching on the trackpad) or if they do (mouse wheel + CTRL), it’s far from smooth and also zooms everything around the content too – including all the UI surrounding the content like the Reply buttons etc. It’s jarring evidence of the fact that everything in the preview pane is just the OWA browser view, and you’re zooming into everything, buttons and all, not just the content of the message

Example – here’s an email at 100% magnification:

Increase Zoom to 200%:

Yuck.

There are plenty of other things which grind the gears of online commentators, though some people quite like it (even if they later conclude that it’s still got room to improve).

If you’re using New Outlook, keep sharing your views on https://aka.ms/newOutlookFeedback and hopefully Microsoft will fix the stuff that’s not insurmountable, in addition to the quest to “Copilot all the things!”

#53: Right tool for the job

Posted on November 20, 2024 by ewand

Anyone who has worked in IT for long enough will likely have seen cases where unwitting users are wielding completely the wrong utility or application to get stuff done. Perhaps the entire company finance system is running on an old Access database, or the accountants were using a spreadsheet for holding something other than numbers? It’s one thing having lots of tools, but knowing which one to use when is sometimes a lost art.

Sometimes, organizational culture is to blame – if all you have is a hammer, everything looks like a nail (as how Microsoft leaders once felt about Oracle’s Larry Ellison saying that “database” was the answer to every question). Some companies use email for everything, others have moved all their internal comms to Teams or Slack, and occasionally use email only for customers.

The advent of Electronic Forms

One early measure of effectiveness of newly-installed IT systems, was the inefficiencies it managed to replace – and reducing paper forms was one often paraded benefit. Literally cutting red tape, not only speeding everything up and reducing wasted paper, moving to electronic forms was and is an easy case to make. Nowadays, you’d use a web form onto some kind of cloudy data store without even thinking about it, but it wasn’t always so simple.

In the late 1990s, forms were a key component of “Groupware”, with Lotus Notes being the early market leader (and which spurred Microsoft into competitive action in trying to build an alternative).

Microsoft had a separate E-Forms product as far back as the early 1990s, running on top of the old MSMail system, later being migrated into Exchange. The idea was that companies could easily make forms to send around in email, capturing data fields and making smart routing and workflow decisions along the way. It’s safe to say, they never really took off…

Outlook picked up forms duty (see here, in the cutting edge “Developing a workflow application” Exchange 5.5 whitepaper). There are still vestiges of Forms Designer in Outlook today (if you’re on Outlook (classic) rather than the upstart New Outlook, that is).

Forms in the 2020s

It’s so easy to use forms now – quickly building a web front end to a set of data is par for the course with Google Forms and Microsoft Forms, to name just two examples. Both are available in free versions (using a consumer Gmail/Outlook type login) or are part of corporate packages which bring extra functions and access to other data.

It is easy to create a form with some simple validation, and then collect responses from people – anonymously or (if they’re in your organization) capturing the logged-in username of the person who submitted it. Results are easily summarized and viewed with charts, word clouds~~wordclouds~~ and the like.

Each form is basically a series of questions, with different types used to validate data – like getting a rating, picking a date, choosing from set options or even entering specific types of text or numbers.

There are lots of scenarios where a simple form could take the place of sending an email – like registering for an event and collecting dietary requirements, or asking a group of people for a time and place that works best to meet; instead of trying to juggle lots of responses, a form could be the ideal way to present options and get their selections.

For meeting arranging scenarios there are numerous ways of trying to make this simpler – from websites like Doodle, the various Calendly/Bookings options for 1:1 meetings, or the former add-in utility FindTime for finding group availability in Outlook, which has now been replaced with a built-in Scheduling poll feature.

2020s meet 2000s

There are some things which should be easy, using Microsoft Forms, that are just not. Even though Forms can be run inside a M365 organization’s own tenant, and therefore we know who everyone is as they’ve already signed in, there’s no way of adding a “Person” to a form, such that they could be picked from the directory.

To do that needs to revert to an altogether older form technology – the SharePoint List. Originating from 2001, SharePoint really hit its stride by 2007, offering lots of web-based collaboration functionality that almost equalled what Lotus was doing a decade earlier. Microsoft did have another forms/data toolset, InfoPath, with SharePoint integrations – but that’s gone away now, not replaced with any single thing. We don’t really talk about InfoPath any more.

Using SharePoint and with~~With~~ a bit of nous, you can~~could~~ quickly build a detailed list – think of it like a simple database – and generate a form with data validation, branching logic and so on.

But a much easier way is to look at the newer Lists web app, which combines simple forms stuff with a SharePoint based back-end, meaning there’s more integration with M365, including directory integration …

… which looks a lot better than having to type someone’s name in.

Lists is part of M365 (look in the app grid on the top left if you go to Office.com and sign in, then peek under the More Apps section). )

In true Microsoft fashion, there are many ways to skin this feline – there’s also Loop, which could be used to do all kinds of groovy things in browsers, Teams, Outlook and more. Oh, and PowerApps. Mash all these tools together and you can build a spidery app legacy to keep your successors entertained for years.

#52: The Power of the Cloud

Posted on November 8, 2024 by ewand

Being shown around a modern datacenter is a pretty awesome experience. The huge rooms full of servers, networking gear and storage can be reminiscent of that last scene in Raiders of the Lost Ark. Dig a little deeper, though, and it’s the power systems that are truly jaw-dropping; how much power the DC uses when it’s running and what to do if the power supply goes away is a big part of building these operations.

At one point, Microsoft used huge Caterpillar diesel generators, each of which could generate several megawatts and was kept ready and waiting by continually pumping hot oil inside, so the machine could be started and running at full tilt in a fraction of a second in the event of power failure. Moves are afoot to use hydrogen fuel cells or other means of storing and generating backup power.

AI and Datacenter boom

As much traditional computing has moved into the cloud over the last decade or two, and faster and more mobile internet access drives end-user demand, datacenters have been getting bigger and more numerous. They almost can’t build them fast enough. About 1/3 of all worldwide DCs are in the US, and together they soak up about 6% of all electricity.

Datacentres worldwide used about 460 TWh of electricity in 2022; that’s 460 billion KWh, or enough to run 35 trillion lightbulbs continuously – about 4,300, 24×7, for each person on the planet. That’s quite a lot of power. Expect that amount to double by 2026. Google and Microsoft reportedly consumed 24TWh each in 2023.

[source – Electricity 2024 – Analysis and forecast to 2026]
https://iea.blob.core.windows.net/assets/6b2fd954-2017-408e-bf08-952fdd62118a/Electricity2024-Analysisandforecastto2026.pdf

Generative AI is VERY power hungry: estimates vary but research showed that generating one image used as much power as over 500 smartphone charges, averaging around 3KWh per image. Better make sure your ChatGPT / Copilot / Microsoft Designer usage is worthwhile and not just creating stupid images of cats and dogs.

To put the commensurate CO2 output into context, however, 1,000 of such images would be the equivalent emissions of driving a car for 4.1 miles. It’s thought that Generative AI on its own could well consume 100TWh or more by 2027.

DC providers are also looking for ways to ensure they can get enough power into the datacenter – Microsoft has even committed to restarting one of the Three Mile Island nuclear reactors and buying all of its power for 20 years. A nod to the old commitment of being carbon negative by 2030, perhaps, but the massive DC expansion to fuel demand for AI makes achieving that target seem increasingly unlikely.

Maybe new governmental administrations will incentivize clean power and reward efficiency?

Local PC power usage

There is something of a dichotomy in power usage on a local computer, especially if it’s powered from the wall rather than using a battery. You want to buy the highest performing, most feature-laden machine you can afford, so (apart from preserving battery life) why would you deliberately knobble its performance to save power? Like buying a Ferrari and driving everywhere at 20mph.

Some quick wins, especially on laptops, could be to reduce the brightness of the screen and use Dark Mode. Check the Power settings on your PC for recommendations on how to lower its energy use. Reduce the number of background apps and trim the ones which start automatically.

If you have an Intel-powered computer (PC, Mac or Linux), they have a free power usage gadget which might give you some idea about the total power consumption of your system, though doesn’t really shed much light as to what’s making it do what it’s doing…

You could try firing up Task Manager (CTRL+SHIFT+ESC) and adding a couple of columns to its default view (right-click on the column headings); useful to know which apps or processes are causing the power usage to shoot up, but devoid of actual numbers for the more data-obsessed.

Edge browser has an Efficiency mode – click the … settings menu in the top right and look under Browser essentials.

If you need more data on overall system performance, try GPU-Z – it gives detailed stats on the Graphics Processing Unit and other main components of your system, including current, maximum / minimum / average power consumption …

In the screenshot above, the Power Consumption (%) shows how much of the graphics board’s maximum power consumption is currently being used. A similar utility, CPU-Z, can give data about the TDP of the main CPU and how it’s doing too.

#50: Object Oriented browsing notes

Posted on October 25, 2024 by ewand

Obscure Computer Science theory had an obsession with “object orientation” some years ago; both a technique in how applications are written but also design thinking on how they might be used. Sensei Steve Jobs, while walking the earth before coming back to save Apple, had a famed obsessions for design and rooted his NeXT computer on an object-oriented approach. The NeXT Cube itself was arguably ahead of its time, but in 1990 cost a cool $10K (that’s about $25K in today’s money). There were few takers, though the odd geek still gets excited to pick them up 2^nd hand.

An example of object orientation in user interaction is that you go to a thing you want to work with, rather than a tool with which you want to work. Elements of this are all over UX in Windows, like going to a document in Explorer, and it lets you open, edit, print, etc. Most people will still go to Word and open a file from there; that’s why the Most Recently Used list and Search features exist.

To start something new, you’ll likely open your app of choice then use it to create a file or open an existing one. When did you last go to SharePoint and use the New -> menu option to create a document in situ, much less a OneNote notebook? Exactly.

There are other places where things are less cut and dried: you might open a notebook like OneNote, Evernote, Notion etc, and start taking notes on a thing you’re working on. Or you might want to be in the flow – in a Teams meeting, or viewing a document on which you want to make some side notes – and it makes more sense to bring the notepad to the side and ideally keep the context so when you revisit that document or that webpage, you’ll (optionally) see the notes you had previously.

Progress is not forthcoming

Sadly, as apps evolve some features are sacrificed perhaps because telemetry tells the developer that they’re not much used, or they just decide that newer things are more important. One key villain in this regard is the “new” (Chromium) Edge browser, which left behind many of the features of the old(“Spartan”) Edge, which might not have been much used but then neither was the old Edge. The dev roadmap appears to focus on more ways to inject adverts and to jam Bing services and Copilot into everything, than to actually make the browser as useful as the one it replaced.

Linked Notes

As covered 18 months ago on old testament ToW 683, OneNote has the capability to be docked to the side of whatever other window is being used, and in some cases, maintains a link to the document that is in the main window.

You’d create the page you want to make notes on in OneNote, and when Linked Notes are enabled, it will tie back to the Word etc doc you were using in the other window. That way, if you re-open the notes in OneNote you’re only a click away from pulling up the document they relate to.

If you later go to back to it in Word, however, or open the doc directly from Explorer, there’s no obvious way to bring up the notes you were taking, without going to OneNote, finding the page you took the notes on, and perhaps docking the window again. Even the Linked Notes option on the Review menu doesn’t quite work as expected – it’s for establishing a new link, not reanimating an old one.

This is an example where true object orientation would work well – you’d open the Word doc which you had linked to OneNote, and you’d automatically see the notes in a sidebar.

Remember Internet Explorer?

Even ye old IE had an option of being linked in OneNote so you could take notes on a page you were viewing. Sadly, Edge has torched this feature – along with Reading List and one of the more helpful and semi-OO feature, which didn’t use OneNote but was still potentially handy…

Web Notes RIP

Web Notes was a feature of Old Edge, for jotting down simple notes on whatever page you were viewing, and the next time you visited that same page, the notes would be shown alongside.

Imagine if you were looking to buy a house or pretty much any other major piece of shopping; whilst conducting research, you might browse to several properties of interest and could make some notes about each one – near a good school but close to a busy road, nice rear garden, high crime area down the road, neighbour has planning permission to build a house in their back yard…

It could be so useful to jot the notes as you go and have them presented again if you happen to revisit the same page in future (so you remember you’ve already looked into it). If you could later see a list of every note you took, with a link back to its source, so much the better.

Sadly, there is no way to do this in Edge, without relying on extensions. There are many out there but none really hit the brief well – if you find a better one, please do mention in the comments below.

The OneNote Clipper is worth a look if you want to keep a list of notes with links back to pages, but is old school in that you’d go to OneNote to find that list and then see which pages you had commented on, rather than the more Object Oriented approach of viewing a page and having the notes offered to you.

Perhaps the extension which comes closest to the functional requirement (even if it doesn’t win many prizes for looks) is Note AnyWhere, available from the Chrome store (and can therefore be installed on both Chrome and “new” Edge).

For ease of use, after installation, click the Extensions icon on the toolbar and Pin the Note Anywhere icon to the toolbar, after which taking notes on a new page is only a couple of clicks away. When you next visit a page, previous notes will be displayed (or you can choose to just show a number on the toolbar by the icon, to show how many notes you’ve made).

It would be nice to have some simple formatting, and searching previous notes is a little clumsy (requiring you to sign up and sync with the developer’s web front end), but for a free app that doesn’t (yet) nag you to subscribe for extra functions, it’s not half bad.

PS – Remember, this weekend is when Europe (mostly) ends Daylight Saving Time, meaning next week could see clashing of meetings arranged with international attendees, before North America catches up on 3^rd Nov. New Zealand and some of Australia has already made the leap.

This topic has been covered ad nauseam on previous ToWs … spring forward, fall back…

#49: Managing Multiple Messaging

Posted on October 18, 2024 (Updated October 17, 2024) by ewand

It used to be easy: you had an inbox (real or electronic) and new mail arrived. You’d check the inbox for anything that needed your attention, otherwise just get on with whatever it is that you were doing otherwise. Now, there are so many messaging apps that it can be a headache to not only keep on top of all the inbound contact, but to recall in which app you were having a conversation you want to go back to.

It might be easy if your professional comms is all done via email, but if you’re an itinerant consultant working with several companies, you might even have numerous professional email addresses too so keeping an eye on them all can be a chore.

There’s always a chance you’ll be dealing with LinkedIn or SMS messages with work connections as well, and with friends and colleagues there might be Facebook, WhatsApp and many more.

Two quick tips this week might help to get on top of things, if only a little.

Finding work-related messages in M365

If you use Teams and Outlook for work, with Microsoft 365, then you might already experience discombobulation when looking for something a colleague sent, or some comment discussed in the context of a project… was it in the status email, or in the chat of a meeting? Or a direct message in Teams?

Fortunately, the “Work” search options might be able to help. If your organization has it enabled, go to either Bing.com/work or look at the search option in Office.com while you’re signed in, and you’ll be able to search documents and other sources of data within your M365 environment.

One such is Messages – and the handy shortcut to jump there is aka.ms/messages. Type a search term in there and it will look across both your Outlook mailbox, but also in any Teams messages you might have been part of. Once you get used to checking it – and using the Work search for documents and other stuff – it’s a game changer.

Another trick, for finding documents in your work context, is to search from Windows Search directly by pressing the WindowsKey and typing work: followed by something you’re looking for.

Search across OneNote

Though it’s not strictly messaging, you might have taken notes during a meeting (or even had your friendly Copilot overlord do it for you), potentially spread across several OneNote notebooks.

The search box in OneNote lets you choose if you want to perform a query across the current page, section, notebook etc – but the results you get back can be a bit clumsy to interpret as it doesn’t give any details on which are really old pages and which might have been written recently.

If you haven’t discovered the obscure ALT+O to pin search results, try it out – it lets you group by section, page title or date, and you can expand and collapse the groupings to help locate the most likely page more quickly.

Now, where did you put your glasses?

#46: Cool for CALC

Posted on September 27, 2024 (Updated September 24, 2024) by ewand

Subtle changes and refinements to regularly-used applications can often slip by unnoticed. The Windows Calculator can trace its parentage all the back to Windows 1.0, and has seen numerous revisions over the years. It has featured in previous ToWs, too, most recently in what would have been number six hundred threescore and six, before the Great Reset meant ToW numbering went back to 1.

Electronic desktop calculators were a hotbed of technological innovation in the 1960s and 1970s. If you’re of a certain age, you might recall using a pocket calculator as part of your educational journey. When the first scientific pocket calculators appeared in 1972, they had a similar impact to the global slide rule market as quartz wristwatches had on the mechanical watches a decade later.

c1985 Casio fx-451M

When Personal Computers were a relatively new thing, having things like a digital notepad and a calculator built-in were seen as key productivity features; even if an IBM PC capable of running Windows 1.0 at the time would have cost you more than a year’s average salary. And yet with calculators on phones and smart watches, the poor old CALC.EXE probably doesn’t get much love these days.

The Hamburger Menu

Fire up the app (WindowsKey+R Calc [ENTER]) and it looks like any simple desktop calculator device, except that the History (top right) is much more extensive and usable than the stupid M+ / MR buttons on the old physical ones. Few of us knew what all those buttons festooning scientific calculators actually did, let alone ever used most of them.

Fortunately, Windows Calc has put lots of genuinely handy things in that three-line menu on the top left – and you can switch between them using the ALT key, if desired.

In normal use, simply pressing ALT+1, ALT+2, ALT+3 etc will switch between the different modes; open the hamburger menu (click it or press ALT+H), and scrolling down will show more than a dozen different conversion features too. Just press the ALT key when the menu is showing if you’d like to be reminded of the ALT+ … shortcut keys that can be used to invoke any of them without the need to show the menu in future.

Before Microsoft killed its long-serving line of external keyboards, some used to have a hardware button for invoking calculator. Supposedly, they’re coming back – just under a different name.

If you’re more mouse- or touch-driven then you can also jump to the primary modes using a right-click/long-tap on the taskbar when Calculator is running.

If you think there’s some great feature missing from Calculator, check out the Github page on the project and submit your own ideas. It seems to be on a slow-burn though; the Roadmap page talks about what the team is focussed on in 2021, and makes no mention of Windows 11…

#44: What’s on your (system) tray?

Posted on September 13, 2024 (Updated September 12, 2024) by ewand

The System Tray is that little collection of icons typically found next to the clock, in the lower corner of a Windows desktop. It’s been part of the UI since Windows 95, and serves to highlight what is happening with the system and the apps that are running on it. At times, Microsoft has tried to call this the “Notification Area”, not be confused with the thing that appears when you press WindowsKey+N (that’s the Notification Center or Action Center).

In common with other bits of Windows (the right-click menu in Explorer being another), it was easy for 3^rd party software and hardware drivers to add their own icons into the “systray”, which might make things convenient for the user until they have 30 or 40 such things cluttering the whole place up. Why wouldn’t you want to quickly control your video modes or tweak Bluetooth settings, after all?

So in sweep-under-the-carpet style, Microsoft added a way of hiding less useful system tray icons so you don’t see them all the time, but they can be exposed by clicking the little arrow to the side.

As you’d expect, Microsoft has defaulted only the more obviously-useful icons to be visible, like battery or Wi-Fi (for laptops), sound/volume etc. OneDrive is jammed in there too, if you have it set up to sync.

To tweak which icons show by default, look in Settings > Personalisation > Taskbar (try right-clicking on a blank bit of the main taskbar and choose Taskbar settings)

Many of the icons you’ll see don’t necessarily do much when you click (left or right) on them, other than jump to the app itself, but some afford the ability to right-click and do something in that app directly. One useful tweak not there by default might be to include Teams, so you can quickly set your status.

To hide or change the clock and date in the System Tray, dive a little further into the Date & time settings…

… and you could have the clock show seconds as well, if you really wanted.

This week’s Copilot-drawn banner image is – clearly – inspired by Eddie/Suzy Izzard’s iconic and lightly sweary “Death Star Canteen” sketch, and the minifig animation of it. Happy Friday – but you’ll still need a tray.