Power BI Tools Volume 6: Quick Start Guide To Learning Power Query For Excel
|By Dr. Indera E. Murphy
Published: June 24, 2017
Price $16.99 US
Table Of Contents
You can buy this book from: Amazon or Barnes & Noble
Power Query is a popular tool for Excel. It easy to learn. The Quick Start Guide To Learning Power Query For Excel book has been designed to have you using the software quickly, by teaching you the basics and more. Each chapter covers new concepts and has exercises to help reinforce the concepts. This book is based on Power Query for Excel 2016.
Power Query is used to automate the process of connecting to and cleaning data that needs to be imported. The data can come from a variety of sources, including spreadsheets, databases and web pages. This free, business intelligence tool provides functionality that Excel does not have.
The Quick Start series of books are for people that are new to a software package and want to take it for a "test drive", as they say. The books in this series will show you how to use some of the most used features of the software, by completing the tasks in each exercise. Topics are explained as you go along, but not in-depth. You will cover enough of the software to know whether or not it will handle a large percent of your needs, without investing weeks of your time, trying to learn about a larger number of features and options. This book will get you up and running quickly, by teaching the basics, so that you can use the software.
Table Of Contents
Chapter 1, Power Query Overview covers background information on Power Query, different versions of Excel, what each tool can be used for, and relevant terminology. This chapter also provides an overview of the Power BI toolset.
Chapter 2, Getting Started With Power Query walks you through the basics of Power Query. The data source options are also covered.
Chapter 3, Getting Started With The Query Editor covers the basics of using the Query Editor.
Chapter 4, Creating Filters, Custom Columns And Formulas covers creating formulas to add data to a table and creating filters for different data types.
Chapter 5, Using The Query Editor To Mash Up Data picks up where Chapter 3 left off. The options on the Transform, Add Column and View tabs on the Query Editor are covered.
Chapter 6, Combining And Grouping Data covers the merge, append, grouping and summarize options.
Power Query Quick Start Guide Home Page | Errata |