- [Instructor] I've created a new blank file
and I want to talk a little bit more
about the structure of an Excel file
and then I'll start entering some text.
But the first thing I'm going to do is zoom in
just so you can see what I'm doing
a little bit more clearly.
And I'll do that by clicking the plus sign
all the way on the bottom right-hand side of the screen.
I'll click it a few times to zoom in.
Now, you're hearing me call this an Excel file
and usually that's what you'll call it,
but it is important to note that the technical term
of what this really is is an Excel workbook.
It's a workbook made up of sheets.
That is, worksheets.
Right now, this is Sheet 1
all the way down at the bottom of the screen.
I can input my data here and I can add multiple sheets.
I'll click the plus sign to add a new sheet.
And all of a sudden,
we have a completely separate worksheet
within this workbook.
That is the Excel file.
I can reference these sheets differently.
I can put formulas on one
that references a cell on a different sheet.
I can use them all interchangeably,
and we'll be going over that in detail.
But you did need to know that this is a workbook.
I will probably go back to calling it a file, however,
because like I said,
that's what you are going to be calling it most of the time.
The two terms can be used interchangeably,
but officially it's a workbook.
All right, so now that we have our file open,
let's start populating it with some basic text
and fill out some columns and rows.
I'm going to be putting in some sales data for our products
for our fictional company, Red 30 Tech.
To get started, I could put my cursor in any cell
by clicking directly on it.
Right now, I'm in column F row eight,
so this is cell F8.
And if I look, if I'm ever lost and don't know where I am,
if I lose track of this green outlined cell,
all the way on the top left-hand side of the screen
in the name box, I can see that this is indeed cell F8.
For now, I'm going to put my cursor in cell A2
and start typing.
I will hit the Enter key to move the cursor to the next row,
and now I can continue typing.
Okay, now I've got some products populated.
Now I can start filling in my column headers.
Now, the data that I have in column A
is taking up some of column B.
It's not in column B, it's just too long
and I can't see the contents of column B.
We'll be going over how to resize these officially later.
But for now, I'm going to hover my mouse
right in between column A and column B
and slide the mouse over.
Now I have a clear line of sight to column B.
I'll put my cursor inside cell B1 and start typing.
This time, instead of hitting the Enter key,
which would move me onto a new row,
I'm going to hit the Tab key,
which will move me to the next column.
Now I've got some data
and the last thing I could do
is put in a title if I wanted to.
Now we're ready to populate this with our sales data.
And up next, I'm going to show you
how to format this text for readability.