Google Sheets Advanced Tutorial

[@LearnitTraining]

How to edit the sheet: Exercise Files: bit.ly/3udealu Click the link Select File Select Copy Or Click the link Select File Select Download Choose the format you wish to download Click Save

[@suzieogeto6319]

Thank you very helpful!

[@arindambasak5261]

I love you Joe ,your voice is so good and the way you minutely discussed so many topics in this video is just amazing ,I am loving to learn from you :)

[@LearnitTraining]

Wow, thank you!

[@elevatedascent]

Really love your teaching style, one criticism would be it is hard to see on small screens, it would be nice if you could zoom in a bit, especially if the rest of the canvas is mostly blank rows. 🙂

[@LearnitTraining]

Thanks for the feedback!

[@Sobitsaid]

When I was watching this video without looking at comments, I already know that the comments are gonna be super positive. Thanks a lot. If you read my comment, would you help me find out a function for "click" actions? - like if you just click a column, you get a checkmark symbol to be appeared (no checkbox).

[@LearnitTraining]

Noted

[@mereymeiram]

Exercise files link doesn't work :( It is hard to type all of the things, can you update please?

[@grainofsalt2113]

thank you for this amazing tutorial :)

[@LearnitTraining]

You're very welcome!

[@davidburt7138]

Very good content. Using the macro, how do I select a prededermined cell range to have the cells populated by the user one cell at a time? -OR- have two predetermined cell ranges based on a checkbox to select the cells one at a time for the user to populate the information in the cells needed based on the status of the checkbox? Can each cell be highlighted and a border added as it moves through the range so the user can see where he or she is in the sheet?

[@LearnitTraining]

Hi David! You can get help at Offsite, our online community - www.offsitebylearnit.com

[@dailycattv2323]

Are you providing the same template for us to follow through?

[@LearnitTraining]

The link to the exercise files is in the video description

[@ceciliafarkas2705]

You are an amazing teacher. Perfect speed, easy to follow instructions, straight logic, no unnecessary repetition. Loved it!

[@LearnitTraining]

Thank you for watching!

[@mereymeiram]

In the exercise files there are no: Sorting Filtering Charting Sparkliness Conditional Formatting Pivot Table If you provide us the video can you please provide proper exercise files too?

[@thuyvuong9874]

Do you have a file to download to work with this tutorial? This would be really useful in learning the material.

[@LearnitTraining]

The link to the exercise files is in the video description

[@is20206]

It would be really nice if you included a link to a practice sheet like yours to follow along. Thank you, great content!

[@alinaqi1616]

same

[@LearnitTraining]

Added!

[@blessedowo1958]

1:19

[@ingridjocelynab1]

@@LearnitTraining where? there is not sorting sheet in the file

[@haydnburke6171]

@Learnit Training The dataset is missing the sorting, filter etc tabs

[@motoman361]

Is there an exercise file that is associated with this one can access. Just subbed, did the basic tutorial and want to build on the momentum.

[@Brinky645]

Thank you so much sir I am Really appreciate to tutorial 😍

[@LearnitTraining]

You are welcome!

[@sushants149]

Thanks for your video. Can u share some exercise for practice if u have

[@LearnitTraining]

The link to the exercise files is in the video description

[@kulmwuhn]

Thank you for sharing this! It has helped me so much :)

[@LearnitTraining]

You're so welcome!

[@mreighties2860]

Hello, How can I access the files so I can work side-by-side using the sheet file and watching the video? Do I need to join? Great videos btw!

[@juancruzdeelias7050]

Hey man this is great!!! I just wanted to clarify something you seemed to miss when you were explaining the VLOOKUP function or maybe i'm wrong and you can correct me!! When you are using false in the last argument of the function it's not necessary to have the data in ascending order. For example, im using this function in my bakery spreadsheet to calculate my recipes and more. I have a sheet with the list of ingredients, the price and the weight of each. And then, i have a recipe calculator that i duplicate every time i want to calculate a new recipe with the vlookup function for every price and weight of ingredient searching by the name of every ingredient in my page with the list of ing. So everytime a price changes i can change it only in my list of ingredients sheet and it will automaticly change in the other pages. I hope im right jajajsjsjj if not i'll have to change everything!!!

