Excel Power Query Tutorial | What is possible with Power Query

Описание к видео Excel Power Query Tutorial | What is possible with Power Query

Join 60,000+ professionals in our courses for ONLY $9.99👉 https://courses.mellontraining.com/
👉 What You'll Learn:
In this video, I'll show you an example of what is possible with Excel Power Query. By using Power Query, you can quickly and easily transform data in Excel into the information you need.

If you're interested in using Excel Power Query to transform your data, then this video is for you! By the end of this video, you'll have a better understanding of how Power Query works and what kinds of tasks you can accomplish with it.
There is no exercise file with this, so just watch and follow along.

🎁 Join the FREE COURSE 💥 TOP 30 Excel Productivity Tips: https://bit.ly/3w8yclD

🔔 SUBSCRIBE if you’d like more tips and tutorials like this: https://bit.ly/3HHWQME

🔍 Key Moments in This Video:
00:00 A Description of the Exercise
01:01 Import Data
01:33 Remove Other Columns
02:40 Filter Data
02:52 Split Data
03:20 Add a Custom Column
04:30 Merge Data Sets

🎓 Join 60,000+ professionals in our courses here 👉 https://courses.mellontraining.com

🎬 LINKS to other videos:
Make An INTERACTIVE MAP CHART In Excel 👉    • How to Create An Excel INTERACTIVE MA...  
Make An Excel PANEL CHART 👉    • Create a PANEL CHART in Excel  
Add Text to Numbers AUTOMATICALLY 👉    • How to Add Text to Numbers in Excel  
Sum Excel Tables in ONE STEP 👉    • How to Sum Excel Tables in ONE STEP  
Supercharge Your Spreadsheets with Excel's Goal Seek 👉    • How to use Goal Seek in Excel for Wha...  
Excel SUMPRODUCT Function 👉    • Why Excel SUMPRODUCT is About to Chan...  
2 WAYS to create Excel Bar & Donut Charts 👉    • How to Create Advanced Excel Bar & Do...  
Mastering Excel Pareto Charts 👉    • How to Make a Pareto Chart in Excel  

📊 Excel Your Skills: www.mellontraining.com

🎁 SHARE this video and spread the Excel love.
Or if you’re short of time, please click the 👍

#excel #powerquery

Комментарии

Информация по комментариям в разработке