Skip to content

Tag: Excel

Outlook: Mail merge

I have previously written about one of my many responsibilities; contacting users whose login credentials have shown up in breach lists. While the pertinent results of the breach files are delivered to me in a flat file, I use Excel’s Text to Columns feature to separate logins (usually email addresses) from the password. While this might take a little fiddling with the delimiters, it is worth it to ensure that you have a good basis on which to work.

Leave a Comment

Excel: Text to Columns

I work a lot with text files containing data which is, to some degree or another, structured. Whether a breach file from a published breach, or the result of a powershell query such as Get-ADUser, Get-ADComputer, or Get-ADDirectReports, I need to separate the data into columns so that I can work with it. This is where the Text to Columns feature in Excel comes in handy.

Leave a Comment

Excel: Highlight duplicates

Among my many areas of responsibility at work, is contacting all the users found in various data breach lists that our InfoSec team get their hands on (typically, these are the same lists that eventually make their way to HIBP). Not unsurprisingly, there is a significant amount of overlap between some of these lists, and one of the things I do is to ensure that I do not contact users about passwords I’ve already talked to them about.

Leave a Comment

MS Office: Pin items

Many companies, my employer included, uses spreadsheets on a more or less consistent basis in order to track such things as vacation planning and KPI reporting. For me, as an employee, keeping track of these spreadsheets can, from time to time, be a bit annoying. Much to my surprise, at some point in the past few years, Microsoft added a pin item feature to MS Office.

Leave a Comment