How to use Google Sheets - Tutorial for Beginners

Aug 24, 2023

How to use Google Sheets - Tutorial for Beginners

In this step-by-step tutorial, learn how to use Google Sheets. Google Sheets is completely free to use, and you can use it to get insights from your data. We begin with the absolute basics of how you can even get started in Sheets. Once we cover the basics, we advance to entering formulas and functions, inserting charts, using pivot tables, collecting data from a form, and so much more. By the end of this video, you’ll be proficient in using Google Sheets.

This video is sponsored by Google.

🏫 FREE TRAINING OFFERED BY GOOGLE
- Google Sheets Getting Started course: https://bit.ly/3UwekAu
- Google Sheets Advanced Topics course: https://bit.ly/3tpxDj2
- Google Sheets Functions, Formulas, and Charts course: https://bit.ly/3UNI9vV

📚 RESOURCES
- Google Sheets Start Page: http://sheets.google.com/
- Google Sheets New Blank Spreadsheet: http://sheets.new/
- How to use Google Forms video: • Google Forms Tutorial
- Sample Workbook Used in Video: https://docs.google.com/spreadsheets/…

⌚ TIMESTAMPS
00:00 Introduction
00:46 Official Google Sheets training
01:43 What is Google Sheets
02:24 How to get Google Sheets
03:30 Start page
04:30 Top bar
06:26 Cells, columns, \u0026 rows
07:30 Zoom level
07:46 Enter data \u0026 smart fill
10:04 Format numbers
11:01 Adjust column widths \u0026 row heights
12:24 Move columns \u0026 rows
12:57 Alternating colors
13:42 Conditional formatting
15:07 Hide columns \u0026 rows
15:57 Insert columns \u0026 rows
16:57 Freeze columns \u0026 rows
17:42 Column stats
19:01 Explore
19:54 Addition
21:52 Subtraction
22:13 Multiplication
22:35 Division
22:54 Functions
23:40 SUM function
25:53 Relative \u0026 absolute references
28:20 Named ranges
29:32 VLOOKUP function
31:57 Multiple worksheets
33:57 Sort \u0026 filter
35:30 Filter views
36:39 Charts
39:09 Pivot tables
42:49 Create a new form
44:23 Share \u0026 collaborate with others
47:24 Version history
48:02 Publish, email, \u0026 print
48:31 Wrap up

📺 RELATED VIDEOS
- Playlist with all my videos on Google Products: • How to use Google Products

📩 NEWSLETTER
- Get the latest high-quality tutorial and tips and tricks videos emailed to your inbox each week: https://kevinstratvert.com/newsletter/

🔽 CONNECT WITH ME
- Official web site: http://www.kevinstratvert.com
- LinkedIn: https://www.linkedin.com/in/kevinstra…
- Discord: https://bit.ly/KevinStratvertDiscord
- Twitter: https://twitter.com/kevstrat
- Facebook: https://www.facebook.com/Kevin-Stratv…
- TikTok: https://www.tiktok.com/@kevinstratvert
- Instagram: https://www.instagram.com/kevinstratv…

🙏 REQUEST VIDEOS
https://forms.gle/BDrTNUoxheEoMLGt5

🔔 SUBSCRIBE ON YOUTUBE
https://www.youtube.com/user/kevlers?…

🙌 SUPPORT THE CHANNEL
- Hit the THANKS button in any video!
- Amazon affiliate link: https://amzn.to/3kCP2yz (Purchasing through this link gives me a small commission to support videos on this channel — the price to you is the same)

#stratvert #googlesheets #googlecloudskillbadge #googlecloudskillsboost

Content

0.12 -> Hi everyone, Kevin here.

1.92 -> Today we are going to learn how to use Google Sheets.

6.36 -> Google Sheets is free spreadsheet software that you can use to get insights from your data.

12.48 -> We're going to start with the absolute basics. First, we'll look at how you

16.56 -> can even get Google Sheets, and I know, when you open up Google Sheets for the first time,

22.44 -> it may very well feel like you're in the cockpit of a jet plane.

26.7 -> There are so many different menus, so many different buttons. What do they all do?

32.28 -> Once we cover the basics, then we'll advance to formulas and functions,

36.3 -> inserting charts, using pivot tables, even collecting data from forms.

41.7 -> By the end of this video, you'll be a pro in using Google Sheets.

46.38 -> Along with this video, I also highly,

49.98 -> highly recommend using the official training provided by Google.

53.76 -> They offer courses on getting started with Google Sheets, advanced topics, using functions,

59.64 -> formulas, and charts. You'll find links to these resources down below in the description.

65.58 -> Here as an example, I'm currently in the functions, formulas, and charts quest,

70.2 -> and it's made-up of all of these different labs.

72.66 -> When I click into the pivot table lab, here you can read all about pivot tables and how they work.

78.36 -> But even better, you can follow along side-by-side where you actually learn by

83.76 -> doing, and personally, I think that's the best way to learn.

87.72 -> Once you create your pivot table,

89.46 -> you can check your progress to make sure that you learned everything correctly.

93.6 -> At the very end, you can even earn a badge that shows the

97.02 -> world your understanding of Google Sheets.

99.6 -> Once again, you'll find links to these resources down below

103.08 -> in the description. What even is Google Sheets?

106.68 -> Google Sheets is spreadsheet software that allows you to analyze and get insights from your data.

111.9 -> Basically, it tells you the story behind your data.

116.52 -> Here at the Kevin Cookie Company, we use Google Sheets to track all of our cookie sales data.

122.22 -> With conditional formatting, I can very quickly see well which

125.46 -> month was the best and which month was the worst.

128.7 -> I could also insert a chart and that way I can visualize the data over time.

133.62 -> I can use pivot tables to make sense of my data just by dragging and dropping my mouse,

138.24 -> and best of all, I can even work together with others.

141.72 -> We're going to look at all of these topics and more.

144.78 -> There are a few different ways that you can get started using Google Sheets. First

150.06 -> head to the website Google.com and in the top right-hand corner click on the app launcher.

156.24 -> If you don't yet have a Google account, you'll need to set one up, but it's completely free to

161.34 -> do that. Within the app launcher, here I see the icon for Google Sheets. Now you can also press

167.58 -> and hold on this to move it to a new position to make it easier to get back to it in the future.

171.84 -> When you click on this icon, this drops you on the start page of Google Sheets.

176.52 -> Now alternatively you can also navigate directly to the website

180.72 -> sheets.google.com and this will also drop you directly onto the start page.

185.1 -> If you prefer to jump directly into a new spreadsheet, you can go to Google Drive.

190.74 -> Also in the app launcher, click on Drive and in the top left-hand corner you can

195.24 -> click on this new button, and here you have the option to create a new spreadsheet,

199.26 -> and this will drop you in a blank new spreadsheet.

