Categories
How To Microsoft Excel Tech support Tips & Tricks

Excel: Allow dividing formulas to fail gracefully

I’m sure I’m not alone in having had this happen: I was using Excel to make some quick calculations, and got #DIV/0!-errors for some rows because one of the fields I’d been dividing by was empty. Sometimes you don’t have all the information you need for every single row, but you still want to have a standardised calculation to run where you do have the information you need.

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 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 Excel Microsoft Office

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:

Categories
How To Microsoft Outlook Microsoft Outlook Tech support

Set Outlook to only mark as read when you open an email

A while back, a customer complained that Outlook always marked emails as read when he clicked over to another email, and wanted to know if there was a setting that would change this behavior. As it turns out, there is. Here’s how you do it:

Categories
How To Microsoft Outlook Microsoft Outlook Tips & Tricks

Outlook: Disable the send without location prompt

Like many others, my work days are – to some extent – made up of meetings with others. It’s not uncommon for these meetings not to have an assigned meeting room, and I find it annoying that Outlook asks me if I want to enter a meeting location:

Categories
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.

Categories
How To Microsoft Excel Microsoft Office Microsoft Outlook Microsoft Outlook Microsoft Word

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.

Categories
How To Microsoft Outlook Microsoft Outlook

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”:

Categories
How To Microsoft Excel Microsoft Office

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.

Categories
Software Software Spotlight

Software Spotlight: Notepad++

Whenever I get a new (Windows) computer, one of the very first pieces of software I download and install is Notepad++. It gets used for just about anything, and everything, and takes the concept of Notepad, a simple text editor, up a few hundred notches.