Google Sheets - QUERY from Another Sheet, IMPORTRANGE, Use Multiple Tabs, Subquery Examples Tutorial

Part 8 - In this Google Sheets tutorial see examples & learn how to use QUERY function with data from other sheets or worksheets, get data from other files using IMPORTRANGE function, combine multiple tabs and use them within QUERY function, run subqueries in Query function, implement Col1, Col2 ...etc. syntax.

[ricardochaverra]

Thank you!!!, I was banging my head against the wall previously because IMPORTRANGE wasn't working for importing multiple sheets into a single query, you sir are awesome!! thanks again

[bobmolnar]

This entire series is amazingly helpful. It is THE definitive guide to using Sheets like a pro. Thank you!

[socialstyledancelessons]

Your videos are the best. I have been able to build an entire database in multiple sheets because of your awesome tutorials. THANK YOU!

[nancylalicon]

This is amazing and your talent of explaining the steps inspires me!

[abbashaidari]

I don't have enough words to appreciate you putting out all this amazingly explained information for free on YouTube...

Thank you...!!!! Thank Thank you....!!!

[MrChiluby]

This was so helpful. Literally the only place I found such a clear answer. Great video

[BruiserBailey]

Thanks for all your tutoring. Your videos are just what I needed as I needed to brush up on my accounting reporting skills not utilised since I retired years ago.
The software environment has changed a lot and the advantages of Google sheets offers as a way of communicating and collaborating is significant.
I used to use Visual dBase which had an SQL like query language so the syntax is familiar. What was great about VdB was that you could input data in a user friendly form and see the code come out on a "Command Screen". It was a great way for a novice to write and learn to code. In addition you could copy and paste the code and incorporate into larger programs.
Wouldn't it be great if Google Sheets could come up with something similar?

[dhaval]

Google should make you an official associate, there is a huge demand for resources for google sheet and your channel is an extremely valuable resource

[ClarenceMatthewUrot]

This is what I have been looking for. Thank you very much. Easy to understand and follow.

[foxhoundv]

Wonderful! I knew there had to be a way to query from multiple sheets, I just didn't know about the bracket for the array.

[JanJanuszNosacz]

Thanks for the tutorial on using QUERY with IMPORTRANGE. Really helped me!

[calitran]

Thank you SO much - been having so much trouble sorting text data and this finally solved my problem at work!!

[nickieoakwood]

Awesome my main man. Had a bit of panic at first not working but I had forgot the QUERY at the beginning. All great.

[allanandersen]

Thank you so much! I have been able via your videos to minimize manual updates. Thanks again.

[Richard.bassan]

Greetings from Brazil. I would like to thank you for this serie, it was very helpful

[ambercarvell]

You are a great teacher. These videos are super helpful.

[gsxmentor]

Sir, you are the Best, your videos have contributed too much in me gaining respect in my office

[aikslf]

QUERIES ARE WONDERFUL!! I was wondering how to reference a series of cells from a different worksheet into a series of cells in a different worksheet without copy-pasting a formula a million times. This is the answer. You don't have to type it all out manually, just as expected.


Thanks for these tutorials, I looked for google spreadsheet tutorials and this series is what I came across, which is helpful.

[Raidon]

Great video, extremely useful! Thanks!

[SingingLi]

Thank you for your sharing. I learn a lot from this video.