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.