Name: Googleシート - 完全なチュートリアル (Google Sheets - Full Tutorial)
Uploaded: 2021-01-14T08:43:48.000Z
Duration: 35 min 14 s
Description: VoiceTubeの動画で発音を聞きながら英語表現を覚えよう！学べる英語：

to 不定詞

There's a couple different ways to create a Google spreadsheet.

法助動詞 A2

You can either do it from scratch, which is what we'll do first, or you can create it

Or, you may have a spreadsheet already that you want to get into Google Drive and then

The way to just create a blank Google Sheet is to start out by going to drive.google.com.

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

If you're using Google sheets and you have some data that looks like this on the left

and you want to make it apparent that it's a table, use some nice colors, make it obvious

what the headers and the title are, that's what we're going to do in this tutorial.

We're going to start with unformatted data and work our way over to something that looks

If we do one cell, let's say we wanted to do A1, you hover over it with the mouse and

If you double click, it brings you inside the cell and it thinks that you want to change

The second way that we're going to select data is we're going to either select the entire

column, and I did that by left clicking on the A, or you can do the entire row.

Let's left-click on the 2 and, while that's highlighted, if you hold down the shift key,

you can go down and it selects more than one at a time.

You can also select the entire sheet by clicking here in the upper left hand corner.

So, when you're looking at this data, the first thing that you want to do is make it

I held down the shift key and I used the right and down arrows to select this entire range.

I'm going to go up and click the dollar sign in the toolbar.

That formats it as currency but then I want to go to column F because I don't really find

it to be material what the cents are on a particular item.

I kind of want it on the totals because I want to see everything down to the penny.

Let's go ahead and decrease the decimal places.

I want you to see, for example, this is $1.99, but decrease it by 2, oops wrong way.

Google Sheets uses a standard rounding convention and this turns $19.99 into $20.00.

It's not a header for a particular column so we should probably merge these rows.

I left-clicked in A1, I held down the shift key, and I pressed the right arrow.

Or, you can just take your mouse left click, select all these, left click and drag.

It's a little icon here that's merging them so you merge them together.

But, I want it centered horizontally as well so this icon gives you three options.

Center it left, center in the middle center to the right.

Let's put it in the middle and then let's make it bold.

That would be right here and we're gonna make a 24-point so you really see, "hey this is

字幕リスト動画再生

Googleシート - 完全なチュートリアル (Google Sheets - Full Tutorial)

sort

entire

concept

average