Dirty Data

50 tips to help you turn ugly spreadsheet data into something you can use to get valuable insights into your business and processes in Microsoft Excel. Applicable to versions 2007 through 2019. There are tips for any level users from absolute beginners through advanced Excel users. Some of the problems Dirty Data offers solutions for include: duplicates, non-date date data, connecting multiple related datasets, resolving time zones, and more. The book is chock full of examples in pictures and sprinkled with humor throughout.