Power Query is a feature in Excel that allows you to quickly import data from multiple sources and easily clean, transform, and reshape it to suit your needs. Follow along with Excel MVP Oz du Soleil as he shows you how to use this powerful, time-saving tool. Oz demonstrates how to import, merge, rearrange, and clean data, as well as how to repeat the process with one click if the data changes. Discover how to split columns, unpivot data, and use joins to merge, segment, and compare datasets. Oz offers dozens of techniques and tips in this comprehensive training.
Learn More- Students
- Undergraduate
- Graduate
- By College
- College of Arts Humanities, and Social Sciences
- Daniels College of Business
- Daniel Felix Ritchie School of Engineering and Computer Science
- Graduate School of Professional Psychology
- Graduate School of Social Work
- Josef Korbel School of International Studies – Graduate Students
- Josef Korbel School of International Studies – Undergraduate Students
- Morgridge College of Education
- College of Natural Sciences and Mathematics
- University College
- Still Exploring
- Identity / Affinity
- Build Career Skills
- Share Your Story
- Alumni
- Employers & Recruiters
- Student Employment
- About