Скачать или смотреть Learn Excel Power Query to Automate Boring Tasks in 15 minutes

Learn Power Query - Beginner to PRO Masterclass in just 15 minutes. So, WATCH this video now and THANK me later

🚀📈 Join us on this #Excel & #PowerBI adventure and Don't forget to hit that like button, SUBSCRIBE for more Excel mastery, and let the dynamic journey begin!

Join this channel to get access to perks:
https://www.youtube.com/ChethanaPixel...

File link to download: https://drive.google.com/drive/folder...

#powerquery #excel #cleandata

00:00 Introduction to Power Query
00:40 Explaining Customer Data
01:54 Explaining Product Data
02:46 Import Excel and Text files data into Power Query
03:58 Apply Basic Transoformations to Product and Customer Data
05:00 Merge Columns in Power Query
06:44 Replace values in Power Query
07:37 Clean and Trim data in Power Query
08:50 Split into multiple columns in Power Query
09:36 Extract Start and End of month from date column in Power Query
10:36 Unpivot columns in Power Query
12:35 Merge Tables or Merge Queries in Power Query
14:05 Re-Order columns position in Power Query
15:07 Load data into excel sheets in Power Query
16:32 Wrap-up!

New PERCENTOF function:    • NEW Excel Function - PERCENTOF with Comple...  

GROUPBY and PIVOTBY functions:    • Master the New GROUPBY & PIVOTBY Functions...  

XLOOKUP Guide:    • The Ultimate XLOOKUP formula Tutorial (The...  

Hand Drawn Charts in Excel:    • Hand Drawn charts in EXCEL to draw attenti...  

Python in Excel Part 1:    • Introducing Python in Excel - Financial An...  

Python in Excel Part 2:    • Python in Excel - Dynamic Financial Dashbo...  

Power Query Series:    / playlist  
list=PLAJojq_HX3tYVVd0bT42Qsu0GwFa9z5-9

JOIN us for more FUN:
   / @chethanapixel  

Play List:    / chethana  

Instagram:   / ​  

Facebook:   / chethanapixel  

Twitter:   / chethanapixel  

Thank you!!!