202.98 -> You can also navigate to the URL sheets.new and this too will also drop you into a new

209.52 -> blank spreadsheet. On the Google Sheets start page, in the top left-hand corner,

213.96 -> we can kick off a blank new workbook, and in a moment, we'll do that,

218.34 -> but first, over on the right-hand side, you can also start from a template. When I click on this

223.44 -> text, this expands the template gallery, and you have many different options here.

227.76 -> It's well worth a look to see if maybe one of these templates meets your needs.

232.38 -> I’ll click on the back button in the top left-hand.

236.04 -> To get back to your spreadsheet, you can use the recent list down below.

240.12 -> You have different sorting options, and you could visualize these files in different ways.

244.8 -> Up on top, you can also search for a file using this search field.

248.94 -> Now let's say that maybe you have a spreadsheet on your computer, maybe in Microsoft Excel format.

254.22 -> You can click on this file picker icon and then you can upload a spreadsheet

258.42 -> from your computer and then you can use Google Sheets to edit it.

261.84 -> I’ll click on the X icon.

263.4 -> Now let's kick off a blank new workbook.

266.16 -> I want to track the Kevin Cookie Company sales data, so let's click on this.

270.66 -> This drops us into a blank new workbook, and to return back to the start page,

276.42 -> in the top left-hand corner, I can click on this sheets icon,

279.66 -> and here that brings us back to the page that we were just on.

282.9 -> But I do need to get some work done, so let's once again click into a blank new workbook. Here in

289.2 -> the workbook in the top left-hand corner, you see that the title was currently untitled spreadsheet.

293.76 -> I want to give this spreadsheet a name,

295.5 -> so here I'll double click and I'll delete that and then I'll enter in the name cookie

300.36 -> sales analysis and feel free to do the same if you would like to follow along.

305.46 -> The spreadsheet now has a name and I see a few additional icons over on the right-hand side.

311.46 -> When I click on the folder icon, here I can see where this file is saved and

316.32 -> it's currently in My Drive and here it's under cookie sales analysis,

319.92 -> but I can also create an additional folder if I want to save it in a different location.

326.1 -> Over here I also have this star icon and when I click on this, this stars my file.

332.04 -> So, what does that do?

333.78 -> Well here, let's click on this storage icon again and here I can go into My Drive.

339.72 -> When I go to My Drive, here I see all of my files, but there's a category on the

344.58 -> left-hand side called starred, and when I click on that, here I can see that cookie sales analysis.

349.44 -> This makes it easier to get back to the files that you care about.

353.16 -> I'll click on the cookie sales analysis and this brings me right back into the spreadsheet again.

359.7 -> Also, over on the right-hand side, we see this cloud icon,

363.06 -> and when I click on that, I can see that all changes have been saved to Drive.

367.44 -> As we work on this spreadsheet, you don't have to go to the file menu and save it.

371.76 -> It'll automatically save every single change that you're making.

375.54 -> Also, if you want to work on this spreadsheet while you're offline,

379.08 -> so let's say you have no internet access, you can turn on offline access.

383.34 -> You will need to install an extension to be able to do that.

387.36 -> Let's now shift our focus down below to all of these rectangles.

391.38 -> These rectangles, these are all referred to as cells. On the sheet, you'll also notice that

397.2 -> we have all of these columns with letters, and we have all these rows with numbers.

401.7 -> To refer to one of these cells, we use the intersection of the column and the

407.28 -> row. Here I have my mouse in cell A1, so you start with the column followed by the row.

414.24 -> Also, when I click into this cell, up here in the top left-hand corner, we see the reference

419.46 -> to A1. Here, if I shift into B2, here we now see the reference to B2. When I hover over this,

426.36 -> you see that this is referred to as the name box, and you also see the associated shortcut key, and

433.26 -> all of the different buttons on the toolbar here have similar tooltips. Here when I hover over,

438.06 -> here I can see that this is the bold icon, and I could also see the associated shortcut key.

443.34 -> If you're ever unsure what one of these buttons does on the toolbar,

447.3 -> you can simply hover over and that'll tell you what it is.

450.96 -> I now want to start entering some data into this spreadsheet, but before I do that, I do want to

456.48 -> adjust the zoom. Over here on the left-hand side, I can click on this drop down and I'll adjust

461.76 -> the zoom to let's say 150%. That'll make things a little bit easier to see. I’ll now go back to cell

468.96 -> A1, and I want to type in a header for my table. Here I'll type in sales. Then I can press the

475.98 -> tab key or the right arrow key and that'll move me over to cell B1, and here I'll type in date.

482.46 -> I can now press enter or the down arrow key and that'll move me to cell B2, and here I

488.1 -> want to enter all of the different months of the year to keep track of all of our sales data.

492.96 -> So, of course, the first month of the year is January 2022 and then

497.58 -> the second month is February 2022, and I don't want to make you watch

501.96 -> me fill out all the months of the year. That would take a long time.

504.84 -> Instead, I've established a pattern here.

507.42 -> Here I typed in one month of the year followed by another month,

510.3 -> so hopefully Google Sheets is smart enough to follow this pattern.

513.9 -> I'll highlight both of these cells, and when I highlight them, we see this blue square in the

520.14 -> bottom right-hand corner, and when I hover over it, my cursor changes to a plus icon.

525 -> I can press on this and then drag down to row 13 and then I'll release and here you see that

531.78 -> Google Sheets was smart enough to follow this pattern all the way through the end of the year,

536.22 -> and that brings me down to December 2022. That was a lot easier than typing it out.

541.2 -> This is called smart fill. I can also use smart fill with numbers.

547.62 -> In January, this is our worst month of the year. We only sold 1,000 cookies.

552.3 -> People have New Year's resolutions, and they just decide not to eat as many cookies. I’ll

557.52 -> press the enter key, and then here for February, we doubled our sales to

562.56 -> 2,000. I'll enter 2,000, and here I've established the pattern. It increases by

567.42 -> a 1,000 between months. Here I can click on this blue icon again and I could drag

572.58 -> all the way down through December and here it follows that pattern to 12,000 sales.

577.26 -> Now, of course, we don't just have a straight line of sales.

580.08 -> I want to randomize things a little bit just to make this analysis more interesting.

585.24 -> Here I'll highlight November through February data. Then I'll right click

590.16 -> and at the very bottom of this context menu,

592.32 -> we have the option to view more cell actions, and here's the option to randomize the range.

597.84 -> I'll click on that and here that randomizes the order of all of these numbers.

601.8 -> This gives us some good data to work with.

605.46 -> We have all of the sales data entered in now, but it is a little bit hard to read.

610.5 -> I think I could format these numbers better.

612.36 -> I'll highlight all of these numbers and up on the top menus there's the option for format.

