Google Sheets: Basic Spreadsheets for Beginners

  Рет қаралды 50,428

dottotech

dottotech

Күн бұрын

Пікірлер: 74
@SkyNetGeneral-
@SkyNetGeneral- Ай бұрын
Thank you for teaching the basic fundamentals for beginners
@lindakorthanke4242
@lindakorthanke4242 2 жыл бұрын
Thanks for sharing. I’m missing out on so much time I could be saving by relearning how to do this. A great simple breakdown you have presented into using spreadsheets. I’m going to find this very useful! Thanks Again!
@dottotech
@dottotech 2 жыл бұрын
Glad it was helpful!
@sabrinafarber512
@sabrinafarber512 Жыл бұрын
I've been learning so much from you. I don't normally like to listen to people on KZbin but you are smart, engaging and speak well with out a lot of 'ums' and 'like'. Many thanks!!
@dottotech
@dottotech Жыл бұрын
Thank you so much for your kind words! I'm glad to hear that you find my videos helpful and engaging. It means a lot to me!
@grandpa_plays_chess2
@grandpa_plays_chess2 10 ай бұрын
Are you still doing videos?
@hcarora
@hcarora 2 жыл бұрын
You remind me of my days in Saudi Arabia in 1986 when I learnt now defunct Lotus 1-2-3 (Excel killed it!) and WordPerfect (MS Word killed it!) from an American tutor. Thanks. HC Arora Ghaziabad UP India
@daveschmarder-1950
@daveschmarder-1950 2 жыл бұрын
My brother taught me about spreadsheets on a Commodore 64 back in 1984. He used to do the Buffalo, NY budget on one back then. When you wanted to calculate, you had to press the calculate button. While that was working, you could go make a cup of coffee and drink it. I use Google Sheets mainly for financial calculations. I have an investment sheet, a spending sheet, and one for taxable dividends and other distributions.
@dottotech
@dottotech 2 жыл бұрын
Great reminder of how far we have come!
@soy_ferz
@soy_ferz 2 жыл бұрын
Thank you for sharing. You make it look simple and fun. On my way in learning more about google sheets via your tutorials. Much appreciate it.
@inspiredbyyou2day698
@inspiredbyyou2day698 Жыл бұрын
Steve....The great tech man, you did a great job. You did a great explanation and the example you brought made it easier to digest. I will search to find out if you also have more advanced version of the GOOGLE SHEET. .....Thanks again
@loneapple440
@loneapple440 2 жыл бұрын
I found your channel by accident. Great video and looking forward to more of these instructional vifeos.
@raintree4861
@raintree4861 2 жыл бұрын
Love the "Chapter" format at the bottom of 'Show More'. I have assigned this video a spot on my main screen speed dial. Lots of things I forget how to do, and this is a perfect go-to. Especially like the instruction on Calculations and Sums & Functions. ( from an American who went to grad school at UBC in beautiful Vancouver many years ago)
@dottotech
@dottotech 2 жыл бұрын
Great to hear!
@jackcollazo
@jackcollazo 2 жыл бұрын
I don't use Excel but this video just made me want to use it for something. Very informative, Steve, thank you!
@AlDunbar
@AlDunbar 2 жыл бұрын
LOL. The video is about Google sheets, not excel - even though Steve actually called it excel. No surprise there, as they are very similar.
@kdjobo
@kdjobo 2 жыл бұрын
Wow!!! Thanks a million for this eye opening tip!!! This video is very instructional indeed!!
@dottotech
@dottotech 2 жыл бұрын
Glad you enjoyed it!
@johnmerenda6408
@johnmerenda6408 2 жыл бұрын
Thank you. So helpful. I needed the review.
@dottotech
@dottotech 2 жыл бұрын
I'm so glad!
@joeweatlu5169
@joeweatlu5169 2 жыл бұрын
Thanks. Really appreciate your clearly explained tutorials.
@shareofmoney
@shareofmoney Жыл бұрын
Great tutorial and well done. Thank you for sharing this information. It was very helpful and I'm glad I came across the video.
@trainz49
@trainz49 Жыл бұрын
Thank you I haven't used a spreadsheet for awhile was trying to find out how to use a date range based upon every Saturday for the year, ended up typing each month what a pain. Couple of seconds in you showed me
@Zazu2You
@Zazu2You 2 жыл бұрын
Excellent information!! I've subscribed to your channel. I'm a retired IT guy with 40 years of technology experience. I do enjoy your content!! Cheers!!
@dottotech
@dottotech 2 жыл бұрын
Awesome, thank you!
@williamward7801
@williamward7801 2 жыл бұрын
Love your teaching style! More Google Sheets tutorials please.
@dottotech
@dottotech 2 жыл бұрын
Thank you! Will do!
@carlosdeicaza585
@carlosdeicaza585 2 жыл бұрын
@@dottotech Please do 😃
@carolthomas9814
@carolthomas9814 2 жыл бұрын
Yes, more google sheet tutorials!! You are an amazing teacher!
@bonnierende2468
@bonnierende2468 2 жыл бұрын
Thank you for what you do and how you present it.
@dottotech
@dottotech 2 жыл бұрын
My pleasure!
@abebawgetu5913
@abebawgetu5913 4 ай бұрын
Thanks a lot dear, I got a lot of tips and insight!
@marcusniemanjohnson
@marcusniemanjohnson Жыл бұрын
Wow, you really are experienced and have wisdom about what you are talking about, like you are not just simply providing high quality content or value and having us to accept it but you really showcase the importance in it and really share your experience with us and wisdom and truly help us grow and learn from the value provided, instead of just simply informing us, like you really do more, than that, with a lot of tutorials that I follow through with i am often left feeling clueless at what to do after, and be thinking I am really stupid or something after because I don't know exactly what is best to do with the knowledge gained. I know you are supposed to get what you put in, but to put it simply you are a great teacher, i am confident that I will actually learn and grow from following your lead, because you really meeting me where I am at, "a beginner" and helping see things as you do. I wish more content creators on KZbin were more like you.
@mobeb9306
@mobeb9306 5 ай бұрын
Thankyou for such easy to follow content. ive just recently discovered your channel and found your videos very helpful and informative. even for a beginner trying to understand spreadsheets thankyou from Australia
@vishnusuraj9914
@vishnusuraj9914 2 жыл бұрын
Thank you so much for your information great advice to work with sheets ❤👍
@dottotech
@dottotech 2 жыл бұрын
Glad it was helpful!
@jscollett9316
@jscollett9316 2 жыл бұрын
Thank you, so helpful. 🙂
@udo9999
@udo9999 Жыл бұрын
Thanks. Very well done video!
@levishemtov4391
@levishemtov4391 8 ай бұрын
Thanks for this video. Would you be able to show what's the best way to use Google sheets for managing an event down to the details? Thanks.
@davidg5629
@davidg5629 2 ай бұрын
God bless you for speaking English.
@eva_serviceseva_services1800
@eva_serviceseva_services1800 Жыл бұрын
Thank you so much for this. Please can you create a video on data visualisation and how to use charts on Google sheets
@martyshmanka
@martyshmanka 2 жыл бұрын
Between Trello and Google Sheets I run a professional production kitchen complete with recipe costing, inventory and production scheduling. Some features of Google sheets that are great (besides being free) are: sharing with other people/teams, conditional formatting, multiple sheets in one file, and unlimited data storage.
@dottotech
@dottotech 2 жыл бұрын
Thanks for sharing!
@AlexandraLuca-xv3fh
@AlexandraLuca-xv3fh Жыл бұрын
HELLO, thank you so much for the information! What is I want only weekend days of every month (or twice a week) ?
@Amandaxt4
@Amandaxt4 Жыл бұрын
Thank you
@STopgyal
@STopgyal 2 жыл бұрын
I just learned Basic spreadsheet using Google sheet taught on Coursera. Never knew it'a that powerful even though used sheet to create my simple budget. I was bit daunted by almost at the end when it was like learning coding as it has it's own syntax and coded language. I barely pass the course as I skipped when it came to the 75th percent of the course. I wish there is a course using the newer or updated sheet. I just want to learn again but, not with the outdated coursera lessons. Can you recommend any. I am also learning the google's Data analytics course and wanted to learn the google IT support course. I just finished the first month of the Data Analytics course and I have five more months course to complete. Do you have a say in choosing the Data Analytics over the IT support. To be honest I want to learn the one which easier and simpler. I have been watching your simple tutorials and enjoyed thoroughly. Would appreciate your advice. Thank you.
@axelec
@axelec 2 жыл бұрын
Opps did we get columns and rows mixed up
@colinmelhuish1254
@colinmelhuish1254 2 жыл бұрын
Needed to know how to extend the width of the cell and depth. Basic for beginners !!!
@1WhoConquers
@1WhoConquers 2 жыл бұрын
One thing that would make a great video as an advanced tip for spreadsheets... R1C1 notation instead of the default A1 notation. Makes things WAY clearer especially when you start using relative verses fixed notation. That $ in things like B$7 or $G12 is for the birds.
@dottotech
@dottotech 2 жыл бұрын
Great suggestion!
@martyshmanka
@martyshmanka 2 жыл бұрын
I am curious about this notation. I have only ever known the $ feature... what do you mean by R1C1 exactly?
@1WhoConquers
@1WhoConquers 2 жыл бұрын
@@martyshmanka A1 notation specifies the cell by the column letter (A, B, C, etc.) and the row number (1, 2, 3, etc.), identifying cells in the form of A1, B3, F14, and so on. Another way of representing a cell is R1C1, which gives the row number (R1) and the column number (C1). In this format, cell A1 would be R1C1, and cell B3 would be R3C2 (because B3 is the third row in the second column). R1C1 uses two sets of coordinates the first part (starting with R followed by a number) defines the row number and the second part (starting with C followed by a number) defines the column number. Absolute referencing does not use any symbols, instead the "normal" format is absolute reference, the default reference is attained by using a number in square brackets [] (R[-1]C[-1] means the cell 1 row above and 1 column to the left). A couple of examples (assume that cell that references are written is cell $B$6 or R6C2): $A$1 = R1C1 $C$15 = R15C3 Why is it better to use in formulas? Simply put and I can't stress this enough, the same formula is written the same way regardless of which cell it is written in. Example: Imagine you want column D aka C4 to include the sum of columns A aka C1, B aka C2, and C aka C3. Kind of hard to put a table in a comment, so picture each cluster of three rows below to be one row in a three column table. Notice how the A1 based formula gets unweildly real fast, but the R1D1 based formula remains the same (because it IS the same formula).... Result Cell Formula A1 Formula R1C1 D =$A2+$B2+$C2 =RC1+RC2+RC3 D3 =$A3+$B3+$C3 =RC1+RC2+RC3 D4 =$A4+$B4+$C4 =RC1+RC2+RC3 D10 =$A10+$B10+$C10 =RC1+RC2+RC3 D100 =$A100+$B100+$C100 =RC1+RC2+RC3 D123456 =$A123456+$B123456+$C123456 =RC1+RC2+RC3 Now for the sad news. Excel lets you easily switch notation types. So does the free open-source LibreOffice if you're on Windows or Linux. As I just found out by testing, apparently Google didn't think it was important. You can't switch easily to R1C1 as the default notation, but you can still use it in formulas via the INDIRECT function. It seems a small thing, but when you're working with it daily it's a huge difference. Kind of like the difference between using a Qwerty keyboard (what everyone learns in high school) and a _Dvorak_ keyboard layout. Which is built into Windows and Android, but most people have never heard of it. If you're a touch typist, it's five times as efficient in terms of keystrokes, and as a writer I won't go back to Querty.
@martyshmanka
@martyshmanka 2 жыл бұрын
@@1WhoConquers amazing info! Thank you so much.
@1WhoConquers
@1WhoConquers 2 жыл бұрын
@@martyshmanka You're welcome. I can't take full credit though. Most of that was just cut and paste from the results of a web search for "a1 vs r1c1" ;)
@lelandpeck4585
@lelandpeck4585 2 жыл бұрын
Steve, really enjoying your instructional videos. I"m a beginner with Google sheets. I recently built a spreadsheet, but when I tried to print it out, it was so small, I couldn't read it and people I sent the sheet too, had the same problem. What's the solution to that?
@dottotech
@dottotech 2 жыл бұрын
Chose "normal" in your print box when you chose your printer, and make sure the font you are using is large enough, google tries to print on as few pages as is practical
@yungmi1214
@yungmi1214 Жыл бұрын
Thanks for instruction, please show us how to save the file
@larsmj48
@larsmj48 2 жыл бұрын
I need a Google Keep for beginners
@lydethful
@lydethful 2 жыл бұрын
Can you do a similar video for Online Excel?
@b991228
@b991228 2 жыл бұрын
I know that notes can be added to a cell but is there an easy way to add a post-text or subtext at a cell formula? Something like a cell displaying $3,000,000,000,000 -Fortune 500.
@Pathosthesia
@Pathosthesia 2 жыл бұрын
Sir please tell me what should we use google sheet or Apple Number software, if use google sheet ,then tell us should we use google sheet app or web form
@Pathosthesia
@Pathosthesia 2 жыл бұрын
Sir i have one more ques after viewing ur video i was try this on safari web google sheet , when i was trying to drag date cell it was not automatically fill further date as u show me on ur video
@lucban2008
@lucban2008 2 жыл бұрын
I want to create an address book for all my contacts that i can edit from time time. What application can i use, thank you
@dottotech
@dottotech 2 жыл бұрын
Why not use Google Contacts
@timcascino8594
@timcascino8594 9 ай бұрын
Can you share how to search name in google sheets on a iPad ?
@trishtowley6030
@trishtowley6030 Жыл бұрын
My Google Spreadsheet doesn’t have the lines of icons and the line of selections right under the spreadsheet title. I am using my iPad and the latest app. What am I doing wrong?
@asifpatni
@asifpatni Жыл бұрын
Dear Sir, I need your help in google sheet, how to insert blank row formula/automatically between data in google sheet. For Example : I have my working data on google sheet with 7 columns a thousand rows and in my 4th column has a city's name and I want to insert a blank row after the city's name change in my google sheet. Excel has that option to select the whole sheet and insert a blank row but I am a new user of google sheet and it's difficult for me for my work. I hope you help me for this matter
@mugomuiruri2313
@mugomuiruri2313 Жыл бұрын
Getting u from africa
@paulvanobberghen
@paulvanobberghen 2 жыл бұрын
There’s only 2 things that can go in a cell, and that is constants (numbers or text) and formulas. And that’s it. Dates are numbers and calculations are formulas. So TWO things not less, not more.
@capcon52
@capcon52 Жыл бұрын
This is probably simple, but it is driving me crazier than I already am. I am 79 years old, the the old eyes are not what they used to me. Is there a way to increase the size and maybe even bold the font on the formula. I just can't see those tiny faint characters. I really enjoy your video's, but this is frustrating as heck. Thank you. Denny Conroy
@catman256able
@catman256able 2 жыл бұрын
✌️👍🙏🇱🇷
@t.fahrmann9757
@t.fahrmann9757 2 жыл бұрын
....so this is Googles "Microsoft Excel" ❓🤔😶( i am actually clueless🤯😅😂🤣)
@dottotech
@dottotech 2 жыл бұрын
Yes
Google Sheets Quickstart - Easy Tutorial
13:36
dottotech
Рет қаралды 125 М.
Support each other🤝
00:31
ISSEI / いっせい
Рет қаралды 37 МЛН
UFC 310 : Рахмонов VS Мачадо Гэрри
05:00
Setanta Sports UFC
Рет қаралды 1,1 МЛН
10 INCREDIBLE things Google Sheets can do Right Now!
13:27
Jeff Su
Рет қаралды 55 М.
The Beginner's Guide to Google Sheets - Online Spreadsheets
25:32
Technology for Teachers and Students
Рет қаралды 115 М.
Google Sheets Formulas Tutorial
23:25
Kevin Stratvert
Рет қаралды 405 М.
Google Sheets Tutorial for Beginners 🔥
13:50
Coupler․io Academy
Рет қаралды 2,7 МЛН
Google Sheets Tutorial for Beginners 2024 - Step-by-Step
20:20
Loves Data
Рет қаралды 3,7 М.
10 BEST Google Sheets HACKS for Teachers
21:12
Pocketful of Primary
Рет қаралды 74 М.
7 Google Sheets Tips Every User Should Know!
11:41
Simpletivity
Рет қаралды 38 М.
15 Functions in Google Sheets You NEED to know!
17:30
Flipped Classroom Tutorials
Рет қаралды 438 М.
10 Google Sheets Tips You DON'T Want to Miss
13:51
Leila Gharani
Рет қаралды 579 М.
How to Use Google Sheets - Beginner's Guide
19:33
Howfinity
Рет қаралды 309 М.