Google Sheets Tutorial for Beginners 🔥

[@coupleracademy]

If you liked this video, check our other tutorials to supercharge your Google Sheets experience 🚀 🔵SUM, SUMIF, and SUMIFS functions kzbin.info/www/bejne/hquxmJ-ebZaBd68 🔵conditional formatting basics kzbin.info/www/bejne/hZaXm4yYob2qbs0 🔵ARRAYFORMULA basics kzbin.info/www/bejne/eoaZi6F_gJ5lra8 🔵data validation basics kzbin.info/www/bejne/e5LCeKVsis2ipNU

[@brylzenarosa5379]

Thanks! Here's a guide to the sections of the video. :) 00:11- Creating a new spreadsheet 01:31- Converting .csv and .xlsx files to Google Sheets Files 02:25- Creating and Formatting sheets inside of a spreadsheet 03:35- Adding and Customizing columns 05:11- Creating a Database 05:57- Formatting Data and Cells 07:55- Useful Shortcuts 08:20- Smart spreadsheet features (pasting values, format, transposed, sequences, using Math operators (* / + -) 10:10- Anchoring values using $ sign 11:00 - Basic functions/formula (SUM, AVERAGE, COUNT) 12:10 - Share and collaborate

[@harshpreetsingh63]

😊

[@jwa7378]

People like you are what we need!

[@brylzenarosa5379]

@@jwa7378 Thanks! Glad to be of help.

[@rushikumarpatil3538]

It is already available in Description, lol

[@langstonreese7077]

tyyyyyyyyyyy!

[@elizabethwest7722]

This is excellent for someone who wants a refresher of various functions in Google Sheets. Please consider doing another video for absolute beginners and you explain it more slowly.

[@coupleracademy]

Elizabeth, thanks a lot for your feedback. We will think about recording another video in a more slow thorough manner. You can also modify the playback speed in Settings of this video (bottom right corner).

[@ruthvlessing3356]

I would also like a much slower version of this, its too fast for me to follow... I have to go back many times to review every couple of sentence a number of times...

[@NotThatBob]

@@ruthvlessing3356 Hello! I watched this video at .75 speed. Sounds a little off, but for me the speed was perfect for following along and also pausing at the right spot. All the best

[@GivingIsMyGift]

Its not just too fast it was too advanced for a beginner...

[@dreamervanroom]

@@GivingIsMyGift Hi there. I have a pride in being able to explain things at any level. On the other hand it's something I work at not a talent I have. I'd love to hang out with you for some time and figure out what you need which will help me make something like that. I don't work for Google but I have found in my life that teaching something is an excellent way to learn it better. Right now, I'm again a beginner in making spreadsheets. Of course I think I understand all the concepts but applying them is something specific. I don't know how we'll figure out how to connect since Google insulates these things so well, but willingness provides opportunity. Reddit might be a good way, with private messages.

[@allenweg2312]

I'm new to spreadsheets altogether so came into this as a TRUE beginner. Tightly packed with information, really amazing and extremely helpful. But found it EXTREMELY fast for this older user (in my 60s) and had to pause and rewind many times throughout. Also, there were a numer of times where the actions illustrated visually took place a second or two BEFORE the verbal instructinos were made, which I found difficult to process- I would have preferred the verbal instruciton first, followed by the visual illustration- that 1-2 seconds made a big difference. Appreciated the subtitles as well, because it helped me to hear and process the information more effectively. Thanks!

[@coupleracademy]

Thank you for your feedback, Allen! We've taken it into account and will try to go at a slower pace next time. You may also want to take a look at our Google Sheets Tutorial for Beginners article: railsware.com/blog/google-sheets-for-beginners/ Maybe it'll come in handy for better information perception.

[@krblr2007]

true; the video did not clearly show how to freeze a row header, and I had to move on and search for another video

[@susandarosa4614]

I totally agree she goes way to fast

[@tiffanyc9730]

It moves a little fast for someone who has never used spreadsheets before. Good overview.

