Material Detail

Excel: Get and Transform Data

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.

NOTE:  This is a BookBoon publication and you have to provide your email address to access it. It is free for students, but only free for 30 days for others.



  • User Rating
  • Comments
  • Learning Exercises
  • Bookmark Collections
  • Course ePortfolios
  • Accessibility Info

More about this material


Log in to participate in the discussions or sign up if you are not already a MERLOT member.