Cleaning Excel Data With Power Query Straight to the Point
| By: | Oz du Soleil |
| Publisher: | Independent Publishers Group (Chicago Review Press) |
| Print ISBN: | 9781615471492 |
| eText ISBN: | 9781615471492 |
| Edition: | 0 |
| Format: | Page Fidelity |
Lifetime - $6.19
eBook Features
Instant Access
Purchase and read your book immediately
Read Offline
Access your eTextbook anytime and anywhere
Study Tools
Built-in study tools like highlights and more
Read Aloud
Listen and follow along as Bookshelf reads to you
Details
Table of Contents
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.