Office 2013 Class #23: Excel Basics 05: Customize the Quick Access Toolbar and Ribbon

Download files: https://people.highline.edu/mgirvin/AllClasses/216_2013/Content/04Excel/Excel2013.htm
This video teaches:
1. Customize the Quick Access Toolbar and Ribbon (00:15 min)
2. Customize the Quick Access Toolbar and Ribbon (03:22 min)

Highline Community College Busn 216 Computer Applications Class Office 2013 (Fun With Computers) taught by Michael Girvin. Excel Basics. Learn Excel, How To Excel.

---

Closed Caption:


Welcome to Office
2013 video number 23.
Hey, If you want to
download this workbook
and this workbook is for video
23 to 27, click on the link
below the video to go
to our class website.
Hey, we're still studying Excel.
This is Excel
Basics number five.
We just want to take a
little bit of time and talk
about customizing the
ribbon and the QAT.
Quick Access Toolbar.
Let's start with the
Quick Access Toolbar.
So up here, if I want
to move it down below,
especially, if I'm going to
customize it because then
I can have lots of
room to add buttons.
I simply right click
the Quick Access Toolbar
and say, Show Quick
Access Toolbar Below.
And now our QAT is below and we
have lots of realistic to add
buttons.
Now there's two reasons
you want to add buttons
to your Quick Access Toolbar.
If you always work
on the Data tab
and you do things like
increase, decrease,
decimals or
conditional formatting.
Notice, if I'm
always working here,
I have to go back over to the
home to get these buttons.
But notice at the QAT
as I click through,
the ribbon tabs
is always showing.
Oh, that is so cool.
So one way to add
buttons is simply
go to whatever command you see
in the ribbons and right click
Add to Quick Access Toolbar.
Boom!
Right click Add.

Right click Add.
Look at that.
Amazing.
Now if I'm working
on the Data tab
I'm working-- those
buttons are always showing.
The other reason you want to
add buttons to the Quick Access
Toolbar is there's some commands
that are not in the ribbons.
So we can right click
the Quick Access Toolbar
and say Customize
Quick Access Toolbar.
It instantly brings us to Excel
Options Quick Access Toolbar.
And the trick is
Choose Commands From.
If you want to look at
every command that's
available in Excel
go to All Commands.
And I love this because I
just then go through the list
and add my buttons.
Click Add and add
them over here.
If you want to see the ones
that are just not in the ribbon,
Commands Not In Ribbon.

Now I'm going to add
just one button here.
I'm going to type the
letter S to jump to the S's.
Because I know
down here somewhere
is Speak Cells On Enter.
Once I've selected the
button I click Add.
Again, the idea is you
use Commands Not In Ribbon
or All Commands and simply go
through and Add, Add, Add, Add.
And to add as many as you like.
Now you can also remove some.
Save, I use Control S. I'm never
going to use that button Undo.
Never going to use it.
I use Control Z.
Redo, I use Control Y.
You can not only build
by adding or removing
but you can also reorder them.
So Decrease Decimal is
the one I use the most.
So I'm going to put
it at the top, here.
Which means it will be the
leftmost on the Quick Access
Toolbar.
And in the next
video in Keyboards
we'll see how to access quickly
all of these QAT elements
using our keyboards.
There's also the Reset button.
That's important.
Sometimes you need to reset
it back to the default.

Click OK.
And instantly I have
customized my QAT.
And there's lots of
real estate so you
can as many buttons as you want.
Now ribbons.

There's the home ribbon.
These.
Are the most common
tasks that people use.
They try to pile them
all into the home.
Insert ribbon.
We've already seen Pivot Table.
There's Pictures Page Layout.
We've already done a
bunch of page layouts.
There's formula stuff.
So it's kind of organized
in a logical way.
Data, like sorting, filtering.
Now Customizing.

Customizing came in in 2010.
So if you have 2010 to '13
you can customize the ribbons.
Now notice there's some
real estate over here.
So you can actually create a
new group and a new button.
So the one we're
going to do is--
we learned last video
that Insert Pivot Table is
on the Insert menu
in the Tables group.
Which I guess,
sort of make sense.
But if you've been
using Excel a long time
or you do data analysis,
well, wait a second,
Pivot Table is like the most
amazing data analysis feature
and it's not in this ribbon.
So let's see if we can
customize it and add it.
Right click and
customize the ribbon.

One thing you might
also want to do
is the Developer ribbon
is not showing by default
so you can simply uncheck it.
But notice, you can check and
uncheck whichever ribbon tab
you'd like.
Let's go to Data.
And you click on
the Data ribbon.

Say New Group.
Notice there's a new tab.
You can add a whole new tab.
Just your own customized tab.
I'm going to say New Group.
It's highlighted.
I'm going to click Rename.

Oh, look at that.
A bunch of cool symbols.
I'm going to call
this Pivot Table.

Click OK.
So now I have that and now
I go over to whichever one,
All Commands.
And then you can pile
in whatever you want.
I'm going to type P
and jump to the P area
and click The Pivot Table.
And Add.
Wow, just like that.
Click OK.

And just like that.
Is that totally amazing?
Oh!

So customizing the ribbons.
Customizing the QAT.
Making your job easier
because the commands
are where you want them.
All right, we'll
see you next video.