Mastering Excel: Power Query - Paperback

Mastering Excel: Power Query - Paperback

$20.52
Skip to product information
Mastering Excel: Power Query - Paperback

Mastering Excel: Power Query - Paperback

$20.52

by Mark Moore (Author)

Import data from text files, other Excel files, databases, web pages, Facebook, even entire folders of files using Power Query.Excel is the most accessible program for data analysis. Power Query (also known as Get & Transform) takes that one step further. The first step of any data analysis project is importing the data. Related to that, you must clean and standardize the data (aka ETL: Extract, Transform and Load)Power Query has all that covered. You will learn to set up Power Query for connecting Excel to all kinds of data sources, performing hundreds of ETL tasks and loading clean data into your worksheet. Power Query can extract data from columns, join columns, remove duplicates, skip errors, join tables, the list is almost endless.Additionally, Power Query is set up to remember all the steps you performed and it will redo them with a single click of a button.Learn to use Power Query and save yourself hours of work.

Number of Pages: 68
Dimensions: 0.14 x 9 x 6 IN
Publication Date: May 23, 2017

Made with care

Great value

Elegant design

Quality materials

Details

This product is crafted with quality materials to ensure durability and performance. Designed with your convenience in mind, it seamlessly fits into your everyday life.

Shipping & Returns

We strive to process and ship all orders in a timely manner, working diligently to ensure that your items are on their way to you as soon as possible.

We are committed to ensuring a positive shopping experience for all our customers. If for any reason you wish to return an item, we invite you to reach out to our team for assistance, and we will evaluate every return request with care and consideration.

Play video

Shop The Full Collection

!Ah y Le Lo Lay, Le Lo Ley! Musica Tipica de Puerto Rico - Paperback

!Búscalo! (Look It Up!): A Quick Reference Guide to Spanish Grammar and Usage - Hardcover

!Búscalo! (Look It Up!): A Quick Reference Guide to Spanish Grammar and Usage - Paperback

!LETTER TO THE UNITED NATIONS! !REPARATIONS NOW! The Many Reasons Why: St. Mark's-in-the-Bowery Church, The Dutch Royal Family, The Kingdom of the Net - Paperback