Skip to content

Category: Microsoft Excel

Calculating percentage change in Excel

If you do a lot of work in Excel, odds are you’ve needed to calculate a percentage change. Luckily, Excel does this for you quite readily if you simply apply a basic formula of (New Value - Old Value)/Old Value. There is, however, a pitfall that you’ll not get the values you expect if the cell where you’re entering the value is not set to percentage formatting. Hence, here’s a step to step way to make the calculation:

Leave a Comment

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 freezes on 10 MB file

A few months ago, I had a user call in complaining that Excel would freeze and become completely unresponsive when she was working in a specific workbook. It was fairly large (10MB), but well within what the computer should have been able to handle. I opened a remote session to the computer, and started troubleshooting. My first step, as always in these cases, was to look at the event logs, which showed no relevant entries. Next, I inspected one of the files in question.

Leave a Comment