Normal view MARC view ISBD view

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
Contents:
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.
Summary: 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.
Item type Home library Call number URL Status Notes Date due Barcode Item reserves
EBook EBook International
ProQuest eBook (Browse shelf) Link to resource eBook Available as an ebook here
Total reserves: 0

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.

Click on an image to view it in the image viewer

© 2017 Chartered Accountants Australia and New Zealand ABN 50 084 642 571 (CA ANZ).
Formed in Australia. Members of CA ANZ are not liable for the debts and liabilities of CA ANZ

Powered by Koha

Powered by Koha