Excel Power Query - Live Webinar

What you’ll learn:

  • Merge Data Sources: Learn how to combine data from multiple sources into a single, cohesive dataset.
  • Append Data Sources: Understand how to append data from different sources to create a comprehensive dataset.
  • Transform Data: Master various transformation techniques such as Fill Up, Fill Down, Replace Values, Move Columns, and Split Columns.
  • Unpivot Columns: Discover how to unpivot columns to transform your data into a more usable format.
  • Create Conditional Columns: Learn to create columns based on conditions to enhance your data analysis.
  • Create Columns from Examples: Use examples to create new columns, simplifying the data transformation process.

Course Highlights:

  • Hands-On Training: Engage in practical, hands-on exercises that ensure you can apply what you learn immediately. We’ll send through support files so we can work together.
  • Expert Guidance: Benefit from the expertise of our seasoned trainers who will provide personalised support and feedback.
  • Interactive Learning: Participate in interactive sessions that reinforce your learning through real-world examples and scenarios.
  • Group Pricing: Get in touch for group pricing. 1:1 coaching also available. 

Who is it for? Power Query would be beneficial for anyone who works with data regularly and wants to save time and effort in preparing their data for analysis. Once you’re comfortable working in Excel, you can learn how to use Power Query to automate and streamline your data transformation, cleansing, and loading tasks. This course is perfect for anyone looking to enhance their data preparation skills and improve efficiency.  Book a webinar for your team today and enjoy 

Choose your training format

We offer flexible learning options to fit your needs.

Group Training

Perfect for teams of 3+ people

  • Interactive team exercises
  • Collaborative problem-solving
  • Cost-effective for organisations
  • Shared learning experience
  • Custom scenarios for your industry
Get group quote

1:1 Personal Coaching

Tailored training for individuals

  • Personalised attention and pace
  • Focus on your specific challenges
  • Flexible scheduling around your calendar
  • Work with your actual datasets
  • Follow-up support included
Book your session

Ready to transform your skills? Let's find the perfect training solution for you.

Group Training

Perfect for teams from 3 to 16 people

Get your quote

Individual Training

One on one live sessions.

Book your session

Customised

Not sure where to start?

Talk to us
photo of a person using a headset

Why choose 365 Training Hub

We specialise in the design and delivery of digital workplace learning solutions using human-centered design, for the front line through to executive leadership teams.

  • Expert Trainers

    Our certified Excel specialists have 10+ years of corporate training experience and work with Fortune 500 companies daily.

  • Learning by Doing

    Every concept is immediately practiced with real-world datasets. No boring theory - just practical skills you'll use tomorrow.

  • Immediate Impact

    Participants report saving 5+ hours per week within their first month of applying these techniques.

Ready to transform your skills?

Let's get you the training you deserve

(optional)
(optional)
By submitting this form you agree to our Privacy Policy
Argus Fire
"I did some excel training this morning with you. I just wanted to reach out and say your delivery style was exceptional—energetic and highly interactive, which made the experience both engaging and enjoyable."
Jonathan
Eastern Institute of Technology
“We are happy to recommend the 365 Training Hub for your migration project. Their in-depth knowledge of the technology couple with a ‘people-first’ emphasis meant we achieved our goal of a painless and successful migration.”​
K. Harvey
Technical Project Leader
ADHB
Thanks so much – your presentation is slick, relaxed, inclusive and upbeat – brilliant!
Sue
attendee at General Teams Training session
RockMyBaby
Thank you for your help on this one. I thought it was a very worthwhile, high value exercise
G. Bell
Project Manager
Boxfish Research Limited
Thanks so much for customising the training for us, I believe that was really helpful and with the materials, the team can use the platform easier. Not to mention we got rid of at least two additional systems and one more in process. Such a relief!
V. Bronza
Marketing and Sales
Northern Regional Alliance Limited
The knowledge and humour were so beautifully entwined that the hour spend with you was not only an enriching experience but also one that has motivated me to use Teams to an optimum level.
R. Krishnaswamy
Attendee at a General Teams Training session

Other courses you might be interested in

Excel Essential
Excel
60 mins
Excel Essential
Are you ‘self-taught’ in Excel? It’s time to fill in the gaps and build a solid foundation of essential skills. Learn quicker, more efficient ways of working with Excel and enhance your productivity.
Excel Intermediate
Excel
60 mins
Excel Intermediate
This comprehensive Level Two Excel course will help you enhance your proficiency with next level Excel tools and techniques.
Excel If Statements Demystified
Excel
60 mins
Excel If Statements Demystified
Think of Excel as a Swiss army knife with many tools to learn, each with a different role to play.

Contact Us to Discuss Your Unique Training Needs

Our courses can be delivered via live webinars or onsite training. If you’d like a customised course to address specific requirements, please reach out to us. We’re more than happy to assist. Additionally, if you have any special requests, such as needing a speaker for your next sales conference, let us know!

Let us know how we can tailor a course to target the specific training needs across your business.

Get in touch
Fill 17