[@coupleracademy]

Tiffany, thank you for your feedback! in web version, you can modify the speed of the video. Use Settings (bottom right corner of the video window) -> Select the Playback speed

[@Tricks99_Official]

@@coupleracademy I've used the Playback speed - option, but it's killing the interest to watch! :/

[@ruxandrai6029]

Same here..... from the minute 10 i could not keep the pase. Not all the video is for begginers. Thanks

[@Actualhumanlive]

@@coupleracademy THe speed of the video is not the issue. It is the glossing over of concepts such as "pulling the data from the next cell after 12" when referring to another sheet. You did not explain what this means or why it happens. It's just something you said and I have rewound that part multiple times to try to understand what you mean by that.

[@dreamervanroom]

@@coupleracademy You can modify the speed on an Android device as well. You touch the three dots in the upper right hand corner and they give you choices. Myself, I often listen to things at faster speeds. It helps me pay attention so that my mind doesn't wander. On the other hand, if I need to think things over as the person is speaking, or if the accent is difficult for me, I can -and do- listen at 0.75. If I miss a word, then go back and listen again and miss it again, I also use the speed button to replay that section. That almost always works for me.

[@thomaswright2614]

I was just confused before I watched this video, now I'm mega confused.

[@MsGoddess3]

me too. She talked way too fast.

[@noorm7781]

Why you were confused? I'm confused about that.

[@laurenzojames]

same

[@shifaabid1425]

@@noorm7781 yes, I am also confused about his confusion??!

[@blvkkgoku3359]

Me too

[@Kate1427]

Its a lot of clear information at a fast pace. I'm experienced with excel and had some difficulty following along due to the volume shared. I'd label the title differently.

[@fygg1]

This video was fantastic - I took it to an AARP group and everyone ended up comfortable using excel after listening only a few times. The only ask they had was: since English is not your first language (but yours is very good), slow down rather than speed up to make sure you clearly pronounce all of the syllables needed for comprehension. For example, it is BUTTun (not bottom), FEELD (not filled), AWEtomatic (Not OW-to-matic), comMAND (not comment) -- and pay attention to your stresses. For example, is FOR-mat (not formint), SEE-kwnece (not sickens), LOCK (not log), pa-REN-thuh-sees (not parathesis) etc. Maybe small things, but it would have made a difference to the older audience, which I'm imagining is yours. Thanks again for this video

[@coupleracademy]

Hi! Thank you so much for your valuable feedback. We'll pass it to our content creators and will work to improve future tutorials. And we're very glad your group found the video useful. Thank you once again!

[@terrychrist1383]

I'm a senior trying to learn. I do like that you talk to where I can understand you. But would like it to be slower so I can comprehend better. Thank you 😊❤️🙏

[@zedyasay5995]

You can adjust playback speed in "settings"!

[@coupleracademy]

Thank you for your feedback. For this particular video, the playback speed of 0.75 might help. In the future, we will record slower presentations, as this was often mentioned.

[@joem500]

Loved it. I especially loved learning how creating calculations on another tab would be especially helpful. Changing variables row by row, column by column seemed loathsome. Thanks!!!

[@coupleracademy]

thank you for your kind feedback:)

[@alexismercury]

Anyone from ALX here?

[@phoebeojal8836]

Here I am

[@ZinosVlog_1]

We are here ohhh

[@Aishaarh]

Bruh I just got here 😂😂😂

[@funox1467]

here me

[@geryndiy]

Офигеть крутая история по геометри деш молодец вернам продожай в том же духе

[@jstagzsr]

Holy crap..... It will automatically add up values from any two rows or colums and continue on the pattern of adding and add the new values to the rows or colums for you????? are you kidding me?? you know how much time this just saved me!!!!!!??????? THANK YOU!!!!!!!!!

[@trettery4438]

thanks a lot! i had a science assignment with calculating planet sizes and scaling them down. 7th grade is hard but you made it a little easier :)

[@coupleracademy]

Awesome, glad we helped! :)

