Get data from the latest file in a folder with Power Query | Excel Off The Grid скачать в хорошем качестве

Get data from the latest file in a folder with Power Query | Excel Off The Grid

★ Want to automate Excel? Check out our training academy ★ https://exceloffthegrid.com/academy ★ Check out the blog post for more details ★ https://exceloffthegrid.com/data-late... ★ About this video ★ Our ability to manage inputs effectively is critical to building automated processes in Excel. A common reporting scenario is to get data from the latest file. This generally occurs where each file includes the historical data; therefore, we only need the latest file. In thisvideo, we are exploring how to create an efficient solution for this situation. 0:00 Introduction 0:16 Connect to folder 0:55 Available fields to identify the latest file 2:17 Steps to get to the latest file 3:34 Testing the solution 4:08 Conclusion ★ Download 30 most useful Excel VBA Macros ebook for FREE ★ https://exceloffthegrid.com/ ★ Where to find Excel Off The Grid ★ Blog: https://exceloffthegrid.com Twitter:   / exceloffthegrid   #MsExcel