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
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
How To Microsoft Outlook Tech support

Hide recipients in Outlook meeting bookings

Like so many of you, I arrange a fair number of meetings for various purposes. Among these are the ones I arrange for the members of my union local in my capacity as its head. Now, EU – and thus also Norwegian – data protection law clearly categorizes union membership as one of the numerous special categories of personal data. I understand this to mean that I am not allowed to share the membership list with my members.

Categories
How To Tech support

Free text search in ADUC

A critical component to successfully closing a lot of the tickets I handle at work is the ability to search for – and find – Active Directory User, Computer, and Group objects. In about eight of ten instances, I’m able to do so using the standard search types (searching for Users, Contacts, and Groups or Computers). Sometimes, however, I need to find each and every object that has a name containing some predefined string. When that string might be found anywhere in the name, the standard search fails me pretty consistently. Luckily, there is another search type: Custom Search. Here’s how to use it:

Categories
How To Tips & Tricks

A better way of finding users’ group memberships

More than six years ago, I wrote a post, detailing how I could identify users’ Active Directory group memberships. While the method I detailed certainly works, it isn’t as simple as it might have been. Having recently found myself needing to perform that very same task again, I decided to revisit this topic, to show how I did it this time around.

Categories
How To Tips & Tricks

Excel: Calculate percentage

I need to calculate what percentage one number is of another on a relatively regular basis. Luckily, it is relatively easily done using functions in Excel. Here’s how:

Categories
How To Tips & Tricks

Excel: Combine two columns

While analysing an Excel sheet the other day, I needed to combine two columns so that I could get names in the format firstname lastname (the list had been provided as lastname,firstname). As it happens, doing so is relatively easy. You do it on a cell by cell basis, by using basic excel commands.

Categories
How To Tips & Tricks

Improving your Google-fu

Search engines can be a great way of finding what you’re searching for. Using them to their fullest extrent, however, requires a bit of knowledge about how to structure your searches. These examples are some that I use on a regular basis: