Categories
How To Microsoft Excel Tech support Tips & Tricks

Excel: Allow dividing formulas to fail gracefully

I’m sure I’m not alone in having had this happen: I was using Excel to make some quick calculations, and got #DIV/0!-errors for some rows because one of the fields I’d been dividing by was empty. Sometimes you don’t have all the information you need for every single row, but you still want to have a standardised calculation to run where you do have the information you need.

Categories
Opinion

Do not let perfection…

…become the enemy of good.

Categories
Opinion Studies

Anything worth doing…

…is worth doing poorly.

Categories
How To Tips & Tricks

Paste text without formatting

I recently had a long term collaboration with a number of colleagues, where part of what we did was produce, edit, and agree upon finalized versions of text. We applied various formatting such as color, cursive, and bold to track the status of specific text blocks. At the end of it all, we needed to collate the disparate pieces of text into a single document.

Categories
How To Tips & Tricks

Excel: Format cells based on content

As a union steward, one of the many things I do on a regular basis is evaluate key indicators of the company financials. I do this by plotting a few numbers from the accounting reports into Excel, and then run them through some standardised analysis to identify the performance of key indicators. These indicators are evaluated on a five-point scale ranging from “unsatisfactory” to “very good”, and I have set up a total of seven rules using Conditional Formatting to allow me to read the indicators at a glance. Here’s how it’s set up:

Categories
How To Microsoft Excel Tips & Tricks

Excel: Automatically set width and height

If I’ve been there once, I’ve been there a thousand times; I’ve got a spreadsheet in excel with varying widths and heights that don’t fit the data. Now, sure, you could go in and correct it manually – but that’s not only boring, it’s a pain it the behind. Luckily, there are keyboard shortcuts to accomplish it. Here’s how:

Categories
Blog Opinion

Self-hosting revisited

Back in 2018, I wrote about my reasons for hosting my blog on my own site, rather than having it hosted elsewhere. This domain, razumny.no, is in fact my second TLD as my first one was poached (but that is a story for another time), and I’ve had it since at least 2008. All of the reasons I listed back then remain true. Complete editorial control, expanding my competency portfolio, and using the site as a learning tool are all just as relevant to me now as they were almost four years ago, and I remain happy to have migrated off of Blogspot back in 2009.

Categories
How To

Move OneNote notebook to OneDrive

Back in 2019, I wrote about how I was moving to OneNote for all of my notetaking needs, a decision I have yet to regret. I have a few notebooks, set up for different purposes; one which is my rants, ramblings, recipes, and diverse writings of many kinds, one for my job (which makes it easy both to find the information I’m looking for, and to delete it when I change employers), and I recently created one to keep and maintain the documentation I’ve assembled over the years for my Union local.

Categories
How To Microsoft Excel Tips & Tricks

Excel: Merge cells without losing data

If you’ve ever attempted to merge cells that hold data in Excel, you will almost certainly have encountered this warning:

Categories
Opinion review

Reviewed: Horizon: Forbidden West

The much-anticipated sequel to Horizon: Zero Dawn was released back in February. I picked it up, and have been playing it since. Is it as good as its predecessor? Does it live up to the very high expectations I have of it? Is it, simply put, any good? Here goes:

Categories
Microsoft Outlook

Start Outlook in Safe Mode

In last week’s post, I mentioned starting Outlook in Safe Mode. While I didn’t expect it to help, I was at the point where I wanted to ensure I’d tried everything. Simply put, when starting Outlook in Safe Mode, you disable any add-ins that may be installed and causing issues. I’ll leave the question of whether or not it’s a useful tool to have in your bag to you, here’s how you do it: