Consolidating multiple excel files
In this video of Power Query training I have explained steps to import data from existing Excel file into Power Query for - Excel table, Named Ranges and Dynamic ranges in Excel sheet.After your perform your transformation steps within Power Query you would need to load that data back either as Excel table into sheet or store it as connection only or directly load it to Power Pivot Data model.
And if you are not satisfied from this Power Query Training you can get your money back within 30 days of enrolling into the course.This will explain how to create dynamic list of files stored in particular folder.Now when you share the file which contains data imported from source other than existing file to your colleague or other person then the link to that source will be broken.For learning about Power Query you do not need to learn or have prior knowledge about any programming languages like Excel VBA or SQL, etc.If you are planning to implement Data Analytics or Business Intelligence solutions using Power Pivot, Power View, Power Map, Power BI, Tableau, Python or R, etc.
You can extract year, start of the year / quarter / month, end of the year / quarter / month, Quarter, month, month name, day, day name, etc. You can import all or selected files from a folder in one query itself.