Watch Power Query in Excel

Posted on
7,891 Points
5 Endorsements
Last Modified:
Experience Level: Beginner
Zack Barresse
Love Excel, shiny new things, my family, gaming, and general cool stuff. Oh, and being awesome. #hashtagsmatter
Viewers will learn a basic data manipulation technique of unpivoting data in Power Query for Excel 2013 and the importance of using good data.

Video Steps

1. Start with data in a poor structure

2. Create a table on your data

3. Unpivot columns

4. Rename columns

5. Apply query and close editor

6. Summarize data in newly created table

To rank something isn't that difficult. Basically, it is just to sort on the values to rank - points, goals, sales, citizens, whatever - in descending order or (typically for time) ascending order. But how to rank dupes? Five methods exist, and th…
Provides a one size fits all solution for File Dialog calls for all MS office applications. Module contains function fncGetFilePathTRM() which does all the filter building for you. I've used a similar version of this for over 15 years, 1 module impo…

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month