Blog

  • Specific search sites for better* results

    I’ve been a user of computers and the internet for long enough to remember the first browser war. It used to be that I’d regularly use multiple search engines in order to ensure that I got the best* results. My defaults would be Yahoo, AltaVista, and Kvasir, but others were certainly in the mix, too. Over time, however, most of these were replaced by Google. As a student, my exprience was that Google usually provided “more or less close enough”, rather than “exactly what I need”, and as your search gets more specialized, Googles results tend to get less useful.

    (more…)
  • Excel: Looking up data continued

    Last week, I showed you the simplest form of the XLOOKUP function. Though highly useful, it’s only really useful if you find exact matches. If you’re looking at an array of data – e.g. pay averages for age groups instead of specific ages – you need to help it a little. To this end, the function has a further three arguments. In order, the ones I’ve found useful are:

    (more…)
  • Excel: Looking up data

    A while back, I showed you how I go about creating tables if average values using the UNIQUE and AVERAGEIF functions. While those tables are valuable in and of themselves, I use them to compare the pay an individual in my group gets with people in the same part of the organization.

    (more…)
  • Mac: Lock your computer

    There are a number of security best practices out there. The most basic include password-protecting your devices and limiting administrative privileges. Password protection is only effective when your device is locked. While I’ve mostly been a Windows user at work, at home I tend to prefer a Mac.

    (more…)
  • Excel: Calculating days, months, and years

    One thing I find myself needing to do on a relatively regular basis, is calculate the number of days, months, or years between two given dates. Like with so many other things, Excel has a function for this, too. It’s intuitively named DATEDIF, and here’s how you use it.

    (more…)
  • Tradition!

    In the opening act of Fiddler on the roof, Tevye and the other characters sing about the importance of tradition in their daily lives. While more than a hundred years have gone by since its setting in 1905, tradition remains important. It’s important to all of us, for so many reasons. Traditions are one of the many ways in which we pass on our joint knowledge of who we are as people. This week, I’d like to share some of my traditions.

    (more…)
  • PowerShell: Looking up specific user properties

    Many of my customers use specific properties for various things. Most users do not have ADUC installed, and some of our customers even disallow installation of ADUC on end user computers. I recently had a user ask about looking up the contents of a specific attribute (extensionAttribute6, in case you were wondering).

    (more…)
  • Excel: Find average based on multiple criteria

    Last week, I showed you how to find an average based on a single criterion. That works well enough, but what if you want to find an average based on multiple criteria? In that case, the AVERAGEIF-function will fall short. In its place, you must use the AVERAGEIFS-function. This time, we want to find the averages for both ALPHA and BRAVO.

    (more…)
  • Excel: Finding averages based on a specified criterion

    One of the many things I do in my capacity as a union representative is to assemble my own statistics based on raw numbers I get from my employer. One of the stats I calculate is the average pay in each section. As you might remember, last week I assembled a list of forty seven unique codes.

    (more…)
  • Excel: Finding unique values

    In complex datasets, finding the unique values can sometimes be a bit of a challenge. While you can often simply remove duplicates, if you intend to create a lookup-table, that isn’t an option, and you need to do it differently. Enter the UNIQUE-function.

    (more…)
  • Excel: Adding multiple axes in a chart

    One of the many things I do as a union representative, is negotiate wages with management. I argue my point using a number of tools, not least of which is the change in pay over time. I have one set of data which is what we use when negotiating, which represents the estimated change. I have another set which represents the actual change. I wanted to show not only these in relation to each other, but also the relative difference as it changes over time.

    (more…)