Lynda - Excel: Power Query (Get & Transform)

Lynda - Excel: Power Query (Get & Transform)

Excel 2016 includes a powerful new set of features called Get & Transform, which provides compelling data gathering and cleansing capabilities. Follow along with Excel MVP Oz du Soleil as he shows you the many uses of Get & Transform. Oz begins by explaining what Get & Transform is, and how its data handling features differ from the Excel functions that most people are familiar with. He then shows how to get started with Get & Transform, whether you want to import and work with data from a table, a file, or a folder. Oz also shows how to merge and cleanse data from multiple sources, and how to pivot data to examine your data from a variety of angles.

https://www.lynda.com/Excel-tutorials/Excel-2016-Power-Query-Get-Transform/608994-2.html

Introduction

1. What Is Get & Transform?

2. Working with Queries

3. Working with Columns

4. Working with Formulas

5. Pivoting and Unpivoting Data

6. Grouping

7. Appending a Query

8. Merging Data with Joins

9. Putting It All Together and Applying Your Learning

Table of Contents

Would you like to be a Author?