Blog

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 employ a Keyboard Shortcut combo… Ctrl + Spacebar to select the column of your current Active cell and Ctrl + “+”                to insert a […]

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 Sheet. (Ctrl + Left click on the left arrow will shoot back to the First one)Right Clicking on either arrow gives you a Pop-up Contents […]

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 the number of Working Days between two Dates. If that is the case then NETWORKDAYS() is your goto function.  (Makes more sense if you read […]

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) Which brings us to the topic of fixing incorrect dates. Trying to force it to be Date using the Short Date Format does not work […]

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 in Excel. The problem though, is that if you convert cells with large numbers to Text it displays it in Scientific Notation. E.g. 8605065397083 displays […]

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 few other Personal Details hidden within its 13 digits! In this article we look at validating an SA ID number on and Excel spreadsheet. This […]

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 (Date of Birth) from ID’s. With just a 2-digit year, the Excel Date function assumes the 1900s. As a result, the ID Number of someone born after the year 2000 converts to a […]

A client of ours once accidentally deleted all their respective Client Birthdays. They were incredibly relieved when they were introduced to the following MS Excel Formula: Simply copy and paste the above formula into cell A2 of an Excel Spreadsheet, pop your ID Number into cell A1 and it will extract the D.O.B. Download the […]

When we capture a South African ID Number, Excel recognizes it as numeric and displays it to the right of the cell. Up until recently this has not been an issue, but as Generation-Z, or more specifically those born between 2000 and 2009, start creeping into our Databases it has now become a problem. For […]