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
Cleaning Excel Data With Power Query Straight to the Point

Cleaning Excel Data With Power Query Straight to the Point

By Oz du Soleil Computers 01/03/2019

Author Oz Du Soleil's area of frustration with Excel is cleaning data. From his earliest days with Excel, he has found himself constantly needing to fix names that are ALLCAPS, peel addresses away from phone numbers, and fixing all the many other things that prevent data from being useful. In this intro to Power Query, Oz shows you five core techniques in Excel Power Query: Splitting data, Filling blanks, Joining data sets, grouping and summarizing, and adding columns using Column From Examples.

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