Mastering Excel

Power Query

By:

Mark Moore

Format:

Paperback / softback

Series:

Mastering Excel

Show Hide Adult Content

$41.99 was ~~$51.99~~

Available from supplier

Usually ships in 3-4 weeks

0 in Trolley

Price Match

Wrap this item as a gift ($5.90) - add a free gift card on the next page

Buy Now, Pay Later with:

Afterpay is available on orders $100 to $2000 Learn more

Availability

Delivering to:

Estimated arrival:

Around 14-26 June using International Courier

Description

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.

Release date Australia

May 23rd, 2017

Author

Mark Moore

Series

Mastering Excel

Pages

Audience

General (US: Trade)

Dimensions

152x229x4

ISBN-13

9781546909071

Product ID

37421018

Customer reviews

Nobody has reviewed this product yet. You could be the first!

Write a Review

Marketplace listings

There are no Marketplace listings available for this product currently.
Already own it? Create a free listing and pay just 9% commission when it sells!

Sell Yours Here