618.66 -> When I click on this, here I could select different number formats.

622.8 -> Here I could format the text.

624.42 -> I could set the alignment. I could set the wrapping, the rotation,

627.72 -> so I have many different options here.

630.66 -> Now I'll exit out of this menu.

632.46 -> Down here in the toolbar, I also have some of the most frequently

636.3 -> used formatting options. Here I can click on this dropdown

639.9 -> and here you'll notice I get this same menu where I could format the numbers.

642.84 -> I'll format it as a number. Here with sales, it doesn't make sense

646.98 -> to include decimals because we're not going to sell a fraction of a cookie,

650.1 -> so I want to remove those decimals. Up here in the bar, I could also decrease the decimal places.

655.14 -> I could click on that twice and that removes the decimals. Over here,

658.44 -> I could re add them, but I don't want them, so I'll remove that.

662.1 -> Looking down below, I should probably provide some context as to why cookie

667.62 -> sales are so horrible in January and why they're so good in December.

671.94 -> I mean maybe we have someone new joining the

673.92 -> company and they don't know the cyclical nature of the business.

677.4 -> Here in column C, I'll type in note as one of the column headers and let

682.32 -> me type an explanation for why January is so bad.

684.96 -> Next, I’ll go down to December and type in a reason here.

689.1 -> I've now typed in both reasons and I think that provides some good context, but one thing

693.96 -> I don't like is you'll notice the contents of the cell bleed into the adjacent cells.

698.52 -> Luckily, I can adjust the width of the column. Here I'll click between columns C and D and

704.64 -> here I can drag it out, so it fits all of the contents. Now instead of dragging that out,

709.98 -> here I'll press this undo button. Here you'll see the shortcut key is CTRL + Z.

714 -> I'll undo that. Here I could also double click between column C and D and that'll

720.18 -> automatically adjust the width to fit the content that's within the largest cell.

725.04 -> Let's say that maybe you have a lot of columns

728.1 -> or a lot of rows where you want to fit to the content.

731.28 -> Here in the top left-hand corner, I can click right here,

734.4 -> and this highlights all of the columns and all of the rows.

737.22 -> Here I can double click between two of the columns and that'll

740.94 -> adjust all of them to best fit, and I could do the same for the rows.

745.38 -> Looking at this data, I don't know if it makes sense to show sales and then the date.

750.12 -> I think I'd rather show the date first.

752.04 -> So, do I have to delete this column and then re-enter everything?

755.82 -> No, of course not.

757.08 -> It's really easy to move data around.

758.82 -> Here I'll go up to column B and here I will click on it,

763.02 -> and you notice that my cursor changes to a hand icon.

766.5 -> Here I can press again, and this now grabs that column, and I can now move that to a new position.

772.56 -> Here I'll place that column ahead of sales and that switches the position.

776.58 -> It's really that easy. All of the data here is really solid,

780.54 -> but I'm not quite satisfied with the look and feel.

783.3 -> Let's go back up to the format menu to see what we can do here?

787.98 -> Here at the very bottom, there’s the option for alternating colors.

791.46 -> Let's select that.

792.72 -> This adds some very nice formatting to this

795.6 -> table. Here I see a treatment on the headers, and I also see banded rows.

800.04 -> Over on the right-hand side, it opens up this pane where I can customize what this table looks like.

806.88 -> Here I can choose different styles.

808.8 -> Maybe let's go with this yellow one.

812.1 -> It's amazing what yellow can do to brighten up the picture,

815.46 -> and it really makes my boss have a more positive perception of all of this data.

821.1 -> It really does wonders.

823.2 -> Let's now close out this pane.

825.54 -> When I look at this table, it's coming along nicely,

828.78 -> but I think I can also apply some formatting to make the numbers stand out a little more.

833.76 -> So maybe some formatting when a number is really good, and a number is really bad.

837.12 -> I'll highlight all of these numbers and let's go back to the format menu.

842.22 -> Right by alternating colors, there's the option for conditional formatting.

846.42 -> Let's select that. Over on the right-hand side,

849.36 -> here again, we see a pane that allows us to customize the conditional formatting.

854.46 -> Conditional formatting is really neat.

856.74 -> You can format the cells if and you have all these different conditions.

860.52 -> You could say if it's greater than something,

862.5 -> you want to format it in a certain way, or if it's less than something.

865.56 -> You could even enter custom formulas in, so you have lots of different options here.

870.66 -> Now I want a good sales number to be green and a bad sales number to be red,

875.22 -> so over here there’s the option for a color scale.

878.28 -> I'll click on that and over here I can preview the different formats.

883.2 -> I'll click on this, and I think this option might work.

887.4 -> Let's select that.

888.48 -> So here I see that December, we had really good sales and it's in green,

892.56 -> and here in January, it wasn't so good, and it's in red.

895.5 -> This way we can visually just look at it and know which months were good and which months were bad.

901.86 -> Here I have many other options as well.

903.96 -> I'm all done with the conditional formatting now, so I'll click on the X icon.

908.58 -> Over here, I have my column C with a note, but come to think of it,

912.96 -> most of the people who are going to review this data already know why January is bad

917.46 -> and why December is good, so including this information isn't really necessary.

921.9 -> But at the same time, if someone new joins a company, maybe they don't know these reasons.

926.64 -> I don't want to delete it.

928.38 -> Here I can right click on column C and here I get this context menu.

933.48 -> Within this menu, there's the option to hide the column.

936.36 -> So here I can hide the column when I show it to people who've been at the company for a while,

940.68 -> and then maybe when someone new joins the company, here I could hover over between

945 -> columns B and D. Here you see these arrow icons indicating that there’s a hidden column. Here I

951.72 -> can click on this icon and that once again shows that column, but I want to hide it.

956.34 -> I'll right click and let's hide the column.

958.68 -> Thinking about this some more, we're also supposed to get sales data for other countries,

963.48 -> so I want to add one more column with the country.

966.72 -> I want to add it before the date column.

969.96 -> Here I'll click on column A, and I could right click,

973.56 -> and I can insert another column to the left.

976.5 -> Now let's say I wanted to insert 2 columns.

979.38 -> Here I could highlight columns A and B,

981.9 -> right click, and here I could insert 2 columns, so you could insert any number

985.98 -> of columns. Simply highlight the number you want, and then you can insert those.

989.7 -> I just want one column. I’ll click here and then insert one column to the left. For this

995.7 -> column, here I'll type in country and the country is going to be the United States.

1001.46 -> Here I'll select this and then drag it all the way down and that'll copy that value to the bottom.

1006.56 -> Here, let me undo this and show you one more way to fill this down.

1010.22 -> Instead of dragging and dropping it down,

1011.84 -> I can simply double click here and that'll fill it all the way to the bottom of the data.

1015.8 -> So, another quick way to fill in some data. As I scroll down this sheet,