[@LearnitTraining]

If it works for you it works

[@mrCetus]

Thanks a lot. Very informative. Inspiring. Revealing. Impressive. Interesting. Very eager to learn many more from you in the days to come. Very useful for students & professionals.

[@LearnitTraining]

Glad you liked it!

[@lovelyhanagold5012]

Hi, can Google Sheet use to automatically key in website form (like key in FEDex or DHL Post form)?

[@LearnitTraining]

Hello! You can get help directly from our instructors at Offsite, our online community - www.offsitebylearnit.com

[@akshatmeena1668]

For those people who check the ocmments to see if the video is fit to watch/learn. Then, heer's my testimonial, Just go for it. This one is surely to make to grasp each and everything easily.

[@LearnitTraining]

Thanks for the endorsement!

[@CranberryPointe]

~Now beginning Digital Marketing Certification with Pathstream in Preparation for Pollinator Steward Certifcation and Project Planning for Pollinator Partnership Grant funging~

[@LearnitTraining]

Sounds like fun!

[@1gopalakrishnarao]

Thanks a lot. Very informative. Inspiring. Revealing. Impressive. Interesting. Very eager to learn many more from you in the days to come. Very useful for students & professionals.

[@LearnitTraining]

Thank you for subscribing Gopala! We have a big 2021 planned and we hope you enjoy all our future videos!

[@abhishekbharti1882]

@@LearnitTraining can I get the link to download this sheet containing data so that I can practice while watching. Would be really grateful to you all🙏

[@bushrashaikh3190]

When I select with ctrl+a all sheet get selected. How can I select only the rows and columns I filled?

[@paullemaron5258]

Hello, please note that the file is view only and you will need to create your own copy to enable you to create a custom filters view. Thought you should know.

[@LearnitTraining]

Thanks for letting us know!

[@Beto0422]

Love the way you explain,thank you. but didn't find what I needed . How can I reach out to ask you what I need?

[@LearnitTraining]

This live class may help:www.learnit.com/courses/google-sheets-introduction

[@antonmursid3505]

Antonmursid🙏🙏🙏🙏🙏✌💝🇮🇩🇮🇩🇮🇩🇮🇩🇮🇩✌🙏

[@antonmursid3505]

Antonmursid🙏🙏🙏🙏🙏✌🇮🇩🇮🇩🇮🇩🇮🇩🇮🇩✌🙏👌

[@LearnitTraining]

👍👍👍👍👍

[@michaelrwimberly1914]

Frequent users will embed this info & use it...casual users like myself, we'll I hope I can remeber

[@LearnitTraining]

We hoped we helped you remember alot!

[@MohammadEkram-hm9ug]

I need more advance such as custom formula advanced ,

[@isabela_1112]

Great video! But the sample worksheet doesn't have the Sorting up to Pivot Table sheets.

[@LearnitTraining]

Working on fixing that soon!

[@davidmmmc]

Thank you! however could you include the practice sheet for sorting, filtering, the first one your are using?

[@theav.1313]

Are you providing the template for this tutorial to follow through? Great video!

[@LearnitTraining]

In the description

[@jsjb3468]

Thanks bro. Google sheets was explained smoothly by you in a way easy to catch on. Very beneficial tutorial. 😘💗

[@LearnitTraining]

You are very welcome!

[@greatrespect1549]

you really sound like sheldon cooper. btw thanks for this wonderful video..

[@LearnitTraining]

Thank you great respect! Joe takes that as a compliment!

[@anand3238]

Great video. Can you please make a video for google apps scrit from beginer to adavance..

[@LearnitTraining]

Hi Anand! Yes, we are currently building the curriculum for that class!

[@Rajagopalsprabhu]

Kudos! Appreciate your clear presentation, professional and methodical, step by step which makes grasping easier.

[@LearnitTraining]

Glad you enjoyed it!

[@delpill]

