Search

Select theme:

Shopping cart

Subtotal
$97.00
View cart Checkout

Saved articles

You have not yet added any article to your bookmarks!

Browse articles
Newsletter image

Subscribe to the Newsletter

Join 10k+ people to get notified about new posts, news and tips.

Do not worry we don't spam!

GDPR Compliance

We use cookies to ensure you get the best experience on our website. By continuing to use our site, you accept our use of cookies, Privacy Policy, and Terms of Service.

  • Home
Excel Data Cleansing Straight to the Point

Excel Data Cleansing Straight to the Point

By Oz du Soleil Computers 23/07/2019

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

Read More
More Books from Oz du Soleil
Cleaning Excel Data With Power Query Straight to the Point Oz du Soleil
Cleaning Excel Data With Power Query Straight to the Point
Excel Data Cleansing Straight to the Point Oz du Soleil
Excel Data Cleansing Straight to the Point
Guerrilla Data Analysis Using Microsoft Excel Oz du Soleil & Bill Jelen
Guerrilla Data Analysis Using Microsoft Excel
Guerrilla Data Analysis Using Microsoft Excel Bill Jelen & Oz du Soleil
Guerrilla Data Analysis Using Microsoft Excel
Comments