Quick Start Guide To Learning Power Query For Excel

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.

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.