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...

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

Connect with us!
LinkedIn ►   / alanmurray-computergaga  
Instagram ►   / computergaga1  
Twitter ►   / computergaga1  
TikTok ►   / computergaga  

#excel #londonexcelmeetup #powerquery