1020.42 -> you'll notice that the header no longer appears.

1023.9 -> I know this is the number of sales, but it'd be nice if the header just stayed there just

1028.52 -> to remind me of that. Here I can go up to the view menu, and there's the option to freeze.

1034.82 -> Here I can freeze the top row, the first two rows,

1038.24 -> or I can really just freeze any number of rows, and I could also do the same for the columns.

1043.34 -> I just want to freeze the top row. I’ll select one row and here that is now frozen that row.

1050.24 -> Here I can now scroll down and I continue to see the header.

1053.6 -> To undo that, I could go back to the view menu, here go to freeze, and then I can select no

1058.64 -> rows and that'll remove the freezing, but I want it there, so I'll leave that in place.

1064.04 -> The formatting all looks fantastic now, but I need to be able to answer some basic

1069.08 -> business questions about this data, like what were the total sales for the year,

1073.16 -> or how did we perform in the first quarter of the year, how many cookies did we sell?

1078.38 -> Luckily Google Sheets has lots of tools that can help me with this, and I don't even have

1082.52 -> to enter a formula or function, I just have to know the question that I want to answer.

1087.62 -> I'll put the active cell here in column C, then I'll go up to the data menu,

1093.02 -> and right here there's the option for column stats.

1096.26 -> When I click on that, that opens up a pane over on the right-hand side,

1100.16 -> and here I see all of these stats on column C. If I scroll down here, I can see that we

1106.88 -> had total sales of 78,000. That's the sum of all of these numbers. I could see the average,

1112.04 -> the median, the min, the max. So, I get all of that information without having to do any work.

1117.56 -> Here, I'll close that out. Let's say I want to know what were the sales for the

1122.36 -> first quarter of the year. Here I’ll select Q1. I’ll select all of those cells, and in

1128.18 -> the bottom right-hand corner on the status bar, you'll see this menu, and when I click on that,

1132.62 -> I can see that the sum was 16,000 for Q1. I could also see the average, the min,

1137.3 -> the max, so I get these really quick stats here without needing to calculate anything on my own.

1142.88 -> To the right of that, there's a button called explore and when

1146.84 -> I hover over you also see the shortcut key and this is a really useful button.

1151.7 -> When I click on this, here I see those same stats,

1154.58 -> so the sum, the average, the min, the max, but I also get these charts that

1159.14 -> visually show me the data and it just automatically creates this for me.

1162.5 -> If I want to keep it here, I could simply drag and drop it over onto my spreadsheet.

1166.76 -> I’ll delete this for now.

1169.04 -> Now let's say I want to know well what were the total sales for the year? Here I'll click

1174.38 -> on column C and here in the explore view, here it updates, but I can ask a question like let's

1180.14 -> say total sales and then hit enter and here it tells me that the total sales were 78,000.

1185.78 -> So, you really just have to know the right question to ask, and then you can get an

1190.7 -> answer back for your question without having to know formulas or functions or any of that.

1195.02 -> These tools work exceptionally well, but sometimes you just need to get

1199.22 -> your hands dirty, and you need to enter in a formula or a function.

1203 -> Let's close out this pane and let's see how we can enter in our own formulas and functions.

1208.58 -> First, I want to know what were the total sales in January and February, and here

1213.62 -> I'll type in the question, and this is just a basic addition question.

1218.84 -> We had 1,000 sales here. I'll press the control key and we can see that

1222.92 -> the total was 9,000, but how can we get that same answer using a formula?

1228.44 -> To enter in a formula, we start by entering in an equals sign.

1232.7 -> This lets Google Sheets know that we're about to enter in a formula. Now in January, we had 1,000

1239.06 -> sales. I can type in 1,000 and then I can enter in the plus sign and here I'll type in 8,000, and

1246.26 -> I can see the answer right up above. It's 9000. I'll press the enter key and here we see 9,000.

1251.48 -> That works great. Now here I just reference the specific number, and the problem with this is,

1257.72 -> let's say actually January was a little off. We actually sold 1,200 cookies instead of

1262.76 -> 1,000. I'll press enter and here we see that the formula did not update,

1268.1 -> and the reason why is we hard coded in these numbers. It doesn't reference these cells.

1274.1 -> Let's delete this, and let's try again. I'll enter in the equal sign.

1278.66 -> This time, instead of typing in 1,200, let's refer to this cell.

1282.8 -> This is C2. So here I could type in C2 and then I could type in plus,

1289.16 -> but instead of typing in the column and then the row, instead I could also just click on the cell.

1294.86 -> Here I'll click on C3 and now I can press enter and now that shows 9,200. Now we did

1301.58 -> actually only have 1,000 sales in January, so I can now update this and when I hit enter,

1306.38 -> you'll see that the formula automatically updates. That’s

1309.74 -> the benefit of referencing cells instead of hard coding in values.

1313.76 -> Along with addition, we can also do subtraction.

1316.46 -> Let's say I want to know how much bigger was December compared to January.

1320.78 -> Here I’ll enter the equal sign and I’ll select 12,000 for December minus 1,000 in January,

1328.34 -> and then I’ll hit enter and here I could see that December had 11,000 more sales than January.

1335.12 -> We can also do multiplication.

1336.86 -> Let's say I want to know what would happen if we doubled December sales.

1340.94 -> So, we had 12,000.

1342.74 -> Here I'll enter equals 12,000. Here I'll enter the asterisk symbol. This is how you multiply,

1349.16 -> and I'll type in two and then hit enter and we can see that we would have

1354.2 -> 24,000 sales if we were to double it.

1356.3 -> Lastly, we can also do division. Let's say I want

1360.32 -> to know what would happen if we only got half of December sales.

1363.14 -> Here I'll enter equals, I'll select December, and then for the division sign, we use the forward

1369.68 -> slash and then I'll enter two, hit enter, and we would only have 6,000 sales for December.

1375.62 -> So far, we've just been using simple formulas, but you can also use something called a function,

1381.5 -> and with a function you pass in different arguments and you get a result back.

1387.14 -> Up on the toolbar over on the right-hand side, you have this icon for functions

1391.4 -> and when I click on this, we see all of these different function options.

1395 -> At the very top, we have some of the most common functions like getting a sum, an average,

1399.86 -> a count, max or min, and over here, we see all these different categories of functions.

1404.78 -> If I hover over the all category, here you can see all of the different

1409.34 -> functions available in Google Sheets, and there are many, many different options.

1414.08 -> Here at the very bottom of the list, you can also learn more,

1416.84 -> and this has detailed descriptions of all of the different functions that are available to you.

1421.4 -> Over on the left-hand side in my table, I would like to sum up all of the different

1426.44 -> sales and figure out what the total sales were, and to do this, we can use a function.

