Cleaning excel data with power query straight to the point
(2019)

Nonfiction

eBook

Provider: hoopla

Details

PUBLISHED
[United States] : Holy Macro! Books, 2019
Made available through hoopla
DESCRIPTION

1 online resource

ISBN/ISSN
9781615471492 (electronic bk.) MWT12381874, 1615471499 (electronic bk.) 12381874
LANGUAGE
English
NOTES

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

Mode of access: World Wide Web

Additional Credits