1. Home
  2. Material Detail: Excel: Get and Transform Data

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.

Disciplines:
Go to Material  
Bookmark / Add to Course ePortfolio
Create a Learning Exercise
Add Accessibility Information
Rate
Add a Comment

Quality

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

More about this material

Material Type:
Open (Access) Textbook
Date Added to MERLOT:
June 25, 2019
Date Modified in MERLOT:
June 25, 2019
Author:
Submitter:
Cathy Swift
Primary Audience:
College General Ed, College Lower Division, College Upper Division, Graduate School, Professional
Technical Format:
Website
Mobile Compatibility:
Not specified at this time
Technical Requirements:
Download as PDF
Language:
English
Cost Involved:
No
Source Code Available:
Unknown
Accessibility Information Available:
Unknown
Creative Commons:
No

Browse...

Disciplines with similar materials as Excel: Get and Transform Data
Other materials like Excel: Get and Transform Data

Comments

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