Cleaning Excel Data With Power Query Straight to the Point: Efficient Data Cleaning Techniques in Excel Using Power Query
1146695839
Cleaning Excel Data With Power Query Straight to the Point: Efficient Data Cleaning Techniques in Excel Using Power Query
4.99 In Stock
Cleaning Excel Data With Power Query Straight to the Point: Efficient Data Cleaning Techniques in Excel Using Power Query

Cleaning Excel Data With Power Query Straight to the Point: Efficient Data Cleaning Techniques in Excel Using Power Query

by MrExcel's Holy Macro! Books, Oz du Soleil
Cleaning Excel Data With Power Query Straight to the Point: Efficient Data Cleaning Techniques in Excel Using Power Query

Cleaning Excel Data With Power Query Straight to the Point: Efficient Data Cleaning Techniques in Excel Using Power Query

by MrExcel's Holy Macro! Books, Oz du Soleil

eBook

$4.99 

Available on Compatible NOOK devices, the free NOOK App and in My Digital Library.
WANT A NOOK?  Explore Now

Related collections and offers

Product Details

ISBN-13: 9781837026180
Publisher: Packt Publishing
Publication date: 12/12/2024
Sold by: Barnes & Noble
Format: eBook
Pages: 60
File size: 8 MB

About the Author

Holy Macro! Books has been providing top-quality books on Excel, Power Query, and Power BI since 2002. They have published over 100 titles by 30 authors, including numerous Microsoft MVPs.
Oz du Soleil is an Excel MVP who's been working with Excel since 2001. Oz has several Excel courses on the LinkedIn Learning platform. He's possibly best known for the dramatic and colorful Excel tutorials he posts on his YouTube channel Excel on Fire. Most recently, Oz has presented Excel topics and master classes at conferences in Amsterdam; Sofia, Bulgaria; São Paulo, Brazil; Toronto, Canada; and cities around the United States. When Oz isn't elbows-deep in the guts of a spreadsheet, he does storytelling around Portland, Oregon. He has told stories onstage for Risk!, Pants on Fire, Seven Deadly Sins, Pickathon, The Moth, and other storytelling shows.

Table of Contents

Table of Contents
  1. Introduction
  2. First, Some Background for Power Query
  3. Getting Data into Power Query
  4. Fill Up and Fill Down
  5. Parsing Text
  6. Sorting in Power Query
  7. Merging Data: Joining and Appending
  8. Grouping Data
  9. Refreshing and Updating Data
  10. Adding Columns
  11. Unpivoting Data
  12. Conclusion
From the B&N Reads Blog

Customer Reviews