1432.68 -> I'll place the active cell at the very bottom of this list of all of the sales,

1436.52 -> and then again in the top right-hand corner, let's click on this function icon.

1441.44 -> Here in this list at the very top we have the sum function,

1444.86 -> and the sum function will sum up all of these different values.

1447.98 -> I’ll select this function. When I select that function,

1452.6 -> here I see some helper text appear that shows me how to use the function.

1457.16 -> So here it has the function name, which is sum, an open parentheses,

1460.94 -> and then I need to put in all of the different values that I want to sum up, and at the end,

1465.14 -> I close this off with the parentheses, and here we can see an example of how this works.

1470.12 -> I'll close this out and let me select all of these different values.

1474.02 -> I want to sum all of these up. Here I can see the function down below.

1478.7 -> Just like with formulas, we start with an equal sign, then we type in the function name, here's

1483.98 -> the open parentheses, and then this is the range C2 all the way down to C13, so there's a colon C13

1490.4 -> and then close parentheses. Here I can see that the sum is 78,000. I'll press enter and there we

1496.94 -> just used our first function. Along with selecting a function just right up here using this icon,

1501.8 -> we can also just type the function directly into the cell. Here I'll delete 78,000.

1507.2 -> Here we could type equals and then type in the function name sum and one thing

1512.24 -> you'll see is Google Sheets is smart and it detects that if we're typing in sum here,

1515.84 -> we probably want to sum up all the values above.

1518.18 -> So here I get this helpful suggestion that says to sum up those values.

1521.96 -> I can click on that and that also sums it up.

1524.48 -> So, another way to just type in a function on your own.

1527.42 -> Now that we have the total sales, I probably need to add some text that clarifies what this is.

1534.08 -> Over in cell B14, I'll type in total sales colon and then hit enter.

1539.96 -> I'll select this cell again and up on the top toolbar, I'll right align this.

1544.7 -> Next, I’ll select these two cells and I'll go up to the toolbar and here I’ll make these bold.

1549.38 -> I could also press CTRL + B.

1552.02 -> This looks pretty nice now.

1553.28 -> We had some pretty good sales for the year.

1554.96 -> I also want to add one additional column that tells me the percent that that month

1560.66 -> made up of the total sales. Up on top, I’ll add an additional column called percent of total sales,

1567.8 -> and here when I hit enter, it automatically applies the formatting to this additional

1572.06 -> column. For the percent of total sales, it's the month divided by the total sales.

1578 -> Just like we've been doing, I'll type in the equal

1580.28 -> sign and then select 1,000 and here it detects what the total sales is.

1585.32 -> It's C14. I'll select that and here it looks like it's a little over 1%, but I want it to

1591.74 -> be formatted as a percent. I'll make sure this cell is selected and up on the top toolbar,

1596.42 -> here I can select format as percent. I want this formula to apply to all of the other months, but

1602.72 -> of course, I don't want to have to type this in for every single row, that would take a long time.

1607.94 -> Just like we did before,

1609.02 -> I can click on this blue square in the bottom right-hand corner of the cell.

1612.38 -> I can press on that and then drag it all the way down and then release.

1616.52 -> This now applies that formula to all of these rows,

1619.22 -> but one thing you'll see is I get this divide by zero.

1622.64 -> I'll click into the cell and then go up to the formula and

1625.88 -> let's see if we could figure out what happened.

1628.04 -> When I dragged the formula down by one row,

1631.16 -> it automatically adjusted the reference to this next row.

1635.66 -> So that's nice.

1636.5 -> Here's looking at February, but with C15 or the total sales, it did the same exact

1642.8 -> thing. It also adjusted that reference by one row, and I don't want it to do that.

1647.54 -> So instead let's go back to the initial row where I entered this formula in.

1652.1 -> Over on the right-hand side, I can see this suggestion and it looks

1656.6 -> like it added a dollar sign in front of the column reference and also the row reference.

1661.64 -> So, what does that do?

1663.2 -> By adding a dollar sign in front of both the column and the row,

1667.04 -> that locks the reference to this specific cell.

1669.98 -> I’ll accept this suggestion and now the formula works as I expect it to.

1674.54 -> Here if we go up to the formula toolbar, here I can see there are now dollar signs in front.

1679.64 -> Now as a quick tip, you can press the F4 key, and you can toggle between different

1684.74 -> states. So here there's only a dollar sign in front of the row.

1687.44 -> So, the row is locked, but the column can change. I can press

1690.74 -> F4 again. That places a dollar sign in front of the column but not the row.

1694.7 -> I'll press it again and it removes all of the dollar signs,

1697.7 -> and here I could press it once again and that locks both the column and the row.

1701.6 -> Dollar signs work just fine if you want to lock a reference in a cell,

1705.74 -> but an even easier way to do it is to just give that cell a name.

1709.4 -> I'll go down to cell C14 where I have the total sales and up in the top left-hand corner,

1715.46 -> we see the name box and right now it's just referred to as C14. I

1719.78 -> can click into this box, and I can give it a name.

1722.06 -> I'll type in total sales and then hit enter.

1725.54 -> Here I'll go back up to this formula that I entered earlier,

1728.48 -> and here we see that references C14, but instead of referencing C14,

1732.8 -> I'll delete this reference and instead I'll type in total sales and then hit enter.

1737.3 -> It works just the same, but then you don't have to worry about absolute or relative references.

1742.58 -> Instead, just name the cell that you're going to

1744.98 -> use often and then you can use that name in a formula.

1747.98 -> It just makes things a little bit easier.

1749.54 -> To view all of your named cells, simply go up to the top menus and click on data.

1755.36 -> Right here there's an option for named ranges.

1757.64 -> When I select that, that opens up the pane over on the right-hand side,

1760.58 -> and here I can see all of my named ranges.

1763.22 -> Here's the one called total sales.

1764.78 -> I can click on this edit icon and here I could

1768.02 -> change the name and I could also change the reference.

1770.18 -> Now I want to leave this reference as is, so I'll close out the pane.

1774.38 -> Next, we're going to look at a function that's a little bit more complicated than the functions

1779.36 -> that we've looked at so far, and this one is a function that you'll likely use often.

1784.04 -> It's called VLOOKUP or vertical look up.

1787.88 -> This allows you to look up a value in a table and then return a corresponding value. So,

1793.88 -> let's say for example I want to know how many sales did we generate in, let's say June 2022.

1800.72 -> So here I could look in this table and when I go down, here I see June 2022,

1805.22 -> and I see that the sales were 4,000, but I want a function to do that for me. I don't

1810.56 -> want to have to manually look through this table to find out what the sales were. Over in cell F7,

1816.5 -> let's make that the active cell and we can start typing in the

1820.04 -> function. I'll enter the equal sign and let's type in the name VLOOKUP.

1824.48 -> When I type that in, here I see the function.

