Excel tips

Having Duplicates in your Data can be a real problem, so addressing them is important. Finding them, especially in a big data set, can often be an arduous task though.

Many of the shortcuts that we teach in Excel can be applied across other applications. 3 of them are almost universal and can be used for just about anything. Ctrl

When manually entering data into Excel we often have the need to copy the value directly from the cell above. Thankfully, there is a shortcut to do just that. Two

Normal copy and paste includes hidden rows and columns, so how do you Copy and Paste just the cells that are visible? Select Visible Cells only before copying. The quick

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