Unlock Your Potential with the Oz du Soleil – Excel 2016: Power Query (Get & Transform) course only Original price was: $36.00.$15.00Current price is: $15.00. on CoursesGB!
At CoursesGB, we provide over 60,000 downloadable digital courses designed for your personal and professional growth. Get expert-guided, self-paced learning at an unbeatable value – often over 80% off original prices. The Oz du Soleil – Excel 2016: Power Query (Get & Transform) offers practical insights and proven strategies for all skill levels.
Enroll now and elevate your learning with CoursesGB!
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!
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!
Unlock Lifetime Learning and Career Growth with the Oz du Soleil – Excel 2016: Power Query (Get & Transform) course only Original price was: $36.00.$15.00Current price is: $15.00. at CoursesGB!
Invest in your future with the Oz du Soleil – Excel 2016: Power Query (Get & Transform) course at CoursesGB and gain immediate, lifetime access to expertly crafted digital content designed to boost your career and personal development. As a leading platform for downloadable courses, we offer unparalleled value and convenience.
Why Choose CoursesGB?
- Lifetime Access: Enjoy unlimited access to your purchased courses, forever.
- Massive Savings: Get top-tier courses at prices up to 80% lower than original sales pages.
- Secure Payments: Shop with confidence using our secure payment methods (PayPal, Stripe).
- Practical Knowledge: Empower your career with actionable, real-world skills from over 60,000 diverse courses.
- Instant Access: Start learning immediately after purchase via your account dashboard or email for most courses.
- Learn Anywhere: Access your courses seamlessly on any device (desktop, mobile, tablet).
Start your learning journey today and discover the CoursesGB advantage!