1827 -> I'll select that. Next, it gives me hints as to what I need to enter and first it

1832.82 -> asks me for the search key. This is the value that we're searching for.

1836.84 -> If you're ever unsure of what one of these items means within a function, you can click

1841.94 -> on this drop down arrow, and that expands all the details, and you could read about how it works.

1846.38 -> I'll minimize this. So, I want to search for June 2022. I'll select that. Next, I'll enter a comma.

1854.42 -> The comma separates the different arguments within this function and next it wants to know the range.

1861.14 -> Well, I want to look up the month in this table right here, so I'll select this area over here.

1867.62 -> The value that you're looking up needs to be in the first column.

1871.58 -> Here I'll enter a comma and next it asks me for the index.

1876.56 -> For this area that I selected, I now want to get the second column back,

1881.78 -> so here I'll enter in a two and here I can close the parentheses. That's all I need to enter in

1888.26 -> for this function. I'll press enter and here it shows me that in June 2022, we had 4,000 sales.

1894.56 -> Now you might be wondering, well, what good is that?

1896.84 -> I could just look over and I can see how many sales we had.

1899.48 -> The beautiful thing here is I can change the value that we're searching for. So,

1904.4 -> let's say actually I want to know December 2022 and how many sales did we drive? I'll

1909.44 -> hit enter and here VLOOKUP automatically adjusts and here returns 12,000 sales.

1915.14 -> This is one of the most powerful functions that

1917.84 -> you can use in Google Sheets. As I've been building out this sheet,

1921.92 -> here I have all of the sales data and over here I have some business questions,

1925.22 -> but I think it might work better if I put these business questions onto a separate sheet.

1930.98 -> Here I can select all of these different questions that I entered in, and I'll press CTRL + X to cut.

1936.68 -> Down below, I can click on this plus icon, and this adds another sheet,

1940.64 -> and here I'll press CTRL + V and that pastes all of these values onto the new sheet.

1945.56 -> One thing you might notice is all of these different formulas

1948.56 -> and functions that I entered in, they continue to work as expected.

1952.64 -> Here, when I click into cell A1 and we look at the formula bar,

1956.48 -> here you'll see that the reference is now pointing to the previous sheet.

1960.08 -> So, you can also reference values on different sheets within the spreadsheet.

1964.58 -> The name of the worksheet down at the bottom is just sheet1

1967.52 -> and then sheet2 and that's not really that clear.

1970.52 -> I can double click on this and I can give this sheet a new name,

1974 -> so let's call this one business questions and then I'll hit enter.

1977.36 -> And sheet one, this has all of my sales data.

1980.48 -> I'll double click on that and let me call this sales data and then hit enter.

1984.38 -> I'll go back to business questions and here the formulas continue to

1987.98 -> work. Even though I renamed it, it automatically updates the reference

1991.52 -> to that new name. Down at the very bottom, I can re-order these sheets.

1995.84 -> Maybe I want business questions to come first.

1997.82 -> I can press and hold, and I can drag that to a new position.

2000.52 -> I can also click on this down arrow and here I have all these different options.

2005.44 -> I could delete a sheet, I could duplicate it, I could copy, rename,

2008.5 -> I could even change the color. For the business questions, let's go with this blue color.

2013.24 -> That way it stands out a little bit more, and I also have all of these other options down here.

2018.7 -> To see all of my sheets, I could look across the bottom,

2021.28 -> but especially if you start getting a lot of sheets, you can also click on this all-sheets

2025.48 -> icon and here you can very quickly see all of your different sheets within this spreadsheet.

2029.74 -> Next, we're going to look at how you can both sort and filter your data.

2034.06 -> For that, let's click back into the sales data worksheet.

2037.06 -> Here in the table, I want to sort it so I can see

2039.82 -> which month had the most sales and which month had the least sales.

2042.7 -> Now I could go up to this column and when I hover over, I get this drop-down arrow.

2047.44 -> I can click on that and here's the option to sort from A-Z or

2051.7 -> smallest to largest or largest to smallest.

2054.52 -> But if I sort it based on the column, it'll also sort the total sales and I don't want that.

2060.16 -> So instead, I can highlight this entire table, but I'll leave out

2064.78 -> the total sales. Up on the top toolbar, over here there's the option to create a filter.

2070.24 -> I'll click on that.

2071.44 -> This has now added a new icon to the headers of my table.

2075.22 -> Here I see this icon. When I click on that,

2078.22 -> here I have various sorting options, and I also have various filtering options.

2082.48 -> Now I want to sort from largest to smallest, so I'll select Z to A and click on OK and here

2089.74 -> I see that December again was the largest month and here January was the worst month.

2094.9 -> Here I can click here and let's say I want to sort based on the months.

2098.14 -> Here I'll select A to Z, and this restores the original order.

2102.1 -> Using that same icon I can also filter.

2104.68 -> Let's say I just want to see the first three months of the year.

2107.98 -> I’ll click on this icon again, and here I have all of my different filter options.

2112.54 -> Here I can filter by color, I can also filter by conditions,

2116.2 -> and here I can specify what the condition is, but I just want a simple filter.

2120.64 -> I just want to look at the first three months.

2122.5 -> I’ll select clear so it removes all of the months and here I'll just select the first

2127.66 -> three and then click on OK and now I only see the sales for January, February, and March.

2132.88 -> To come back to this filter in the future, I could go through all these same steps.

2137.02 -> I can add a filter, then I can filter it just in the first three months,

2139.96 -> but especially as your filters get a little more complicated,

2143.08 -> maybe you're filtering on multiple columns, that takes a little bit of time.

2146.62 -> Instead, you can save your filter view. Up on the top toolbar,

2150.7 -> let's go back over to the filter icon and then click on this drop-down arrow.

2154.42 -> Here I have the option to save as filter view.

2157.54 -> I’ll select that. Over here I can give this filter view a name.

2162.1 -> I'll call this first three months and then hit enter.

2165.7 -> This filter view is now saved.

2167.5 -> I can go over and click on this X icon and here I'll exit out of the filter view,

2172.6 -> and this brings me back to the original data.

2175.24 -> Now let's say my manager comes up to me and says,

2177.46 -> hey Kevin, what were the first three months and what were the sales?

2181.36 -> Here I can go up to data, filter views,

2184.12 -> and here I can select first three months, and I have that view.

2187.48 -> Alternatively, I'll exit out again. I can click on this drop-down arrow and here I

2192.16 -> can also select first three months and that gives me the filtered view.

2195.88 -> Let's now exit out of the filtered view.

2198.16 -> Here in the top right-hand corner, I'll click on the X icon.

2201.1 -> All of the data that we have here is currently just in a tabular format,

2205.12 -> but at least me personally, I think it's a lot easier to

