Session 3 - How I Automate My Work With Power Query

Join me this Saturday July 16th, at 8:00AM MDT.

This time, I will show you how I transform txt files from unorganized lines to meaning and reliable information, using power query.

During this presentation I will create my query to transform these txt files into a table, that I will connect to 2 other tables.

Once the query is ready, then every month when I receive a new txt file, power query will do the work for me.

I hope that this example can inspire you, to automate your process as well.

Working files available here:
https://drive.google.com/drive/folders/18zBZOWTmQgL_gP_EqLndkPWRw5nTnYxg?usp=sharing

#MSExcel #PowerQuery

Видео Session 3 - How I Automate My Work With Power Query канала Alejandra Horvath