Great job! It's a very clear tutorial and a great effort. Thank you !

[@LearnitTraining]

Glad it was helpful!

[@pedromedina7306]

HI. Thanks for all. Do you have a video for Google Data Studio.?

[@LearnitTraining]

We do have it listed to produce this year!

[@moralcare6662]

Is there a way I can select from a data validation drop down list and make another cell pre-fill with a paragraph. For example, a drop down list for lions, tigers, bears and when you select bears - another cell will auto-fill with information regarding bears. If that makes sense? I've been at it for hours .. going out of my mind! Thanks :)

[@LearnitTraining]

Hi Moral Care! You can get your question answered at Offsite - our online community - www.offsitebylearnit.com

[@moralcare6662]

@@LearnitTraining Thank you :)

[@arwaalduqi1052]

Hey I can’t work on exercise file please can you give access to follow up with you

[@LearnitTraining]

Hello Arwa! Access was granted!

[@madhobihasnamerry8094]

please share the practice sheet..without it its very difficult to do the task with you.I want to practice it too please!

[@LearnitTraining]

Hi Madhobi! The link to the exercise files is in the video description!

[@okon1624]

You’re awesome.. please can you make a video of ‘how you insert/put the currency symbol’ in that “note”, that talks about department bonus. Thanks..

[@LearnitTraining]

We will look into it!

[@okon1624]

@@LearnitTraining ohh thanks 57 minutes precisely.

[@mkmac9539]

Hi. I want to change the lowest value of a column based certain conditions of another cell. More specifically, if the value of a cell (say B99) is greater that the lowest value of any cell in column A, change that lowest value in the cell of column A to be the value in B99. Is this possible? If so, can you offer a solution?

[@MsMadlenne]

Great video. I always was struggling with Google Sheets, now I believe it should be easier to work on them. I need to make myself similar file and just exercise. Thank you so much, Joe!

[@LearnitTraining]

Glad it was helpful!

[@TheAmazingKris]

Thank you for sharing in details and how-to in this video. Wanted to know it´s benefits and how I can be better within the Google Sheets opportunities and especially those formulas. Can or will always use this one for advice in the future.

[@LearnitTraining]

Thank you for the kind words!

[@TheAmazingKris]

@@LearnitTraining Perhaps a video, where you create those formula in a worksheet, where we can create the formula as well on our own template ?

[@roshnirathore9672]

It would be really helpful if you add the link of Pear company payroll information - Data File with Exercise File, Thank you .

[@LearnitTraining]

Exercise Files: bit.ly/3udealu

[@roshnirathore9672]

@@LearnitTraining This is not the data set file .

[@CharlesRodgers-m9l]

This tutorial doesn't seem to be any use of Apple users! Is there a version that is?

[@LearnitTraining]

This article may help: toolingant.com/how-to-get-google-sheets-on-mac/

[@imakelegostuff8684]

My technology teacher when we do pixel art: Google Sheets is also a pixel art platform Me: Wait. That’s illegal.

[@fasaquotes]

Hi, i created a dropdown list with list items in Google sheet. I want for last item naming "Other" enable any name or text want. You can say a sub category or sub dropdown type thing. Please help. Thanks in Advance

[@channibedi]

An excellent tutorial with exceptionally perfect presentation skills! No time waster, to the point. Much appreciated!

[@LearnitTraining]

You're very welcome!

[@kalokeri2009]

the formulas you put aren't working on my sheet. why;

[@LearnitTraining]

Hello Kalokeri2009! You can get help at Offsite, our online community - www.offsitebylearnit.com

[@MGSV626]

What an excellent tutorial! I learned so much ... and I thought I knew Sheets well. Thank you

[@LearnitTraining]

You're very welcome!

[@Ninjatravels28]

my named ranges isnt working .... any idea? it just says "no named ranges"

[@LearnitTraining]

Hello Christian Soriano! You can get help directly from our instructors at Offsite, our online community - www.offsitebylearnit.com

[@light_hanter]

