Excel - Power Query for the Everyday Excel User

Excel - Power Query for the Everyday Excel User - Part 2

Image credit: ComplianceIQ 2022

Schedule Monday, January 9, 2023 || 10:00 AM PDT | 01:00 PM EDT

Duration 60 Mins

Level Basic & Intermediate

Webinar ID IQW22E0527

What you'll learn?
Add to Wishlist

Calculations without formulas – the power of The Query Editor Ribbon
Combining data using Append & Merge Queries (and the difference between them)
Convert a single text string into multiple rows
Unpivot – the hidden gem and unsung hero of The Query Editor

Overview of the webinar

This is a follow-on session to " Excel - Power Query – No Code Automation Every User Needs – Part 1" and covers the key advanced features of Excel’s Query Editor, designed to help you transform imported data quickly and without having to learn to code.

The focus of this training is on how to create additional columns without complex formulas and how to combine, merge and unpivot unusable data to make it report-ready.

Who should attend?

This training is aimed at users of Excel who wish to learn about the advanced features of the Power Query Editor. Attendees should already have a good understanding of how to import data and create simple Queries.

Why should you attend?

Power Query / Get and Transform can save you a ton of time when working with imported data. In many cases when you get data from external sources, it needs work on it before it can be used. Although this can be done using Excel functionality, Power Query / Get and Transform is a lot faster and is repeatable with a couple of clicks.

Faculty - Mr.Mike Thomas

Mike Thomas has worked in the IT training business since 1989. He is a subject matter expert in a range of technologies including Microsoft Office and Apple Mac. In 2012 Mike founded theexceltrainer.co.uk where he has produced nearly 200 written and video-based Excel tutorials. He has recorded several Excel training courses for pluralsight.com and in his career delivered hundreds of courses and webinars on a wide variety of technology-related topics.

Mike is a Fellow of The Learning and Performance Institute and has worked with and for a large number of global and UK-based companies and organizations across a diverse range of sectors. In addition to training, he also designs and develops Microsoft Office-based solutions that automate key business tasks and processes.

Thank you for your interest in becoming a part of our faculty. UPIQ is continuously looking for excellent individuals from diverse professions to add to our faculty records. Please complete the form below to be considered for our training arrangements in your area of expertise and then submit the form; we will get back as soon as possible.