- [Instructor] Let's go over a quick rundown
of all the elements that make up Excel
and we'll start with a ribbon.
The ribbon is a tabbed interface across all
Microsoft products.
Though the tabs change,
depending on which product you're in.
The most commonly used apps will be in this home tab
and you'll notice that they're grouped
by task down here at the bottom.
You can change tabs depending on what you're looking for.
However, if you can't find what you're looking for in any
of these tabs, it's often quicker just to come up here
to the search bar and type the task
that you're trying to do.
For example, merge cells.
It's going to give me the best action
and in fact, here's some more actions that I can do.
These are the same icons
and actions that are found right in the ribbon tabs.
While you're navigating the ribbon,
you might also see these arrows and they are everywhere.
Anytime you see an arrow, you can click on it
and it's going to give you some more things
that you can do in that task.
It's going to be the same across the ribbon.
Here's some arrows and some more arrows even.
The only exception to this tabbed interface is the file tab.
If I click on that, this is where I go
to create a brand new blank workbook or file.
I can open an existing one
or save the one I'm currently working on.
To get back to Excel, click the arrow pointing
to the left all the way on the top of the screen.
Let's move to the bottom of the screen.
Right now, I can see the currently selected worksheet
and there may in fact be multiple worksheets in this file.
That is this workbook. We'll be going over that.
All the way on the bottom right hand side of the screen,
I can use the plus and minus signs to zoom in or out.
I can use the minus to zoom out.
That is make the font smaller or zoom in.
That is make it much larger.
I'll be zooming in a lot so
that you can see what's going on in the middle of the screen
and speaking of the middle of the screen,
let's move here right now.
I can scroll all the way down
and keep scrolling through all of these rows.
At the very top the columns are all alphabetical
while the rows are numerical.
I can click inside any of these cells
and the currently active cell
that I'm in is going to be outlined in green.
We'll be going over data types
and I'll be talking about why sometimes the text aligns
to the left and why sometimes it aligns to the right.
You can format all of the text
and we'll be going over how to do that.
You can also click the column header
to highlight the entire column,
and you can click a number to highlight an entire row.
You can also hover your mouse right in between the line
and make it wider or more narrow.
You can also do the same thing with columns.
You can make them small or really large.
The the last thing I want to show you
that you can do is undo any change you make.
Maybe I didn't mean to widen that column.
It happens. This was a mistake.
To undo it all the way in the very top left hand side
of the screen.
I can click this back arrow pointing to the left.
This is the undo feature
and I'll be using it a lot in Excel.
If you click on it, it's going to undo the last action
that you did and you can keep clicking on it
to keep undoing your actions.
You can undo up to 100 actions.
In fact, if you go too far and undo the wrong thing,
you can click the redo button,
which is the arrow to the right of it.
It's going to redo that last action,
so when I'm showing you things in Excel,
a lot of times you'll hear me say,
that I'm going to undo that last action.
That's all I'm doing.
I'm clicking this arrow on the top left hand side.
So that's the basic navigation of Excel.
Most of the time you can stick to the Home ribbon tab
to use your day-to-day functions.
We'll be going through all sorts of things like how
to format and edit text and even work
with formulas and functions.