[Excel Power Query] Retrieve and aggregate data from the latest file [YT0199]
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...