The future of education - projects like Learnit Training. Your course has traveled all over the world. Спасибо большое! 🙏 I have a little favor to ask you. Please share an educational file. It would be much more useful to copy the file and repeat all functions. Thank you again! 🙌

[@LearnitTraining]

Wow, thank you!

[@mixera6077]

How to sort a single Column without changing other column values.. 🙏🙏🙏

[@Veganbhavna]

Thank you for making a great tutorial that was easy to understand. You are an amazing teacher!

[@LearnitTraining]

You're very welcome!

[@Smartienl72]

Thank you for the clear explanation. I miss this skill on many education channels on KZbin. I also have the question whether this sheet can be shared.

[@adios04]

Yes it can, click on the share button at the upper right. This was in fact shown in the video at about 1:25:00

[@amaajith9297]

Can you please provide all these datasets?

[@LearnitTraining]

The link to the exercise files is in the video description

[@JoeTao]

Wow this is amazing teaching, thank you so much

[@LearnitTraining]

You are very welcome!

[@abrahamgarza537]

A link to practice would be more helpful.

[@LearnitTraining]

The link to the exercise files is in the video description

[@DivyanshuBansal-c3l]

Thanks for the great walkthrough! You have an amazing teaching style, with a coherent thought process and realistic examples. The presentation had a logical flow, and the way you explained each concept, building on the previous ones, was excellent. Thanks, Joe! 😊

[@LearnitTraining]

Glad it was helpful!

[@mahfuzulhaque5441]

Great learning with you ! Thanks a lot !

[@LearnitTraining]

Glad to hear that!

[@RR-xs9yf]

Where could I download the sheet for practicing purpose, thx.

[@LearnitTraining]

The link to the exercise files is in the video description

[@ingridjocelynab1]

@@LearnitTraining but they do not match the one you are showing: filetring, sorting, etc

[@ginalynpinos2484]

Thank you so much! This is really helpful, concise and objective presentation.

[@LearnitTraining]

You're very welcome!

[@hassanmehdi3175]

is any option If date is add in Google sheet so respected column is only fill on that date ??

[@deechenjenkins]

Very good tutorial. A question for you, if I have three columns - budget, actual, variance. Is there a way to use "iseven or isodd" function to color the three columns/rows differently?

[@zeldaman1190]

You would need to use conditional formatting,

[@ahsnsb]

49:52 read names of sales people lol

[@alekdaniels]

This is great. I thought I know everything about Google Sheets but that Macro recording part just blew my mind. Would really save so much work. Not gonna tell my boss about this so I get free time. Work smart hahahaha jk

[@LearnitTraining]

Hi Alek! We are glad we made your life a little easier!

[@gokulsrilakula2071]

how can I import the values(in the cells) from another sheet in the same workbook??

[@sepandsarmadi5925]

very much enjoyed it. thankyou very much. it was very organized and well planned.

[@LearnitTraining]

Glad you enjoyed it!

[@getrichsmart]

Thank you for all the information in this video. What I really want to know is if you can make a video on how to link just an image that is saved on your CPU and that will only open on the sheet if you hover over the text it's tagged to in a cell with your mouse or click it to open. Also at the same time, giving the link a shorter name : Like "Price" and not the full name c:\desktop ewfile\price. I don't even know if this is possible. Thank you again. Looking forward to your reply.

[@LearnitTraining]

Great suggestion!

[@Sociography00]

Thanks!! it is extremely helpful

[@LearnitTraining]

You're welcome!

[@konstantinorlovskii8719]

Thank you so much! I loved your explanation. May you please make your exercise files editable for everyone? I can only view them now.

[@LearnitTraining]

Please feel free to download a copy to edit.

[@nudger1965]

32:05 You could have also used the alternating colors feature directly under the conditional formatting in the menu shown here to do the same thing without the formula.

[@LearnitTraining]

Thank you for the great tip!

[@tylerbarbaree7007]

Advanced users used to write multi-level, formulas and macros.. Now they're learning the most basic functions of all... You can tell society is in trouble with this is considered advanced

[@brilliantpy]

Thank you for creating a very helpful and easy to follow video! Great job!!! :) :) :)

