Excel Tips and Tricks

Tired of sorting and then deleting duplicates? Take a look at Remove Duplicates in Excel 2007

IF Error is a cool new function found in Excel 2007. If you do a lot of calculations with denominators of 0 or Vlookups where there is not a match,...

In this video, we determine breakeven using Goal Seek, a what-if analysis tool in Excel.Goal Seek allows you to get the answer you want by changing...