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

Download the practise files used by Adam in the presentation
https://computergaga.com/_excel/files/london-excel-meetup/adam-meetup-20251125.zip

Learn more Excel and Power BI
https://computergaga.com

Connect with us!
LinkedIn ► https://www.linkedin.com/in/alanmurray-computergaga/
Instagram ► https://www.instagram.com/computergaga1/
Twitter ► http://www.twitter.com/computergaga1
TikTok ► https://www.tiktok.com/@computergaga

#excel #londonexcelmeetup #powerquery

Видео Advanced Data Import and Integration in Excel | Adam Kopeć канала Computergaga