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