Original price was: $36.00.Current price is: $15.00.

In Stock

Digital Download: You will receive a download link via your order email

Purchase this course you will earn 15 Points worth of $1.50!


Buy Oz du Soleil – Excel 2016: Power Query (Get & Transform) Course at esyGB. You will have immediate access to the digital downloads in your account or your order email.

Excel 2016: Power Query (Get & Transform)

By: Oz du Soleil

Duration: 1h 49m

Released: August 14, 2017


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


  • 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


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!

Archive: https://web.archive.org/web/20170828202441/https://www.lynda.com/Excel-tutorials/Excel-2016-Get-Transform/608994-2.html

Delivery Method

– After your purchase, you’ll see a View your orders link which goes 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 esy[GB].
– Since it is a digital copy, our suggestion is to download and save it to your hard drive. In case the link is broken for any reason, please contact us and we will resend the new download link.
– If you cannot find the download link, please don’t worry about that. We will update and notify you as soon as possible at 8:00 AM – 8:00 PM (UTC+8).

Thank You For Shopping With Us!

Buy the Oz du Soleil – Excel 2016: Power Query (Get & Transform) course at the best price at esy[GB]. Upon completing your purchase, you will gain immediate access to the downloads page. Here, you can download all associated files from your order. Additionally, we will send a download notification email to your provided email address.

Unlock your full potential with Oz du Soleil – Excel 2016: Power Query (Get & Transform) courses. Our meticulously designed courses are intended to help you excel in your chosen field.

Why wait? Take the first step towards greatness by acquiring our Oz du Soleil – Excel 2016: Power Query (Get & Transform) courses today. We offer a seamless and secure purchasing experience, ensuring your peace of mind. Rest assured that your financial information is safeguarded through our trusted payment gateways, Stripe and PayPal.

Stripe, known for its robust security measures, provides a safe and reliable payment process. Your sensitive data remains confidential throughout the transaction thanks to its encrypted technology. Your purchase is fully protected.

PayPal, a globally recognized payment platform, adds an extra layer of security. With its buyer protection program, you can make your purchase with confidence. PayPal ensures that your financial details are safeguarded, allowing you to focus on your learning journey.

Is it secure? to Use of?
  • Your identity is kept entirely confidential. We do not share your information with anyone. So, it is absolutely safe to buy the Oz du Soleil – Excel 2016: Power Query (Get & Transform) course.
  • 100% Safe Checkout Privateness coverage
  • Communication and encryption of sensitive data.
  • All card numbers are encrypted using AES with a 256-bit key at rest. Transmitting card numbers occurs in a separate hosting environment and does not share or store any data.
How can this course be delivered?
  • After your successful payment this “Oz du Soleil – Excel 2016: Power Query (Get & Transform) course”, Most of the products will come to you immediately. But for some products were posted for offer. Please wait for our response, it might take a few hours due to the time zone difference.
  • If this occurs, please be patient. Our technical department will process the link shortly after, and you will receive notifications directly via email. We appreciate your patience.
What Shipping Methods Are Available?
How Do I Track Order?
  • We promptly update the status of your order after your payment is completed. If, after 7 days, there is no download link, the system will automatically process a refund.
  • We value your feedback and are eager to hear from you. Please do not hesitate to reach out via email us with any comments, questions and suggestions.
0 Cart
Oz du Soleil Excel 2016 Power Query Get Transform 250x343 1 | eSy[GB]
Oz du Soleil – Excel 2016: Power Query (Get & Transform)
Original price was: $36.00.Current price is: $15.00. Add to cart