Advanced Data Import and Integration in Excel | Adam Kopeć

Learn how to import tricky data files into Excel with Power Query

Struggling with messy CSV files that have extra header rows? Need to pull data from multiple PDF files and combine them? This webinar will show you practical solutions using Power Query.

What you'll learn:

• How to automatically skip unwanted lines at the beginning of CSV files – no matter how many there are
• Working with fixed-width text files (where data is aligned in columns without separators)
• Importing and merging data from multiple PDF files at once
• Cleaning imported data to make it usable
• Handling numbers from different regions (like 1,234.56 vs 1.234,56) so Power Query reads them correctly

Who should attend: Anyone who regularly imports data into Excel from external files and wants to automate the process and avoid manual clean up.

This is an online event.

Join via Zoom:
https://us02web.zoom.us/j/87472087424?pwd=Wq9hvqRizARmbONk6ZvbfChlEa34rd.1

This YouTube stream and replay link
https://youtube.com/live/0FabQLAxb6c