CARwash: Data cleaning in Excel

  • Event: 2018 CAR Conference
  • Speaker: Mark Nichols of USA TODAY Network
  • Date/Time: Friday, Mar. 9 at 10:15am
  • Location: Michigan/Michigan St
  • Audio file: No audio file available.

Dirty data lurk everywhere: in text files, spreadsheets, databases and PDFs. We'll walk you through some examples of the most common types of dirty data, point out telltale signs of data illness and explain how you can whip data into shape using some simple tools and methods.

This session is good for: People with some experience working with data in columns and rows, in spreadsheets or database managers.

Speaker Bios

  • Mark Nichols is data journalist on the national desk of USA TODAY. He has worked as a data specialist for the digital reporting team at WCPO-TV in Cincinnati, OH, and was the computer-assisted reporting coordinator for The Indianapolis Star for nearly 20 years. @nicholsmarkc

Related Tipsheets

No tipsheets have yet been uploaded for this event.