Skip to main content
Have a personal or library account? Click to login
Excel Data Cleansing Straight to the Point Cover

Excel Data Cleansing Straight to the Point

Mastering Excel's Data Cleansing Tools with Real-World Strategies

Publisher:Packt Publishing Limited
By:  and    
Paid access
|Mar 2025
Product purchase options
Table of contents

Table of Contents

  1. Introduction
  2. Correcting Names: Proper Case
  3. Comparing Lists: What's Over Here That's Not Over There?
  4. Peeling, Parsing, and Segmenting
  5. Identifying Duplicate Records: Fuzzy Matching
  6. Merging and Appending Multiple Workbooks
  7. From Useless to Useful: Flattening a Report
  8. Final Thoughts
PDF ISBN: 978-1-83702-628-9
Publisher: Packt Publishing Limited
Copyright owner: © 2024 Packt Publishing Limited
Publication date: 2025
Language: English
Pages: 56
Related subjects:
Computer sciences,
Databases and data mining

People also read

Book

Cleaning Excel Data With Power Query Straight to the Point

MrExcel's Holy Macro! Books, Oz du Soleil
Book

Guerrilla Data Analysis Using Microsoft Excel

MrExcel's Holy Macro! Books, Oz du Soleil, Bill Jelen
Book
New

Excel

Rheinwerk Publishing, Inc, Helmut Vonhoegen
Book

Your Excel Survival Kit

MrExcel's Holy Macro! Books, Anne Walsh
Book
New

Excel Crash Course

Vinai Prakash
Book

Power Excel with MrExcel

MrExcel's Holy Macro! Books, Bill Jelen
Book

Excel Insights

MrExcel's Holy Macro! Books, 24 Excel MVPs
Book

More Excel Outside the Box

MrExcel's Holy Macro! Books, Bob Umlas
Book

Excel Power Moves

MrExcel's Holy Macro! Books, Bob Umlas
Book

Don't Fear the Spreadsheet

MrExcel's Holy Macro! Books, Tyler Nash, Bill Jelen, Kevin Jones, Tom Urtis