There's a couple different ways to create a Google spreadsheet. You can
either do it from scratch, which is what we'll do first, or you can create it from
a template. Or, you may have a spreadsheet already that you want to get into Google
Drive and then open it in Sheets. We'll go over that as well. The way to
just create a blank Google Sheet is to start out by going to drive.google.com.
This is Google Drive. If you don't have an account, a Google account already then
you'll have to create one but let's assume that you have on and go to a
blank area that's in the where that your files and folders are I'm going to right
click and Google sheets is one of the options if you go over to the right
you'll see that you can do it from a blank spreadsheet or a template so if
you wanted to do something common like maybe a budget or create an invoice for
a customer there'll be a template for that that'll get you started
but right now we're just gonna do a blank spreadsheet so you'll see it
opened a new window with your Google sheets spreadsheet in it Google Drive is
still open in the background and it'll look exactly like this if you're using
Google Chrome as your browser but if you're using another one it'll still do
the multiple tabs it'll be similar the first thing that you probably want to do
is name it something that's meaningful to what it's going to be so we'll let's
just assume that you're doing inventory name an inventory you're ready to go
there's a few basics about how to do this so you're only in one cell at a
time if you're entering data and it starts out in a 1 you reference these by
saying the column first and then the row and type what you want in here maybe
this will be the amount and to go down you either hit enter or you hit the down
arrow typically you would just hit enter which always bring you down but
sometimes you may want to go left or right up down and just use arrow keys so
right now I'm going to hit the down arrow and that's done you've entered
your first data in a Google spreadsheet so let's enter a few numbers in here
just to show you what you might want to do next we'll do
three four and three and then and then if you want to sum them go to insert
function and it's going to have the most common functions here this is going to
be what you're using a lot of the time and just choose some left click on it
and it wants the range of the values so we're working in a two all the way
through a four and you've also could have just used your mouse left click
than a two and dragged it down to a four and now hit enter and you've done your
first spreadsheet function satting up three four and three so
that's how you create a blank spreadsheet it's pretty easy the key is
just remember to go to your Google Drive great it from there give it a good name
then you can find it later I'm going to show you the steps on how
to upload an existing spreadsheet so one of the little tricks that you want to do
is you want to go to your settings and
make sure convert uploads is checked if that's not checked it's going to upload
it say in this case in a excel format that's going to sit on your Google Drive
in a non-native format so if you put on Google Drive to use it in sheets just
have this checked in it'll convert it for you automatically now that you want
to upload your file go to new and file upload and this is going to look at the
hard drive on your computer I happen to have put mine here so this is the sample
data this is an Excel spreadsheet select it click open and you see in the lower
right hand corner it's uploading one item it has this X here which is saying
that it's in Excel but if you see by the time it gets into my drive it's in
Google sheets if you didn't click that check mark that I showed you a minute
ago this would still be an X and you could view it but it wouldn't be in the
native format if I open up sample data it'll open up in Google sheets and it's
ready to go see but it doesn't always upload perfectly in this example the
header just looks black if I click in say example C
one I can see there's a value in there but what it did was it turned my fonts
black and the background black so let's just go and turn the text color to white
and we can see what's happening here so that's your three ways to create a
new sheets make a blank sheet create one from a template or upload existing data
next we're going to go through how to format it and so hang on for that if you
want more videos like this be sure to subscribe to my channel thanks