Oz du Soleil – Excel 2016: Power Query (Get & Transform)

Excel 2016: Power Query (Get & Transform)

By: Oz du Soleil

Duration: 1h 49m

Released: August 14, 2017

Description:

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.

Topics include:

• What is Get & Transform?
• Querying data
• Working with columns
• Using formulas
• Pivoting and unpivoting data
• Grouping data
• Appending a query
• Merging/combining data with joins

Contents:

• 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

Author:

Oz du Soleil an Excel MVP, author, and trainer, with a passion for clean data and reliable reporting.

An even greater passion is that of teaching, sharing knowledge, and empowering people to handle their data more efficiently and with greater skill. Over the past 6 years, Oz has been teaching public and private workshops and giving presentations. He has presented at Northwestern University, University of Illinois at Chicago, IgniteChicago, and ExcelTV, and atvarious Excel and data conferences in Toronto; Amsterdam; San Jose; Portland, Oregon; and Chicago, Illinois.
His book, Guerrilla Data Analysis Version 2, condenses some of that knowledge. Through his popular YouTube channel, Excel on Fire, he trains students to use Excel more effectively and access more of Excel’s features. Find out more at http://ozdusoleil.com/.

Get Download Oz du Soleil – Excel 2016: Power Query (Get & Transform) at Forimc.net today!