Excel Data Cleansing Straight to the Point: Mastering Excel's Data Cleansing Tools with Real-World Strategies
1146719150
Excel Data Cleansing Straight to the Point: Mastering Excel's Data Cleansing Tools with Real-World Strategies
4.99 In Stock
Excel Data Cleansing Straight to the Point: Mastering Excel's Data Cleansing Tools with Real-World Strategies

Excel Data Cleansing Straight to the Point: Mastering Excel's Data Cleansing Tools with Real-World Strategies

by MrExcel's Holy Macro! Books, Oz du Soleil
Excel Data Cleansing Straight to the Point: Mastering Excel's Data Cleansing Tools with Real-World Strategies

Excel Data Cleansing Straight to the Point: Mastering Excel's Data Cleansing Tools with Real-World Strategies

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

eBook

$4.99 

Available on Compatible NOOK devices, the free NOOK App and in My Digital Library.
WANT A NOOK?  Explore Now

Related collections and offers

Product Details

ISBN-13: 9781837026289
Publisher: Packt Publishing
Publication date: 12/17/2024
Sold by: Barnes & Noble
Format: eBook
Pages: 56
File size: 13 MB
Note: This product may take a few minutes to download.

About the Author

Holy Macro! Books has been providing top-quality books on Excel, Power Query, and Power BI since 2002. They have published over 100 titles by 30 authors, including numerous Microsoft MVPs.
Oz du Soleil is an Excel MVP who's been working with Excel since 2001. Oz has several Excel courses on the LinkedIn Learning platform. He's possibly best known for the dramatic and colorful Excel tutorials he posts on his YouTube channel Excel on Fire. Most recently, Oz has presented Excel topics and master classes at conferences in Amsterdam; Sofia, Bulgaria; São Paulo, Brazil; Toronto, Canada; and cities around the United States. When Oz isn't elbows-deep in the guts of a spreadsheet, he does storytelling around Portland, Oregon. He has told stories onstage for Risk!, Pants on Fire, Seven Deadly Sins, Pickathon, The Moth, and other storytelling shows.

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
From the B&N Reads Blog

Customer Reviews