Google Sheets Advanced Tutorial
HTML-код
- Опубликовано: 6 июл 2024
- Google Sheets Advanced Tutorial
Get Ad-Free Training by becoming a member today!
/ @learnittraining
Exercise Files: bit.ly/3udealu
Who it's for: Anyone looking to gather, format, and interpret data in a spreadsheet.
What it is: Google Sheets is Google’s free, web-based spreadsheet application that mirrors the magic of Microsoft Excel, with some standout features and key differences as well.
What you'll learn: First, students will be shown how to navigate the app. Then, they’ll learn the basics like creating and sharing spreadsheets. Next, they’ll learn how to calculate data with functions and formulas, as well as how to filter and sort all their data. Finally, users will get some hands-on time with popular features like Pivot Tables, AutoFill, VLOOKUP, Macros, and more.
For ad free training and certificates please join Learnit Anytime:
www.learnitanytime.com
Enroll in our live, instructor-led Google Sheets classes:
bit.ly/3zT2PcO
For Private Group Trainings please visit:
www.learnit.com/private-group...
Start 0:00
Introduction 0:03
Single and Multi-Level Sorting 0:11
Filtering Records in a List 3:47
Search Filter and Filter by Condition 7:32
Custom Filter Views 10:07
Inserting Data Charts 13:15
Formatting and Editing Chart Elements 14:58
Adding and Removing Data from Charts 22:48
Inserting Sparklines 25:11
Alternating Colored Rows 30:46
Alternating Colors Button 34:08
Creating a Pivot Table 35:30
Creating a Pivot Chart 44:21
Filtering Within Pivot Tables Using Slicers 46:48
Using the IF Function 49:12
Introduction to Nesting Functions 57:13
VLOOKUP Function 1:00:39
Using the IFERROR Function 1:08:01
Creating and Applying Names in a Worksheet 1:11:02
Summary-Based Functions SUMIF(S) and AVERAGEIF 1:13:02
Text Functions Left, Right, Mid, Concatenate, and Split Text-To-Columns 1:19:41
Sharing and Managing Permissions 1:24:52
Macros 1:28:14
Conclusion 1:34:23
#GoogleSheets
(C) 2021 Learnit, Inc.
Any illegal reproduction of this content will result in immediate legal action.
![[ GUILTY GEAR STRIVE: DUAL RULERS ] Teaser Trailer](http://i.ytimg.com/vi/e4TDqaE3XAg/mqdefault.jpg)
![Hands-On Power BI Tutorial 📊 Beginner to Pro [Full Course] ⚡](/img/1.gif)
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
Thank you very helpful!
You are an amazing teacher. Perfect speed, easy to follow instructions, straight logic, no unnecessary repetition. Loved it!
Thank you for watching!
An excellent tutorial with exceptionally perfect presentation skills! No time waster, to the point. Much appreciated!
You're very welcome!
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!
Glad it was helpful!
Kudos! Appreciate your clear presentation, professional and methodical, step by step which makes grasping easier.
Glad you enjoyed it!
OMG what an amazing lesson! Holy cow I learned so much. This lesson was presented so well and totally demystified spreadsheets, just amazing. Thank you so much for making this available! I can’t believe it’s free! 🙏
Thank you so much for the kind words!
Great job! It's a very clear tutorial and a great effort. Thank you !
Glad it was helpful!
I failed twice in school & never could understand this basic mathematics. With your hints & easy going explanation, I understood it. Can't imagine how insane that is.
You are very welcome!
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.
Thank you for subscribing Gopala! We have a big 2021 planned and we hope you enjoy all our future videos!
@@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🙏
Great way to teach in a simple way with details. No time waste like others. Big thank you from India
You are extremely welcome Faheem!
Extremely well organised and presented - no fluff - brilliant thanks
You are welcome!
I love that you have provided a document to follow along with. I'm a little lost though, I seem to be missing Filtering through to Pivot tables in the sheets provided. I'm still getting some good info, but it's a bit harder to practice and cement things in my head.
Learning from excel to google sheet wasn't a steep learning curve for me because of this tutorial. Thanks so much for creating informative videos.
You're very welcome! We do have a video coming soon for Excel Users switching over Google Sheets as well.
Thank you for the clear explanation. I miss this skill on many education channels on RUclips.
I also have the question whether this sheet can be shared.
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
A wonderful tutorial about Google Sheets. Thank you very much for the time and effort. It cleared a couple of things for me.
However, just a small edit - @ 01:02:10, you mentioned that the data needs to be sorted for _VLOOKUP._ _VLOOKUP_ and _HLOOKUP_ functions don't need the data to be sorted. That condition only applies when using the _LOOKUP_ function.
You're very welcome!
got some useful trick and tips. Thank you, Joe. while adding the data in the table didn't get how to refresh in pivot table and chart and also I try to edit macros but didn't get the edited macros after I reopened next time. overall it is a great session when the session is lead by Joe.🎉
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 :)
Wow, thank you!
Great work Joe. Thank you!
Thank you for watching Victor!
This is brilliant! I learned everything from the scratch! Keep up the good work! Thank you so much!
You're very welcome!
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.
Extremely useful tutorial. The information was presented in a really simple and easy to understand way, thank you.
Glad it was helpful!
Really appreciate the great content you showcased here. Been using Google Sheets for years and didn't know almost any of this. Or at least not nearly to the point that you explained it. Thank you so, so much!
You're very welcome!
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!
Excellent overview of advanced functions. Thanks.
Glad you liked it!
Thank you! however could you include the practice sheet for sorting, filtering, the first one your are using?
What an excellent tutorial! I learned so much ... and I thought I knew Sheets well. Thank you
You're very welcome!
You are a really good teacher. The video was easy to follow.
Glad it was helpful!
learned a job skill in 2 hrs, easy & quick, thanks joe
You are very welcome!
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?
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?
You would need to use conditional formatting,
A really helpful and well produced video. Thank you.
You're very welcome!
very much enjoyed it. thankyou very much. it was very organized and well planned.
Glad you enjoyed it!
Hey Joe!
Thank you very much for your courses about Google Sheets! They are pretty useful!
You are very welcome!
I like this. You talk fast and concise💕
Thank you for watching Mary Ann!
Really love the way you presented all things, an amazing experience of learning with you Sir, thanks for the great content.
You are very welcome!
how can I import the values(in the cells) from another sheet in the same workbook??
Thank you so much! This is really helpful, concise and objective presentation.
You're very welcome!
This was so insightful. You have definitely made the viewers day. Thank you so much for sharing 🙏
You're so welcome!
Very informative and a great presentation. Thanks Joe for you time.
You are very welcome Chuck!
Thank you for making a great tutorial that was easy to understand. You are an amazing teacher!
You're very welcome!
Awesome tutorial about various functionalities within Google Sheets! Thanks a ton!
You're very welcome!
Basic Information is available in an easy and Clear way. Thanks
You are most welcome!
Thank you! I learned some new things.
Glad it was helpful!
Amazing tutorial, man, congratulations!
Thanks a lot!
you explained very clearly and useful for many people, but this is not as advanced as I thought
thank you for the class it helped alot
Glad it helped!
Thank you for sharing this! It has helped me so much :)
You're so welcome!
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. 🙂
Thanks for the feedback!
It would be really nice if you included a link to a practice sheet like yours to follow along. Thank you, great content!
same
Added!
1:19
@@LearnitTraining where? there is not sorting sheet in the file
@Learnit Training The dataset is missing the sorting, filter etc tabs
I learned alot and it kept me company when i was cleaning, so my place is clean and i learned a new information. Thanks for that 1hr of lecture! 🙌
Thank you for watching Jein!
1:12:07 When naming the range from A10-I46, does that eliminate the need to put in the $ symbols? Great video by the way.
Hi Eddie! You can ask our instructors questions at our community Offsite - bit.ly/2MHiMyM
Thanks for this awesome video. I have been using it in chunks to help my students!
You're very welcome!
Thanks so much. This was an excellent training!
You're so welcome!
How do the parameters of the if formula pop up after opening brackets?
Wow, Joe. Thank you. You are a phenomenal teacher.
You are very welcome
Clear, concise and highly informative. Thank you ,
.
You are welcome!
Is there a way when a cell is filled with a name then the cell next to it can be automatically filled with a value?
For example, if Cell A1 was filled With "my name" then can cell B1 be filled with "surname" and is automatically triggered when the cell is updated with a value
This was AMAZING....THANKS A LOT!!!
You're welcome!
Thanks!! it is extremely helpful
You're welcome!
Appreciate for you turorial!
You are very welcome!
Awesome video! What is the tool that you guys use to write on the screen during explanations?
Hi Stas! That tool is Zoomit!
Thanks for this great course. I learn a lot from this course. Very very thanks 👏👏
You are very welcome
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?
Do you have a file to download to work with this tutorial? This would be really useful in learning the material.
The link to the exercise files is in the video description
You are amazing thanks for teaching us😊😊
Thanks for all your efforts. Quite informative and useful.
Glad you like them!
Do you have a tutorial on forms and how they feed into sheets?
Thank you for this amazing class. I learned a lot. Thank you again and god bless you.
You are very welcome!
THIS WAS AMAZING. Thank you so much, explained beautifuly and very useful. Boosted my knowledge. Shared with the entire team.
Awesome, thank you!
thanks a bunch for the video. Really appreciate your time and energy u spent for sharing your knowledge with us..
Glad it was helpful!
Thank you for creating a very helpful and easy to follow video! Great job!!! :) :) :)
You're very welcome!
When I select with ctrl+a all sheet get selected. How can I select only the rows and columns I filled?
Thank you very much for presenting the information in such a precise and detailed way. I truly enjoyed exercising with you. Good job!
You're so welcome!
Some sheets shown in this video (e.g. Pivot Table) are not included in the Exercise Files linked in the description.
Thanks for sharing nice information.
Thanks for watching!
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.
Thanks for the endorsement!
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?
I appreciate the sample worksheet so we can follow along, at the same time, I hope someone from your team can take a look at the tabs cause we're missing quite a lot. It doesn't have the sorting, filtering and pivot, if I may name a few. Thanks again!
Hi Jey C! Looking into it!
@@LearnitTraining thank you very much!
@@LearnitTraining A ton of them is still missing
Thank you for this video. Very informative! I have a question regarding column charts. When include data labels in the columns, is there a way to have the data appear vertical within the column opposed to horizontal?
Hi Josh! You can get your question answered at Offsite, our online community - www.offsitebylearnit.com
Thank You So much for this course.
You are very welcome Pradip!
Perfect is the only word that describe your videos ,thanks a lot for this amazing work
You are very welcome!
Really Informative video thanks for explaining so clearly.
Glad it was helpful!
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.
Thank you for the great tip!
Thanks very much for an excellent presentation.
You're very welcome!
Thank you!
You're welcome!
Thanks so much 😊
You are very welcome!
Thank You very much
You are welcome
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! 🙌
Wow, thank you!
If I wanted to turn this into a gradebook for teachers, how could I input a formula which would automatically calculate grades?
Great tutorial- Many thanks!👍
by setting grades and using the if function
Amazing work brother, really appreciate it!! Thanks.
Glad you liked it!
That was really helpful. Thanks
You're welcome!
thanks so much for this perfect course
You are welcome!
Thank you so much for a great content!
Thanks for watching!
Great video! Thanks :)
Glad you liked it!
Great Video, Thank you very much!!
You are welcome!
Thank you for sharing this amazing knowlegde with us!!! It really helped me a lot!!! You're awesome!!!
You are so welcome!
Thank you much for clear and easyo to follow tutorial.
You are welcome!
Just Amazing !
Thank you Sugandha!
Thank you so much Joe Patti 👍
You are very welcome
love your teaching style
Glad to hear that!