Excel Tip: Easy Way to Find Duplicate Items in a Column

Posted on 20. Apr, 2012 by in VirtualConnections Newsletter, Windows Resources/Tips

If you find yourself always merging worksheets of client data and know that there must be duplicates, here is an easy way to find those duplicate entries. Select the range of cells On the menu bar, click on format, conditional formatting Under Condition 1, select Formula is In the formula =Countif (column range you are [...]

Continue Reading →

Excel Tip: Quickly Enter the Date and/or Time

Posted on 12. Apr, 2012 by in VirtualConnections Newsletter, Windows Resources/Tips

Want a way to quickly enter today’s date?  Press Control + ; (Ctrl and semicolon simultaneously). Now if you also need to enter the time just press Control + Shift + : (Ctrl, shift, colon simultaneously). Another way to get the most of those keyboard shortcuts.

Continue Reading →

Excel Tip: Quickly Add Values in Cells

Posted on 13. Feb, 2012 by in VirtualConnections Newsletter, Windows Resources/Tips

You are working on a fairly large spreadsheet and you just want to know the total of a certain group of numbers, perhaps of one product available in different sizes or sales numbers for a particular customer. There is a quick way to get the value without having to key in a formula. Click once [...]

Continue Reading →

Excel Tip of the Month: Formatting Cells

Posted on 28. Jul, 2011 by in VirtualConnections Newsletter, Windows Resources/Tips

Do you add data into Excel and it contains extra spaces that you do not need? Or do you need to display numbers in a different format than how they currently appear? To remove ALL spaces from a cell (as the TRIM function leaves one space in the middle) using Find and Replace. Select the [...]

Continue Reading →

MS Excel Tip: Delete Duplicate Rows from a List in Excel

Posted on 15. Jun, 2010 by in VirtualConnections Newsletter, Windows Resources/Tips

A duplicate row (also called a record) in a list is one where all values in the row are an exact maatch of all the values in another row. To delete duplicate rows, you need to filter a list for unique rows, delete the original list, and then replace it with the filtered list. The [...]

Continue Reading →