[@mr.serenity7203]

OMG. I really loved this. I'm super new to this whole Googlesheets and Excel stuff. This stuff looks intimidating as hell haha. I don't have a solid understanding, but after taking notes on paper and trying out the drills on my Googlesheet, I feel like I learned an amount. Thanks for the educational video :)

[@noahplayz2224]

I aint gonna lie google sheets is probably the hardest google site to learn how to use, but this video helped me understand it

[@saharaleebolo2759]

Very short and simple but very informative! Thank you. I'm watching this because I applied for a promotion and I need to be well versed with google sheets. I hope I get it. 🙏

[@coupleracademy]

Good luck! happy you found it helpful:)

[@pamelamclaughlin4845]

Extremely well presented. Language is concise and no ad libs. Additionally, very informative. Very much appreciated. THANK YOU!

[@coupleracademy]

Glad it was helpful!

[@fun-club]

kzbin.info/www/bejne/qYjFZ3t-hbaSiNk

[@FatmanEsBueno]

Thanks for this millennial friendly tutorial, love the speed through and foreign accent, really holds my attention. 9 out of 10 would continuously watch all the way through

[@coupleracademy]

great, happy you've liked it!

[@aniwangmo7220]

This video was perfect. I am comfortable with computers for the most part and was able to open a blank spreadsheet and try things out by pausing the video and then coming back. Excellent introduction for basic functions, Thank you!

[@dianach3286]

Thank you so much! I will start working with an american company and they told me to know about google sheets, Very useful!

[@kristinsturgis779]

Excellent overview. Gave me the info I needed to start a spread sheet with calculations. I paused the video frequently to make my own sheet along side her.

[@coupleracademy]

that's great. Happy you've liked it. In other Google Sheets videos you can find practice sheets drafts with data to try new functions yourself. Just copy the file and use it while watching the video. Find the drafts in video descriptions.

[@datarealmax]

This video is larger than usual, so it's easier to watch in smartphone. Nice!

[@Nobik33310]

Лучшая истроия вернама о гд!!!

[@vinaLloyd]

شكرا بزاف على الشرح... شخصيا تعلمت من قناتك شحال من حاجة الله يوفقك ويسعدك

[@coupleracademy]

إنه لمن دواعي سروري دائماً أن أسمع مثل هذه الأشياء من مشاهدينا!

[@Tech.trendss]

finna create the most extravagant pandabuy spreadsheet known to mankind

[@eriklimbu7366]

Just wanted to give a thumbs up for making such easy content for beginner. I enjoyed the process! Thank you!

[@coupleracademy]

We're so glad to hear that, thank you! :)

[@AB13]

First 10 seconds and I already knew this is the right place to learn google sheets :)

[@CristinaAcosta]

Thank you so much for being so kind and generous. This really helped me out.

[@serahabiona5527]

Brilliant presentation! Well explained, with useful tips that will surely aid the practical exercise.

[@francescamercado9665]

Had no clue about the fact it add automatically date/day/months in order once you write one, so cool!

[@come2nonso]

Who is here from ALX? 😊

[@matmurray717]

This was pretty helpful! Thanks

[@CopywritingBritt]

Thank you! This was super helpful in learning basic functions fast.

[@lolkhalil]

Seen a few tutorials on Google Sheets. This one is just great! Very user friendly, informative and stimulating/motivating to watch it all. - It gives a general idea of the options and why/how useful Google Sheets can be. - It is explained at a very good pace (no need for scrolling back) - The explanation is for all types of ways of learning/understanding something (not getting confused, again no need for scrolling back) If it's good, it is good. =)

[@coupleracademy]

thanks a lot for your detailed feedback! happy you found it helpful. watch our Google Sheets playlist to learn even more!

[@lolkhalil]

@@coupleracademy, I am actually now in the process of doing that =) Thanks again

[@gamingfarm8533]

@@coupleracademy great vedio, thank you! and you so pretty

[@Actualhumanlive]

@@gamingfarm8533 hi creep

