Microsoft Excel might be the accountant's right hand that lives in the shadows, but it is incredibly useful for a lot more than number-crunching. I prefer using visual data management tools, such as ...

Quick LinksSplit Cells by Delimiter to Isolate ValuesReplace Errors for Use in CalculationsUnpivot Data to Aid AnalysisFill Blank Cells Based on the Cell Above (Or Below)Have you heard of Power Query ...