[@LearnitTraining]

You're very welcome!

[@lepalmpremium2288]

Thank you for sharing this amazing knowlegde with us!!! It really helped me a lot!!! You're awesome!!!

[@LearnitTraining]

You are so welcome!

[@DanOfek]

THIS WAS AMAZING. Thank you so much, explained beautifuly and very useful. Boosted my knowledge. Shared with the entire team.

[@LearnitTraining]

Awesome, thank you!

[@e_productions]

What browser are you using view codes?

[@LearnitTraining]

Hi Mutha Truckers! The browser used in the video is Chrome

[@NjonjoNtui]

Thanks again for this great video.

[@LearnitTraining]

Glad you enjoyed it

[@tonyohore288]

can i get the practice sheet it will be really helpful

[@LearnitTraining]

Hi Tony! The link to the exercise files is in the video description

[@FreeFireEntertainment]

Thanks for your explanation 😊

[@LearnitTraining]

My pleasure 😊

[@panhacambidia7857]

Please give me the practice file link. Thank in advance.

[@LearnitTraining]

The link to the exercise files is in the video description

[@faheemqadri5457]

Great way to teach in a simple way with details. No time waste like others. Big thank you from India

[@LearnitTraining]

You are extremely welcome Faheem!

[@s455am]

Thank you ❤

[@LearnitTraining]

You're welcome 😊

[@РадостинаЦонева-т6ь]

If you're looking at a Google Sheet with other colleagues, you can create a filter view that only changes your view of the data. What are some actions you can take?

[@LearnitTraining]

Hi Радостина Цонева! You can get your question answered at Offsite, our online community - www.offsitebylearnit.com

[@Financial_Guru]

Anyone knows how to get the practice material? The link in the description lets you access a file which is missing though half the tabs are not there... Am I doing something wrong?

[@RiskyInvestor001]

learned a job skill in 2 hrs, easy & quick, thanks joe

[@LearnitTraining]

You are very welcome!

[@user-zh4gq8lj8l]

Is here anyone who teach Google sheets online?

[@LearnitTraining]

Yes! You can get live class here: www.learnit.com

[@BenDieselBasicAutomotive]

Wow.... new knowledge for me... Thank you very much and more power to you.

[@LearnitTraining]

Our pleasure!

[@rashmiranjan86]

Hi, Thank you for the video. Would you please assist me here. I have a situation where I wanted to subtract the respective row value from grand total in a pivot by using calculated field. Is it possible?

[@LearnitTraining]

Hi Rashmiranjan! You can get help at Offsite, our online community - www.offsitebylearnit.com

[@Mrchickenwing74]

There is missing data for the 2020 year on the Pivot Tables exercise

[@ramyaboelhamd3948]

Is there any data available for practising?!

[@LearnitTraining]

The link to the exercise files is in the video description

[@MaiteMavila]

I loved the video. You have an excellent teaching style. How can I find more of your google sheets videos?

[@LearnitTraining]

Here is our Google Workspace Apps playlist: kzbin.info/aero/PLoyECfvEFOjYtaQDCoHlF_maq6aJdpQPF

[@lazertuiyope]

Hey , I need a fast response if possible . Is it possible to add multiple x axis instead of the y axis that is the default for Series ? I can only add one series of value in x ... 2 hours I search on internet for this and I just can't find

[@LearnitTraining]

You can get your question answered at Offsite our online community: www.offsitebylearnit.com

[@p.j.882]

Advanced....but not for calculus.... Taylor series...etc...

[@Panda-pp8xl]

thanks for this helpful video

[@LearnitTraining]

Glad it was helpful!

[@winwinis3483]

Extremely well organised and presented - no fluff - brilliant thanks

[@LearnitTraining]

You are welcome!

[@oldmaninthemirror]

Maybe we want to open a sheet and be able to go to the end of entered data in that sheet to add new data? Is that even possible?

[@martaolaso1012]

Hi, the table in the exercises doesn't correspond with the one you're using to explain it. Is there a way it can be reupload it?