Must Know Power Query Quick Stats & Auditing Tools - My Online Training Hub
video description
Date: 2022-04-08
Related videos
Comments and reviews: 5
Paul
This is a great overview! Thanks! One item that is challenging to get in Power Query is the Mode or most commonly appearing value. Everytime I want to do this I have to look it up again, but I remember it's not straight forward.
reply
This is a great overview! Thanks! One item that is challenging to get in Power Query is the Mode or most commonly appearing value. Everytime I want to do this I have to look it up again, but I remember it's not straight forward.
reply
Noor
Hello, I have an Excel pro plus version and I want to be able to see the column distribution and quality ( view tab) but I just have the show whitespace and monospaced options. Any ideas?
reply
Hello, I have an Excel pro plus version and I want to be able to see the column distribution and quality ( view tab) but I just have the show whitespace and monospaced options. Any ideas?
reply
Felipe
Hi teacher, How Can I create a similar stats, but the formula is to sum a complete column and then use the results like you do to create a new calculate column? (change Max to sum)
reply
Hi teacher, How Can I create a similar stats, but the formula is to sum a complete column and then use the results like you do to create a new calculate column? (change Max to sum)
reply
lance
Hi Mynda, thanks for the lessons they are brilliant!. Pivots were a lightbulb moment for me about 15 years ago. Power Query and Power Pivot are that again !! :-)
reply
Hi Mynda, thanks for the lessons they are brilliant!. Pivots were a lightbulb moment for me about 15 years ago. Power Query and Power Pivot are that again !! :-)
reply
Vijay
Thanks Mynda for this very useful video! Data Profiling is essential but usually a tedious and boring task. These features will surely help make it easy!
reply
Thanks Mynda for this very useful video! Data Profiling is essential but usually a tedious and boring task. These features will surely help make it easy!
reply
Add a review, comment
Other channel videos
