Excel data cleansing : straight to the point / by Oz du Soleil
By: du Soleil, Oz.Publisher: Merritt Island, F.L. : Holy Macro! Books, 2019Description: 49 p. : ill. ; electronic resource.ISBN: 9781615471508.Subject(s): Excel | Data | SpreadsheetsOnline resources: Download as an eBook
|Item type||Home library||Call number||URL||Status||Notes||Date due||Barcode||Item reserves|
|EBook||International||ProQuest eBook (Browse shelf)||Link to resource||eBook||Available as an ebook here|
Correcting names: proper case -- Comparing lists: what's over here that's not over there? -- Peeling, parsing, and segmenting -- Identifying duplicate records: fuzzy matching -- Merging and appending multiple workbooks -- From useless to useful: flattening a report.
Offers a guide to data cleansing to make data useful and trustworthy. Includes how to delete unnecessary headers and summary rows, merge data from multiple sources, and delete duplicate records.