question

mlk-7278 avatar image
0 Votes"
mlk-7278 asked TomFrink answered

learning power query

Hello Forum,
practicing in the use of PQ in excel 365 I found on the net many resources by passionate professionals but few Microsoft resorces that allow a progressive and in-depth study of power query. Will I have to purchase a specific manual or are there other resources?

Just for example I would like to better understand the behavior of PIVOT and UNPIVOT in Power Query which is sometimes used to transform stacked data into a standard table like the one in this example.

thx :)


power-query-not-supported
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

MattAllington-5456 avatar image
1 Vote"
MattAllington-5456 answered

There are definitely some free resources out there, but good quality, structured training material is very time consuming to produce and requires depth of knowledge of the tool. I provide heaps of free content on the web, but when it comes to structured training material, I charge for the value provided. Ken, Miguel and I are all Power Query experts and have produced a comprehensive training course here https://www.skillwave.training/shop/power-query-academy/

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

mlk-7278 avatar image
0 Votes"
mlk-7278 answered

good morning and thank you for your help!
I'll check yor website soon.
I've found very usueful the Power Query Documentation


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

anthony-34 avatar image
0 Votes"
anthony-34 answered
  1. full course available here by Ben Gribaudo : power-query-m-primer-part1-introduction-simple-expressions-let

  2. directory for ressource: learning-resources


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

TomFrink avatar image
0 Votes"
TomFrink answered
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.