[Excel Power Query] Retrieve and aggregate data from the latest file [YT0199]

Опубликовано: 09 Август 2026
на канале: ExcelドカタCH

28,974

484

This video explains how to extract and summarize data from the most recently modified file using Excel Power Query.

Yuichi Chiba

━━━━━━━━━━━━━━━━━━━━━
✅️ Reference
━━━━━━━━━━━━━━━━━━━━━
🔗#0683. Retrieving and combining data from the latest file for each month
   • #0683.各月の最新のファイルからデータを取得して結合する

━━━━━━━━━━━━━━━━━━━━━
🎦 Playlist
━━━━━━━━━━━━━━━━━━━━━
   / play   list?list=PLVCXH2zKxEnFYi4sNY8VHtOZMxRFTM-Fr
   • Excelでパワークエリやパワーピボット/DAXを活用する

━━━━━━━━━━━━━━━━━━━━━
✅️ Membership
━━━━━━━━━━━━━━━━━━━━━

You can check member-exclusive benefits from the link below.

   / @exceldokatach

━━━━━━━━━━━━━━━━━━━━━
✅️ Excel Workers' Gathering Place
━━━━━━━━━━━━━━━━━━━━━
🔥Latest Video🔥

【Power Query Practical Techniques】
'#0683. Retrieving and combining data from the latest files for each month'

🎞️【Membership Exclusive Video [Video] Watch here
   • #0683.各月の最新のファイルからデータを取得して結合する

🎞️ Watch on [Excel Dokata's Gathering Place]
https://excel-dokata.mish.tv/ja/video...

💻 [Excel Dokata's Gathering Place] TOP
https://excel-dokata.mish.tv/

━━━━━━━━━━━━━━━━━━━━━
✅️ X (Former Twitter)
━━━━━━━━━━━━━━━━━━━━━
We tweet about video updates and more.

  / chiba_u1

━━━━━━━━━━━━━━━━━━━━━
✅️ Online Courses
━━━━━━━━━━━━━━━━━━━━━

🔗Excel Power Queries [Beginner Level]
https://uyrDOv.short.gy/sutoaka-class...

🔗Excel Power Queries [Elementary Level]
https://uyrDOv.short.gy/sutoaka-class...

🔗Excel Power Pivot Tables [Elementary Level]
https://uyrDOv.short.gy/sutoaka-class...

🔗Excel Pivot Tables [Beginner Level]
https://uyrDOv.short.gy/sutoaka-class...

🔗 Online Course List
https://uyrDOv.short.gy/sutoaka-teacher

━━━━━━━━━━━━━━━━━━━━━
✅️ Article Posting
━━━━━━━━━━━━━━━━━━━━━
I post articles about Excel functions, Power Queries, Power Pivot, and DAX.
https://note.com/excel_dokata

━━━━━━━━━━━━━━━━━━━━━
✅️ Contact Information for Business Inquiries
━━━━━━━━━━━━━━━━━━━━━
For inquiries regarding outsourcing, contract work, instructor requests, consulting, private lessons, etc., please contact me here.

[email protected]

━━━━━━━━━━━━━━━━━━━━━
✅️ Excel Version
━━━━━━━━━━━━━━━━━━━━━

The Excel used in this video is Microsoft 365 Personal (Office Insider Beta, the latest version at the time of video release).

━━━━━━━━━━━━━━━━━━━━━
✅️ Sample File
━━━━━━━━━━━━━━━━━━━━━
【Membership (Serious Union Members and above) Only】
   • Post
━━━━━━━━━━━━━━━━━━━━━
✅️ Timestamp
━━━━━━━━━━━━━━━━━━━━━
[ 00:00 ] Introduction
[ 00:29 ] Retrieving data from an Excel workbook
[ 04:35 ] Changing the Excel workbook to retrieve
[ 06:59 ] Automatically retrieving the latest file
[ 16:39 ] Checking the retrieved file name
[ 26:12 ] Finally

━━━━━━━━━━━━━━━━━━━━━
✅️ Online Individual Consultation
━━━━━━━━━━━━━━━━━━━━━

You can consult about Excel using Zoom.

https://uyrDOv.short.gy/sutoaka-reque...