Power Query allows you to automatically perform data cleansing routines on your data sources – no manual intervention required.
Simply refresh and your data is ready to use. You can import from csv files; txt files; databases and existing Excel tables as your data sources.
Learn the basics, plus an advanced technique to convert a report to a data table.
This is a recording of a live webinar given in January 2025.
It is assumed you are using the subscription version of Excel.
The PDF manual can be printed out and you can make notes in it.
The completed file Excel file won't work for the CSV files unless you modify the SOURCE steps with a folder path on your system.