What do you think?
Rate this book
Mastering Excel: Power Query
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 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.
68 pages, Kindle Edition
Published February 1, 2016
45 people are currently reading
17 people want to read
About the author
Mark Moore
203 books3 followersLibrarian note:
There is more than one author in the GoodReads database with this name
This profile may contain books from multiple authors of this name.
There is more than one author in the GoodReads database with this name
This profile may contain books from multiple authors of this name.
Ratings & Reviews
Friends & Following
Create a free account to discover what your friends think of this book!
Community Reviews
Displaying 1 - 3 of 3 reviews
June 9, 2018
Simple, clear, no nonsense book that cuts right to the chase.
This book won't bore you with a long story of what behind the scenes before it teaches you something useful. It cuts to the chase, remains succinct throughout and still manages its goal of making you familiar and functional with Power tools. The language is simple, clear and light hearted. Although, you won't learn some advanced features in great detail, it's still is a good starting point for people to get familiar with the basics thoroughly first. For a great deal, you won't even be needing those advanced features. What you learn in this book should suffice most of your needs.Greatby the author. We need more books like these.
This book won't bore you with a long story of what behind the scenes before it teaches you something useful. It cuts to the chase, remains succinct throughout and still manages its goal of making you familiar and functional with Power tools. The language is simple, clear and light hearted. Although, you won't learn some advanced features in great detail, it's still is a good starting point for people to get familiar with the basics thoroughly first. For a great deal, you won't even be needing those advanced features. What you learn in this book should suffice most of your needs.Greatby the author. We need more books like these.
March 14, 2021
Fantastic as usual
Mark Moore consistently puts out great books that will get you up to speed quickly from zero to competent or better. Begin all your learning journeys with Mark Moore!
Mark Moore consistently puts out great books that will get you up to speed quickly from zero to competent or better. Begin all your learning journeys with Mark Moore!
February 16, 2016
A succinct and thorough overview
Power Query has a lot of capabilities and this brief lesson is a good overview. It's not exhaustive, but serves as a good launch-pad for further learning.
Power Query has a lot of capabilities and this brief lesson is a good overview. It's not exhaustive, but serves as a good launch-pad for further learning.
Displaying 1 - 3 of 3 reviews