Practical Excel for Real-World Professionals - Power Query Advanced

This is a course that utilizes Power Automate Desktop, one of the RPA tools.
Click the link below
Find out more details.

https://youtu.be/mEZEX7xNJlE?si=IMp7zx4Dwb_g2c4g

Click the link below
You can watch the video for more details about the process.

https://youtu.be/tIoDOVuA5Xo

The era of the 4th industrial revolution,
We are now applying Digital Transformation across industries.
Should we apply this to our current Excel work?

https://youtu.be/9JPepntcpi8

In the field
Use complex and heavy forms using Excel formulas and functions.
It was developed with two results: PowerQuery and VBA.
Please check the video link below
If you need it, please email me (✿◠‿◠)

Hope Dream

https://youtu.be/6zml8rRssYg

Existing data table
Restructure into the form the user wants

※Video link⇊
https://youtu.be/e9oknTWryT4

※Sample image⇊

Hello, I am Bae Young-ja, a knowledge sharer :)

There are many difficulties when collecting data in the field.
Using PowerQuery and VBA
I'd like to take the time to clearly outline the equations that automate data collation.
Please check the information below and apply.

See you this Sunday at 8pm.

Hope Dream