Cleaning Excel Data With Power Query Straight to the Point
(eBook)
Author:
Contributors:
Published:
[United States] : Holy Macro! Books, 2019.
Format:
eBook
Content Description:
1 online resource (52 pages)
Status:
Description
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.
More Details
Language:
English
ISBN:
9781615471492, 1615471499
Notes
Restrictions on Access
Instant title available through hoopla.
Description
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.
System Details
Mode of access: World Wide Web.
Reviews from GoodReads
Loading GoodReads Reviews.
Citations
APA Citation (style guide)
du Soleil, O. (2019). Cleaning Excel Data With Power Query Straight to the Point. Holy Macro! Books.
Chicago / Turabian - Author Date Citation (style guide)du Soleil, Oz. 2019. Cleaning Excel Data With Power Query Straight to the Point. Holy Macro! Books.
Chicago / Turabian - Humanities Citation (style guide)du Soleil, Oz, Cleaning Excel Data With Power Query Straight to the Point. Holy Macro! Books, 2019.
MLA Citation (style guide)du Soleil, Oz. Cleaning Excel Data With Power Query Straight to the Point. Holy Macro! Books, 2019.
Note! Citation formats are based on standards as of July 2022. Citations contain only title, author, edition, publisher, and year published. Citations should be used as a guideline and should be double checked for accuracy.
Staff View
Grouped Work ID:
7ae4a9fd-3cbf-a08e-5c29-85c7058a4d34
Hoopla Extract Information
| hooplaId | 12381874 |
|---|---|
| title | Cleaning Excel Data With Power Query Straight to the Point |
| language | ENGLISH |
| kind | EBOOK |
| series | |
| season | |
| publisher | Holy Macro! Books |
| price | 0.34 |
| active | 1 |
| pa | |
| profanity | |
| children | |
| demo | |
| duration | |
| rating | |
| abridged | |
| fiction | |
| purchaseModel | INSTANT |
| dateLastUpdated | Sep 25, 2024 06:31:35 PM |
Record Information
| Last File Modification Time | Aug 02, 2025 10:53:32 PM |
|---|---|
| Last Grouped Work Modification Time | Aug 02, 2025 10:23:36 PM |
MARC Record
| LEADER | 02188nam a22004575i 4500 | ||
|---|---|---|---|
| 001 | MWT12381874 | ||
| 003 | MWT | ||
| 005 | 20250725070802.0 | ||
| 006 | m o d | ||
| 007 | cr cn||||||||| | ||
| 008 | 250725s2019 xxu eo 000 0 eng d | ||
| 020 | |a 9781615471492 |q (electronic bk.) | ||
| 020 | |a 1615471499 |q (electronic bk.) | ||
| 028 | 4 | 2 | |a MWT12381874 |
| 029 | |a https://d2snwnmzyr8jue.cloudfront.net/ipg_9781615471492_180.jpeg | ||
| 037 | |a 12381874 |b Midwest Tape, LLC |n http://www.midwesttapes.com | ||
| 040 | |a Midwest |e rda | ||
| 099 | |a eBook hoopla | ||
| 100 | 1 | |a du Soleil, Oz, |e author. | |
| 245 | 1 | 0 | |a Cleaning Excel Data With Power Query Straight to the Point |h [electronic resource] / |c Oz Du Soleil. |
| 264 | 1 | |a [United States] : |b Holy Macro! Books, |c 2019. | |
| 264 | 2 | |b Made available through hoopla | |
| 300 | |a 1 online resource (52 pages) | ||
| 336 | |a text |b txt |2 rdacontent | ||
| 337 | |a computer |b c |2 rdamedia | ||
| 338 | |a online resource |b cr |2 rdacarrier | ||
| 347 | |a text file |2 rda | ||
| 506 | |a Instant title available through hoopla. | ||
| 520 | |a 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. | ||
| 538 | |a Mode of access: World Wide Web. | ||
| 630 | 7 | |a Microsoft Excel (Computer file) | |
| 650 | 0 | |a Business |x Computer programs. | |
| 650 | 0 | |a Electronic spreadsheets |x Computer programs. | |
| 650 | 0 | |a Business. | |
| 650 | 0 | |a Business intelligence. | |
| 650 | 0 | |a Computers. | |
| 650 | 0 | |a Electronic spreadsheets. | |
| 650 | 0 | |a Electronic books. | |
| 710 | 2 | |a hoopla digital. | |
| 856 | 4 | 0 | |u https://www.hoopladigital.com/title/12381874?utm_source=MARC&Lid=hh4435 |z Instantly available on hoopla. |
| 856 | 4 | 2 | |z Cover image |u https://d2snwnmzyr8jue.cloudfront.net/ipg_9781615471492_180.jpeg |