How Power Query Will Change the Way You Use Excel

Struggling with repetitive or complicated tasks in Excel? Say hello to Power Query, your new best friend for automating and simplifying Excel work! Power Query is like an Instant Miracle Cure to your difficult data analysis problems.

🔍 Discover Power Query's Magic:
Import Data Easily: Fetch data from various sources, like other workbooks, text files, SharePoint, and even your Outlook emails.
Transform and Clean: Effortlessly shape your data. Split columns, compare datasets, and even calculate ages with a few clicks.
Efficient Data Loading: Load data directly to tables, pivot tables, or the data model for dynamic reports.

Here's the problem...

Excel Power Query has been a part of Excel since Excel 2016! It's in the Data tab under Get and Transform. Unfortunately many people haven't explored what it has to offer! They continue doing things the old "manual" way, Or the "complex" way with difficult formulas.

And something else you may not know ...

Generally, when you learn something, the more effort you put in, the more you get out. But it's NOT the same with learning Power Query! If you just put in a little effort, you get SO much in return! This is the difference with learning Power Query to learning other skills like VBA.

And that’s why I created this course!

To give you the tools to really make a difference at your workplace. I’m going to take you from Power Query Beginner to Pro!

🚩Let’s connect on social:

Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!

#excel #powerquery

[florentchif]

To everyone new to power query: I started using it 1 year and half ago. I learned by myself as it is really easy for 98% of things you want to do. It totally changed my way of working. Since then I never had the feeling that I needed to re-do everything from scratch again and again. And Power Query is just the beginning, when you start using Power Pivot it gets even better (both work together). Ah and also, while you learn these 2 on excel... be aware that you are learning Power BI as well as the engines are the same at 99.9%. So yes, go for it, it will change your life forever. (Personally thanks to these new skills I got a better job at a bigger company).

[RobertLongM]

Wow - you even went to the length of showing how to do it BEFORE Power Q...
That's a Great Teacher!

[excelisfun]

Power Query is the greatest Excel tool since the PivotTable, without a doubt!!! Making Excel better since 2013 : )

[ngwafabrice]

I'm an advanced excel user and data analyst today because of Leila, I still have some of her exercises saved in my laptop from years back. Believe or not I came here with about 10 percent knowledge of excel today I can automate with vba vcuz of her.. thanks Leila. Wish u knew what u did for me❤

[ZLLoVeR]

The example at 3:05 is so relatable, this is a good chunk of what we FP&A Analysts deal with everyday. You nailed it Leila!

[faYte]

Love this video format, Leila! You've thoroughly thought through the perspective of your audiences and created a video that justified signing up for your course, without being pushy at all. Thanks for all the years of teaching me Excel!

[firoj]

Your Power Query course already changed my life and got lots of appreciation in my work . Thanks for your wonderful and most interactive session for this course in Udemy.

[Timurlane]

I've been out of the tech field for about a decade, but your walk through here was so clear and concise that I felt right at home, even to the point of standing up and shouting (metaphorically at least) "Yes! Where have you been all my life!"

[andrewadams]

I first heard about Power Query when looking into PowerBI. I was excited to learn that it's built in to Excel, and I recommend it to anyone that needs to transform data in Excel. I'll have to check out your course, because there's a lot that I have to learn about it. Thank you for the great content; you're a great teacher!

[nobodynobody]

Leila, you are a great teacher. I am impressed that you even showed how's it's done the old school method (to be honest, the old school method was what driving my heart pumping and excited about using excel :))
But in the working environment we are in now where velocity + intelligent = success, power query no doubt is a very useful tool to have.
And you are only showing the viewer on 228K+ rows of data, think about having more than 1 million rows where native excel just can't handle.

[heshanpalliyaguruge]

What an amazing video. The way you presented it using a proper example. I’m learning power query in my management info systems class and I’m so excited!!

[Craig.Coates]

You’ve no joke, just changed my life, and probably saved my career. THANK YOU

[BestICan]

Leila, you've brought the quality of your video production to the top of the mountain. So good!

[YvesAustin]

Leila, thank you for this video. I cannot emphasize how much power query has changed my approach to Excel. You and Oz have been a real inspiration to me; now, I am working 99% of my excel analysis through PQ rather than regular Excel. Power query has a ton of features way better than regular Excel (the date functions are a great example of how much can be done). Power query is a real game changer. Thank you for sharing.

[rc.]

You are more than a simple Microsoft MVP.. You have talent, you have an Hypnotic voice, you know how to communicate, you have a charme, you have the knowledge..but most of all... you know how to teach.Thumbs up. You are a number 1. Bravissima!

[surfer]

I've seen this already ... From your online courses 😁😁😁
Looking forward to complete the course. Thanks for your tutoring Leila. Please stay safe 🙂

[alanhorowitz]

To extract the customer ID, copy the entire column to a new one at the very end of your data set. Highlight the entire column, go to data, text to columns and perform a text to columns using the "-" as the delimiter. This will separate the sets of digits and the dashes into columns to the right hand side. The 2nd set of digits, will be isolated into one column. All other newly created columns can then be deleted. You've now isolated customer ID.

[omnipop]

Been using Power Query as an add-on to Excel 2010 for a year or two now. Love it.

[cherijoli]

I just signed up for the class. Please take my money LOL. There is literally no one on the internet that makes things as easy to understand for all levels of expertise, as fun, or as pleasant to watch! I am so glad I found your videos!! You have saved my life and made my job more even exciting!

[AShina-znnx]

You see reason why I keep referring my folks at the office to this page, easy to assimilate. Your teachings have safe me many times, and this Power Query video is the best ever. Thanks Leila