Power Query Makes Data Preprocessing Easy | Even just mastering Power Query can make your work ea...
We'll show you how to preprocess data into a form suitable for analysis through two examples. If there are merged cells or blank rows in the data, you won't be able to create PivotTable reports, let alone perform basic sorting and filtering. Power Query makes data preprocessing a breeze.
00:00 Examining the first sheet's data issues
02:14 Connecting Power Query data
03:21 Transforming data
04:42 Loading to a worksheet
06:30 Creating a PivotTable
08:18 Examining the second sheet's data issues
09:09 Preprocessing data
Download the practice data → http://hantip.net/700
📢 Real Excel used at work!
[It works! Purchase [7-Day Practical Excel]
Yes24 http://www.yes24.com/Product/Goods/76...
Kyobo Bookstore https://product.kyobobook.co.kr/detai...
Aladdin https://www.aladin.co.kr/shop/wproduc...
If you found this course helpful, don't forget to subscribe, like, and turn on notifications! You'll receive updates on new courses. And your encouraging comments are a driving force behind our ability to create even better videos.
To watch more Power Query videos, click the link below: • 파워쿼리(Power Query)
To learn Excel in 32 easy-to-learn, immediately usable lessons, click the link below: • 쉽게 배워 바로 써먹는 엑셀
Don't just watch the video lectures; try following along yourself. You'll easily master Excel.
#Excel #ExcelLecture #PowerQuery #PowerQuery #DataPreprocessing #RemoveBlankLines #ShortLecture