2208.18 -> understand what's happening with the data when it's in a visual format.

2212.26 -> So basically, a chart.

2214.3 -> Now I want to chart out the sales by date over the course of the entire year, just to

2219.64 -> see what's been happening. Here I can highlight all these different values that I want to chart.

2224.98 -> Up on top, I can click on the insert menu and here's the option to insert a chart.

2230.2 -> Alternatively, I can also go on the toolbar over

2232.9 -> on the right-hand side and here too I can also insert a chart.

2236.14 -> Let's click on this.

2237.52 -> This now inserts a chart and over on the right-hand side,

2241.06 -> I have a pane that lets me edit this chart.

2243.4 -> Here I can press on the chart, and I can move it around the worksheet.

2247.3 -> I could also click in the corners if I want to make it smaller, or if I want to make it larger,

2251.14 -> I'll make it a little bit smaller so we can see the entire thing.

2254.56 -> Now over on the right-hand side in the chart editor, here I can choose the type of chart.

2259.36 -> Currently it's set to a column chart but here I can change it to let's say a line chart.

2263.26 -> I can also go down and choose from all of these different types of charts.

2266.62 -> You have many, many different options.

2268.48 -> I'll go back to the original column chart.

2271.12 -> I think that works well. Down below, I also have additional settings related to this chart.

2276.58 -> Up in the top right-hand corner, I can also customize what this chart looks like,

2280.42 -> and when I click on that, here I have many different options.

2284.02 -> I’ll click into chart style and over here I can change it to a 3D column chart. That

2290.32 -> looks pretty cool. I'll collapse this category again. Here I can also click

2295 -> into chart and axis title and let me give it a better name than just sales vs. date.

2299.5 -> Here I'll type in cookie sales by month and there it automatically updates the title.

2303.88 -> Down here I could also format what the title looks like.

2306.46 -> Maybe centering it would look a little better.

2308.5 -> I'll select that. Here I'll minimize this category.

2311.5 -> Next, there's a category called series.

2313.96 -> I'll click into that and when we look down a little bit,

2316.6 -> here I have the option to add a trendline.

2318.94 -> When I check this box, here I can see the trendline throughout the course of the year.

2322.96 -> It looks like as the year goes on; we happen to just sell more cookies.

2327.22 -> That's a good sign for the business.

2328.96 -> One of the neat things about this chart is it's always in Sync with the data.

2333.52 -> So here I'll go up to my table and in January that was our worst month,

2337.66 -> but let's say actually it was a little bit better.

2339.82 -> Let's say we sold 2,000 cookies. I'll update that in the table and then hit enter and you

2344.92 -> see on the chart it automatically updated to reflect that new number that's in the table. So,

2349.78 -> these two are always in sync. Next, we're going to look at how you can quickly analyze your data

2355.24 -> and get insights from your data without even needing to enter in a formula or a function.

2360.04 -> We're going to use something called pivot tables,

2362.62 -> and you can analyze your data just by dragging and dropping your mouse.

2365.92 -> I'll move the chart over to the right-hand side and then here we see our table.

2370.84 -> I want to include all of this data right here in the pivot table.

2374.5 -> I'll select this.

2375.52 -> I'll leave out the percent of total sales and the total sales down at the bottom.

2379.78 -> I just want this raw data right here.

2381.7 -> Up on top, I'll select the insert menu, and here we see the option to insert a pivot table.

2387.22 -> Let's select that.

2389.02 -> Here it asks me if we should set up a new sheet or use an existing sheet.

2393.76 -> I want to set up a new sheet.

2395.08 -> I’ll make sure that's selected and then click on create.

2397.36 -> This now drops me into a new pivot table and down below I have a new worksheet called Pivot Table 1.

2404.62 -> Here I have my pivot table and over on the right-hand side I have the pivot table editor

2409.48 -> and this will help me pull together my pivot table. All the way over on the right-hand side,

2414.1 -> you see the country, the date, and the sales, and you might recognize these,

2418.42 -> these are referred to as fields and these are the columns that we had on the sales data sheet.

2423.4 -> When I click back into here, here you see country,

2425.8 -> date, and sales and those all correspond with what we see here.

2429.1 -> Let's look at how you can get some very quick insights using pivot tables.

2433.12 -> Let's say I want to know what were the total sales of the Kevin Cookie company?

2437.62 -> Here I have a category or a field called sales and I can press and hold and drag that over to values.

2444.52 -> Now you typically drag something into values if you want to calculate something. I'll

2449.56 -> release and here I see the sum of all of the sales. Here I see that we had

2455.02 -> 79,000 total sales, but here I could also calculate other things. Instead of the sum,

2459.52 -> let's click on this drop down and here I could also calculate the average.

2463 -> So, it looks like on average every month we sell about 6,583 cookies. Here I could

2469.36 -> click on this again and I have all these other calculations. I could do the max,

2472.6 -> the min the median. So I have all these different options here.

2475.72 -> Over on the right-hand side,

2477.4 -> I have these other fields and I can pull them into the pivot table as well.

2481.06 -> Here I’ll change this back to the sum and let's pull the date into the rows.

2486.1 -> I'll release that there and here I can see the sales by month.

2489.64 -> This is very similar to the view that we had on the sales data sheet,

2492.76 -> but let's say actually I want to see all of the different months as columns.

2496.96 -> Here I'll drag the date and here I'll place it in columns, and I see the same data but

2502.48 -> just organized in a different way, and I can get this simply by dragging and dropping my mouse.

2507.16 -> Here I can move the date back up to rows and there you see that original

2510.58 -> view. Earlier to calculate the percent of the total sales, we needed to enter in a formula

2516.16 -> and then we had to set up the reference properly, but here it's just so easy.

2519.7 -> I could take sales and let's drag it down into values again.

2522.58 -> Now I have sales appear in my pivot table twice.

2525.64 -> Right here I could decide how I want to show it.

2528.76 -> Currently it's just set to the number, but I could also set it

2531.34 -> to percent of column and there I could see the percent that that month contributed.

2535.78 -> I didn't have to enter a single formula or function.

2538.48 -> All I had to do is select an option from this dropdown list.

2541.24 -> Pivot tables make analysis so easy.

2544.66 -> I can also filter this data, just like we did earlier. Here I could

2548.8 -> take date and I'll drag it down to filters and here I'll release.

2553.12 -> I can now click on this list, and I can decide what to include in this pivot table.

2557.08 -> Let's say I just want to see the first three months.

2559.54 -> I’ll select January, February, and March and then click on OK,

2562.9 -> and here that's now filtered my table.

2565 -> So here I was able to re-create most of the views that we had

2568.84 -> on the previous sheet simply by dragging and dropping my mouse.

2572.44 -> With all this data that we've been looking at so far, it's just been based on this sales data,

