EMT 1536: Power Query to Import Text Data for Accounting Schedule of Accounts
Download Excel Start Files: http://bit.ly/2VTHw6y
Download Excel Finished Files: http://bit.ly/2QOzNCY
Entire page with all Excel Files for All Videos: http://bit.ly/1kSFWvs
In this video learn how to create an Accounting Schedule of Accounts from a Text File using Power Query and a PivotTable with a Slicer. This solution will update when a new file becomes available next month.