Cleaning Excel Data With Power Query Straight to the Point

Oz du Soleil

Holy Macro! Books 

Beschreibung

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.

Weitere Titel von diesem Autor

Guerrilla Data Analysis Using Microsoft Excel

Oz du Soleil

18,66 €

Excel Data Cleansing Straight to the Point

Oz du Soleil

7,40 €

Guerrilla Data Analysis Using Microsoft Excel

Oz du Soleil

12,52 €

Guerrilla Data Analysis Using Microsoft Excel

Oz du Soleil

12,49 €

Kundenbewertungen