Skip to content

Category: Software

Replacing Premiere Pro

When I wrote my series on a video editing workflow back in 2017, I had settled on Adobe Premiere Pro as my video editing suite of choice. Despite the rather hefty price tag, I felt the toolset it provided me with – particularly the ability to synchronise clips based on audio profile – was worth it. Since then, I started encountering some usability bugs when editing clips from certain cameras, and let multi-cam support be multi-cam support, replacing it entirely with iMovie.

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

Outlook: Offline Mode

From time to time, I need to run Outlook in Offline Mode. This is usually the case when I want to ensure that a mail merge has worked successfully. It is also a good option to reduce data usage when on mobile networks. Going to Offline Mode is straight forward. In Outlook, go to the Send/Receive tab, and then click “Work Offline”:

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

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

Farewell Bear, hello … OneNote?

In December of 2016, I discovered Bear Writer. At the time, I had been using a number of different solutions for note-taking and organisation, none of which had really done the trick for me. That all changed with Bear. Arriving to critical acclaim, Bear is certainly a very pretty app, and its iCloud sync feature has served me well enough. There has just been one issue; it is only available on Apple devices.

Leave a Comment

Outlook: Not all folders are synced

Shared email boxes are a useful tool for departments needing to have a single point of contact, but whose needs do not extend so far as to need a CRM or ticket management tool. I’ve talked before about how to add them to Outlook, in which I noted that I usually uncheck the box for downloading shared folders to avoid downloading what tends to be a huge mail box, which will lock up Outlook. Another reason to do so, is that a locally cached mail box often does not display all mails and folders, a complaing I see from time to time. It has been my experience that most users leave the settings in their default state, so today, I thought I’d tell you how to disable that retroactively:

Leave a Comment