Material Detail
Excel: Get and Transform Data
If you spend a lot of your valuable time every month cleaning up data so your Excel formulas will actually work – you need to know about Power Query. It’s a free Excel add-in that can cut your data cleansing work from hours to minutes. You can rapidly clean up and re-organize your data, convert US to European dates and vice versa, unpivot your data so you can re-analyze it and much more....
Show MoreQuality
-
Editor Reviews
- User Rating
- Comments
- Learning Exercises
- Bookmark Collections
- Course ePortfolios
- Accessibility Info