Excel 2016: Power Query (Get & Transform) – Oz du Soleil
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/.
Access Download Excel 2016: Power Query (Get & Transform) – Oz du Soleil right now!
Delivery Method:
After your purchase, you’ll get access to the downloads page. Here, you can download all the files associated with your order.
Downloads are available once your payment is confirmed, we’ll also send you a download notification email separate from any transaction notification emails you receive from Vinlearn.
