[Google Spreadsheets] The QUERY function can handle anything, from retrieving, extracting, and ag...

Опубликовано: 11 Июль 2026
на канале: ExcelドカタCH

17,286

226

This article explains how to use the 'QUERY function' in Google Sheets and the basics of the SELECT statement used as an argument.

Yuichi Chiba

━━━━━━━━━━━━━━━━━━━━━
✅️ Reference
━━━━━━━━━━━━━━━━━━━━━
🔗QUERY function
https://support.google.com/docs/answe...

━━━━━━━━━━━━━━━━━━━━━
🎦 Playlist
━━━━━━━━━━━━━━━ ━━━━━━━

   • Google スプレッドシート実務解説

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

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

   / @exceldokatach

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

【Power Query Practical Techniques】
『#0677.【Part 2】The M Function for String Manipulation』

🎞️【Membership Exclusive Video】Viewable Listen
   • #0677.【Part2】文字列操作のM関数

🎞️ 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 other things.

  / 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
━━━━━━━━━━━━━━━━━━━━━
✅️ Timestamps
━━━━━━━━━━━━━━━━━━━━━
[ 00:00 ] Introduction
[ 00:30 ] QUERY function
[ 02:01 ] SELECT
[ 05:40 ] WHRER
[ 08:02 ] CONTAINS
[ 09:21 ] STARTS WITH
[ 09:53 ] ENDS WITH
[ 10:50 ] ORDER BY
[ 12:24 ] GROUPBY
[ 16:06 ] PIVOT
[ 17:57 ] IMPORTRANGE function
[ 21:03 ] QUERY and IMPORTRANGE
[ 23:24 ] How to specify columns in QUERY
[ 25:05 ] Conclusion

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

You can consult about Excel using Zoom.

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