Category: 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. A simple combination of Conditional Formatting with Filters is a great way to highlight and track down those Duplicates. The basic steps are as follows: […]

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 + N – to create a New Workbook, Document, Email, Presentation etc Ctrl + O – to Open an existing Workbook, Document, Email, Presentation etc […]

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 in fact! ctrl + “ just the value ctrl + D copies the value and the formatting Both have their advantages, depending on your requirements. […]

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 guide… Select the range you want to copy (ctrl + A) Call up Go To (Ctrl + G) Click on the Special… button bottom left […]

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 everything by default… except column widths! This can be a little frustrating especially if that is one of the key things you require to copy. […]

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! This cool tip will show you how to use the Go To Special… Blanks feature to detect and delete all these unwanted rows in a […]

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 store our data in such a way that an Excel Range can be detected without any issues. Simply put, our Data should be stored in […]

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, this simple principle works across most applications, including Excel and is easy to use when trying to duplicate a worksheet. If I use my mouse […]

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 way to a move a column in Excel. The standard way of moving a column within a range of data is to right-click on the […]

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 […]