Excel tips

Where would we be without Copy and Paste? Probably way behind schedule, or should I say, further behind schedule than we are currently! 😊 In Excel, Copy and Paste copies

Data dumps from 3rd party systems often give us data with a plethora (lots of) blank rows. Finding and Deleting these Rows can take an age. Not any more though!

Many of the cool features in Excel auto-detect data ranges to function, such as Filters, Flash-Fill and Pivots, to name but a few. Considering this, it’s really important that we

There is a basic rule of thumb in the Windows environment. Dragging something will move it; dragging while holding down the control key will create a copy. Unbeknown to many,

Most times using a keyboard shortcut is quicker than using a mouse. Sometimes though, it’s a nifty combination of the two that does the trick! Let’s look at the quickest

Inserting an additional column is something we often need to do and the whole right-click insert thing is quite cumbersome. The trick to doing this without your mouse is to

Navigating lots of Excel worksheets? hover-over of your Worksheet Scroll arrows to reveal two more very useful tips! Ctrl + Left Click on the right arrow shoots to the last

In Excel, subtracting an Earlier Date from a Later Date will calculate the number of Days in between – which can be very useful. However, we may need to calculate

We often receive data where the Date Format is incorrect and subsequently does not load as a genuine date. (Remember, a Date is numeric, so should align to the right)

It’s always a good idea to store ID Numbers as Text, especially as some can start with a leading zero. In this article we focus on displaying I.D numbers correctly

It’s pretty well known that the first 6 digits of your South African ID Number is your Date of Birth. Un-beknown to many though, the SA ID Number has a

As more and more Millennials creep into our Databases it’s important that we beef up our Formula and learn about extracting D.O.B’s from ID’s. With just a 2-digit year, the