2576.94 -> but maybe you want to collect data from third parties or from your customers.

2581.56 -> We can go up to the tools menu, and here's the option to create a new form.

2586.06 -> Let's click on that.

2587.02 -> This drops me into Google Forms, and the beautiful thing here is any of the

2591.7 -> responses that I receive in this form will automatically feed back into my spreadsheet.

2596.74 -> If you want to learn more about how to use Forms, you can check out the video or the training

2601.48 -> included down below in the description. Right up here, for the title of my form, I'll call this

2606.7 -> favorite cookie, and for the first question, let's call this what's your favorite cookie?

2611.74 -> And I'll leave it just as a short answer text. That looks good.

2616.72 -> Right up above I can now share this survey out with others.

2619.66 -> I could click on send and I could send it via e-mail,

2621.7 -> I could share a link, or I can even embed it in a web site.

2625.12 -> Let's preview what this survey looks like just to see how the data flows back into my spreadsheet.

2629.74 -> I’ll click on preview and here I can now fill out this form.

2633.28 -> What's your favorite cookie?

2634.96 -> Well, of course it's chocolate chip. I’ll type that in and then click on submit. So,

2639.46 -> we now have our first response.

2641.26 -> Let's go back to the spreadsheet.

2643 -> Here in the spreadsheet, there's a new worksheet called Form Responses 1.

2647.8 -> I'll click on that and here I can see the response from my survey.

2652.48 -> Here I see the time stamp and I also see what's your favorite cookie,

2655.84 -> and here I see chocolate chip.

2657.16 -> So, Google Forms is an excellent way to collect feedback, and to bring that

2662.14 -> directly into your spreadsheet where you can then analyze all the responses.

2666.34 -> We've done a lot of fantastic analysis today, but next I want to share it out with the broader

2672.1 -> Kevin Cookie Company. In the top right-hand corner, we can click on this share button.

2676.9 -> I’ll click on that, and this opens up the sharing dialog. Within the sharing dialog,

2683.08 -> here at the very top, I can type in specific people who I want to share this with.

2686.98 -> I'll type in Kevin Stratvert.

2689.08 -> He seems like a really good guy. Here I can notify him.

2692.08 -> I could also type in a message, and right here, I can set the permissions,

2695.68 -> so can he view it, can he comment, or can he edit?

2698.8 -> I’ll select editor and then click on send.

2701.08 -> Let's now go back up to the sharing dialog to see what else we can do there.

2705.16 -> I'll click on share, and here I can now see that I've shared this workbook with

2709.6 -> Kevin Stratvert and I can see that he's currently set to an editor.

2713.26 -> Down below, I can also provide general access.

2715.96 -> Currently it's restricted just to the two of us, but here I can click on this drop

2719.98 -> down and I could also set it so anyone with a link can access this spreadsheet,

2724.12 -> and over here I can set the permissions. Here viewer, commenter, or editor.

2729.76 -> I'll leave it to viewer, and I can copy the link.

2733.18 -> I'll provide this link down below in the description if you want to

2736.24 -> see this workbook and just take a look around.

2738.04 -> For now, I'll click on done.

2740.02 -> Now that I've shared this spreadsheet, in the top right-hand corner, I can see all the

2744.22 -> other people who are currently in this sheet, and here I see that Kevin is currently here.

2748.66 -> His picture has purple around it and when I look down on the spreadsheet,

2752.5 -> here I see purple on the spreadsheet, so this lets me know where Kevin currently is in this workbook.

2758.38 -> When I hover over the cell, I could also see the name associated with this position.

2762.88 -> So here I can see this is currently where Kevin is. Up in the top right-hand corner,

2767.08 -> I could also chat with Kevin.

2768.4 -> I could click on this icon, and this opens up the chat interface.

2772.36 -> Here I could type in a message.

2774.16 -> Hi, how are you?

2776.32 -> Ah, very cool. It looks like he appreciates the hard work we've been doing today.

2779.98 -> You can also leave comments directly within the worksheet itself. Here where it says

2785.08 -> what's your favorite cookie, let's see if this is also Kevin’s favorite cookie.

2788.14 -> I can go up to the insert menu and right here there's the option to insert a comment.

2792.82 -> I could also press CTRL + Alt + M. Let's try the shortcut key.

2797.2 -> I'll press CTRL + Alt + M and here I can type in a comment.

2800.32 -> One of the neat things about commenting is I can also @ mention people.

2803.86 -> I’ll type in the @ symbol and here it shows Kevin Stratvert is one of the options.

2808 -> The reason he shows up here is, well, this is one of the people who I shared this sheet with.

2812.14 -> I'll select his name and let's ask him if this is also his favorite cookie.

2816.1 -> Right down below, I can also assign it to Kevin.

2818.74 -> I'll check this box and here I'll click on assign. And look at that! He has already responded.

2825.22 -> In the top right-hand corner, I can also click on this icon, and this will show

2829.42 -> me all of the comment history, and here I see that same comment thread and Kevin’s

2835.12 -> now answered this question and I'm glad that he likes the same cookie that I like.

2838.72 -> Here I can click on this check mark to mark it as done and that will now hide the discussion.

2844.24 -> This makes collaboration with multiple people so easy. Especially when you start working

2849.16 -> with a number of different people, you might worry, well, what if someone makes changes

2853.06 -> and you didn't like those changes and maybe you want to go back to a previous version?

2856.12 -> Right up here you can see when the last edit was made.

2859.24 -> When I click on this, this opens up version history and here I can jump back to any previous

2864.82 -> version of this spreadsheet so I could go through and see when all of the different changes were.

2868.6 -> In fact, I could even name some of these versions.

2871.3 -> I could click on the ellipsis or the three dots here, and I can give this version a name.

2875.86 -> For now, I'm OK with all of the changes that have been made,

2878.5 -> but this is a neat way to go back in the history, if you need to.

2882.1 -> In the top left-hand corner, I'll click on the back icon.

2885.82 -> There are also other ways that you can share your file.

2888.7 -> When you click on the file menu,

2890.38 -> you could go down to share, and here you have the option to publish to the web.

2894.16 -> You could also e-mail the file, or you could even download a copy. Here I can download as a

2899.14 -> Microsoft Excel file. At the very bottom, and this is probably a more traditional way of sharing,

2904.72 -> you can also print out a copy. You could press CTRL + P and when you click on print,

2909.28 -> you have a whole bunch of different options to customize what your print out looks like.

2913.66 -> All right, well, that's how you can get started using Google Sheets.

2917.62 -> Be sure to check out the free learning resources down below in the description.

2922.36 -> That way you could continue learning even more about Google Sheets.

2926.5 -> To watch more videos like this one,

2928.54 -> please consider subscribing, and I'll see you in the next video.

Source: https://www.youtube.com/watch?v=TENAbUa-R-w