[@toughertopsoil975]

wonderful video - thank you for making it , I shall reviewing it several times over the months to follow. Always useful to be able to look back and "refresh" our skills

[@coupleracademy]

you are welcome:)

[@ruthp3237]

I'm so lost. I think that maybe this tutorial would be great for a more advanced learner.

[@saritajoshi151]

Thank you, it really helped!

[@VodkaDoge]

this is so business-grade that i thought it was just an extremely captivating ad at the start

[@AsiqueIkbalAnsari]

Madam you're great! This is very helpful! I'm your new subscriber!

[@ОльгаГанущак-б4х]

It is great video. For those who works in Excel everything is clear

[@ggomez4573]

waoh that woman is so professional a real good speaker for the company. Wish i had a crew like that.

[@waster6482]

Вы тоже тут потому что хотите узнать что это делает в плейлисте у Вернама?

[@sammy_trix]

This is a great video for me and my team, and I hope to apply all of this in our google spreadsheet.

[@recordsdesi2052]

Brilliant & explained in professional way Thanks for information✅

[@KVSmotivationvlogs]

Very informative and easy to understand 🙏🙏 from India 🇮🇳

[@coupleracademy]

Glad it was helpful!

[@MyExcelhandle]

Very good information... I have one query, I have completed some task on 22nd may, after some time I have checked this task completed date the completed task date automatically changed accordingly the current date...so please tell me how can I fix this problem..

[@calebwalters8517]

THIS IS AMAZING OMG HOW DID U DO THIS

[@calebwalters8517]

@@jonjoporter7107 Thank you OMG that is rlly good advice

[@dylanbowater5986]

I learnt something new! Thank you!

[@wintermorillo6567]

Perfect explanation, thank you very much for such a great content!

[@cvkamesh9551]

Super stepping stone for the Google Drive excel sheets

[@khursheed3212]

Thanks for this tutorial....beautiful madam.🙂

[@zhylewheyvenbancog4941]

This is nice to watch and I have learn easily thank you for this!

[@littlespressurewashing]

Just Subscribed 🙌

[@coupleracademy]

Glad to have you on board :)

[@life360..7]

Your channel is really helpful..Thanks 😊👊👍

[@coupleracademy]

Happy to hear that!

[@sekoujabateh6003]

Thanks, & very clear & helpful! Learned something new.

[@jeffreyskye1060]

Very Super Useful Thanks

[@coupleracademy]

You are most welcome 🧡

[@PiousWulf]

Thank you for this video! This was amazingly helpful to me, and I really appreciate it! Keep up the good work! :D

[@TatianaBalashova]

thank you for the video Anastasia, you look lovely in the frame :). I appreciate especially the ending with explaining how notes and comments work.

[@KamranHaider]

Thanks, very useful for a beginner like myself. Can I work on Google sheets on my phone?

[@coupleracademy]

hello! yes, you can if you download the needed GSheets app. It is not handy though. But you can input data on the go if needed.

[@KamranHaider]

@@coupleracademy ☺️ I really appreciate you replying the question. I am into farming and cattle raising on a very small scale. Wanted to manage my cattle inventory through Google sheets, now that I have WiFi at my farm and few cameras will be up soon. Wish me luck. ☺️🙏🙏

[@VlaDragoN7]

Very well made video and explanation. Dyakuyu!

[@coupleracademy]

Glad you liked it!

[@elaineg4636]

Excellent content and teacher. Well organized. I would have preferred a slower format.

[@onemanmusic6572]

This is a very helpful tutorial. Thank you for providing it. I've just subscribed and am looking for forward to learning even more about how to use Google Sheets well.

[@coupleracademy]

great! thank you for watching. We will add more Google Sheets videos this fall.

[@mdakramul2386]

Wws

[@samueldantas6817]

Thank you so much. Very helpful and well explained!

[@alongeabosede9297]

This an excellent tutorial for a new student

[@shanepennino5598]

