How to Use Power Query / Get And Transform in Microsoft Excel 2016

During this Microsoft Excel 2016 training tutorial video, discover how to use Power Query / Get and Transform in Microsoft Excel 2016

💻 Watch more free popular training tutorials from Simon Sez IT:

🔥Check out our FREE 300+ hour training course playlist here ➡️

💬Stay in touch!

🔔 Subscribe to our channel:

If you enjoyed the video, please give a thumbs up 👍🏽 ;-)

[abrotherinchrist]

Very informative. It was a fast pace but I appreciate that you get to the point quickly. Too many YouTube videos require me to constantly arrow ahead to skip idle talk or set them to 1.25x.

[AbhishekRajput-vuhu]

could you pls share the excel files for practice with your videos. it would be helpfull.

[CaribouDataScience]

Thanks thus is very helpful. Which playlist is this from?

[gginah]

This is great, just listen at 0.75 playback 👍

[mattschoular]

the call outs are informative but they disappear too quickly. it makes it difficult to follow to learn.

[carolshipley]

I have an issue when after creating a workbook that has powers queries for others to used from a shared drive. The new user cannot run the queries without a privacy prompt. How do I prevent this from happening?

[luukh.]

Lighting fast woow, difficult to follow but still good stuff

[kates]

Revenue less COGS does not equal net profit. It equals gross margin.

[ashishmenify]

This option has been changed in latest Excel 365. No help available on how to use the functionality in the new version.

[kevinkobbe]

What are those little minus signs in each cell in column C?

[noel]

what are the advantages of using power query as opposed to SQL, Python pandas, etc?

[rickyrocks]

how can i use ifs function it doesn't visible in my mso 2016 pro plus ?

[AAbraham]

You should not be talking while there is a pop-up bubble. Viewers can't read and listen simultaneously.

[seanmullane]

What are those little minus signs in each cell in column C?