Excel Data Cleansing Straight to the Point
Excel Data Cleansing Straight to the Point

Excel Data Cleansing Straight to the Point

Straight to the Point

COMPUTERS

48 Pages, 8 x 10

Formats: ebook: EPUB

ebook: EPUB, $4.95 (US $4.95) (CA $6.95)

Publication Date: July 2019

ISBN 9781615471508

eBook

eBook Editions Available

Will it work on my eReader?
Price: $4.95
NOTE: You are attempting to order an e-book. Please see will it work on my eReader? for directions on how to enjoy this book on your eReader device.
 
add ebook to cart
 

Overview

This Straight to the Point guide provides an introduction to data cleansing, which also goes by names such as data munging and data wrangling. Whatever the name, it basically means doing what needs to be done to make data useful and trustworthy. Data cleansing can include the following tasks:Deleting unnecessary headersDeleting summary rowsFilling in gapsFlattening a reportMerging and appending data from multiple sourcesPulling data from source X to complete data in source YSplitting names from addressesIdentifying and deleting duplicate recordsConverting units of measurement in multiple sources

Author Biography

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.

Need Help with
Your Order?

Contact IPG:

1-800-888-4741

orders@ipgbook.com

Need Help with
Your Order?

Contact IPG:

1-800-888-4741

orders@ipgbook.com