Hello, I found this video very helpful and it is a good start for me. I am a writer and was looking to use something like this to categorize sections of my story (lore, characters, et cetera) into a simple to use file that I can reference at any point. My question is can anyone recommend a video/article that might help me with developing that? (For example, the best type of layout or template) Thanks again for the tips, much appreciated. Take care

[@positivity29]

This was great and straight to the point and your drop dead gorgeous! A+ all the way 👍 thanks 🙏

[@jigneshsavaliya4703]

strait forward and clear explanation thanks....

[@bnosadvertising3819]

4 minutes in, and I have learned so much already, thanks a lot! :)

[@la_dweng6407]

Alx student much love from 🇿🇦🇿🇦🇿🇦🇿🇦🇿🇦

[@vivianlee5628]

Thank you so much. This was very helpful to me!!

[@coupleracademy]

great! watch our next videos - we will learn even more of the GSheets functions and approaches

[@hectorfernandez743]

Nice tutorial very informative 🔥💯

[@deniselapointe290]

IM SOOO CONFUSED .sorry never worked in an office and never used spreadsheets EVER in my life ...although your explanations are very thorough ....I literally have to dissect this frame by frame ....

[@peterroizen7781]

Have a look at tmaker.site if you want to see a whole other approach based on arithmetic.

[@kalibathullahmohamed5430]

You teaching awesome and you looks so beutiful!!

[@abhishekkumarjha4314]

Very Helpful...Tqqqq🙏.

[@bullymaguire8156]

Just in 15 min , i can listen it for lifetime

[@srinivasmanchi8130]

Thanks for the useful information for starters.

[@jugalgupta7234]

Excellent introduction. Thanks.

[@TeachPitch]

WOW great tutorial

[@DrEEmpLe]

лучшая гд история вернама

[@rayzexbeats228]

согласен

[@lachlanrose-mclean6348]

Very good tutorial!

[@coupleracademy]

Thanks!

[@yifat120]

Very professional tutorial

[@jenniferwebb3330]

This was very helpful!

[@Glitterboss1]

Thanks much...this was really helpful...you are a great teacher😊

[@coupleracademy]

You're very welcome! Glad it was helpful!

[@lindsayhengehold5341]

Love Google Sheets !

[@winteraquamarine]

Very helpful. Thank you!

[@HamidurRahman]

Wow Really smart presentation -- thanks

[@noorm7781]

This tutorial was excellent. Thanks for sharing it.

[@rohitremo5613]

I am new to this. really its Very useful for me

[@catchup237]

This is great, very brief and clear

[@vickyhaiqal8058]

Very Helpful, Thank you so much

[@NoName-ot8kl]

Excellent video!

[@pushpakmaheshwari4280]

thank you

[@vanessatupaz345]

Hi! Would like to know if Google Sheets is just like MS Excel? I'm quite used with using MS Excel at work but would like to try Google Sheets in the future.

[@mrutyunjaya.pradhan4849]

Hi! Would like to know if Google Sheets is just like MS Excel? I'm quite used with using MS Excel at work but would like to try Google Sheets in the future. Mr.MRUTYUNJAYA PRADHAN

[@thaXBestXAtXIt]

Math operations at 8:35. Very informative video!

[@coupleracademy]

Glad you liked it!

[@JohnOchuro]

Exactly what I was looking for, neatly explained! Thumbed up and subscribed! keep up the good work!

[@coupleracademy]

thank you!

[@rajendrachamling632]

Thank you very much was quite helpful.

[@gracejoseph5628]

ALX member🤚

[@sopuluchukwuali2673]

😂😂im here

[@Ungarsetrange]

This is very useful and easy to follow along with

[@coupleracademy]

Glad to hear that!

[@maheshambre03]

Very useful tutorial. I am searching for GYM management spread sheet template. How can I do this. Can you please help me?

[@coupleracademy]

Thank you! It depends on what exactly you would like to track. There is a tutorial where we explain how to build an income monitor - maybe this is what you are looking for? kzbin.info/www/bejne/gIu0hKhsr5anY68