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.

After completing the exercises in this book, you will be able to perform the following tasks and more:

Load data from a variety of sources into the data model, using Power Query
Learn how to discover data needed for analysis and visualizations
Use the Query Editor in Power Query to transform data
Merge and append data
Create custom columns and formulas

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.

About the Author

Indera Murphy is an author, retired educator and IT professional that has over 20 years of experience in the Information Technology field. Indera has written over 35 books on software topics including Crystal Reports, Microsoft Office, Power BI Tools, Dashboard Design, Reporting Services, ACT! and OpenOffice.org. She has held a variety of positions including technical writer, programmer, course developer and project leader. Indera has designed and developed software applications and web sites, as well as, manage technology driven projects. In addition to being an Executive Director and consultant, as an online adjunct professor, she has taught courses in a variety of areas including project management, technical writing, information processing, Excel, Access, Crystal Reports, HTML, Windows, Dreamweaver and critical thinking.

"About this title" may belong to another edition of this title.

Store Description

Visit Seller's Storefront

Seller's business information

Edward Bowditch Ltd
Exstowe, Exton, Exeter, EX3 0PP, United Kingdom

Sale & Shipping Terms

Terms of Sale

Legal entity name: Edward Bowditch Ltd
Legal entity form: Limited company
Business correspondence address: Exstowe, Exton, Exeter, EX3 0PP
Company registration number: 04916632
VAT registration: GB834241546
Authorised representative: Mr. E. Bowditch

Shipping Terms

Orders usually dispatched within two working days. Please note that at this time all domestic United Kingdom orders are sent by trackable UPS courier, we choose not to offer a lower cost alternative.