Welcome to Excel Basics video number six.
Hey, in this video we've got to talk
about customizing the Quick Access toolbar
and showing new ribbon tabs.
Now, the quick access toolbar by default
comes looking like this, without any color,
and with buttons we don't really need.
And we want to see how to customize it
so we have exactly the buttons we need,
and they show up below the ribbon tab in color.
Now, if you want to download this Excel file or the PDF
notes, you can click on a link below the video.
Hey, let's go over to the sheet Ribbon Quack.
Now, if you look up, here's the title bar.
And up at the top, on the left, is our quick access toolbar.
Now, I have Insider Edition version,
so I have this auto save button.
The rest of you, , by default, will have the Save button,
Undo, and Redo button.
The first thing we want to do to the quick access toolbar
is show it below the ribbon.
So we simply right click, Show quick access toolbar
below the ribbon.
And there, it's below the ribbon.
The next thing we want to do is actually
look through the ribbon tabs.
And anytime we find a button that we
want to add to the quick access toolbar,
we can simply do that by--
and I'm going to point to the Decrease Decimal
because this is something I use all the time.
Right click and right at the top,
Add to Quick Access Toolbar.
I've added it to the QAT Right click on Increase Decimal,
Add to Quick Access Toolbar.
Now, the reason that you want to add buttons
that you use a lot to the quick access toolbar
is if you always work in the data ribbon tab,
I don't want to have to go back over to Home
and click on Increase Decimal.
Notice there is the buttons.
I can go to any ribbon tab and they're always showing.
Now, what you want to do to customize your own personal QAT
is to go through each ribbon tab and find the items
that you use all the time, and add up to the quick access
to a bar.
I use Shapes all the time.
Right click Add to Quick Access Toolbar.
Column Chart, right click, Add to Quick Access Toolbar.
And so you go through each ribbon tab
and add all of the buttons.
You can fill up this entire thing here.
That's all I need from the ribbon tabs.
I actually know a lot of the keyboard so most of the time
I don't need to add them to the QAT.
But there's another reason to add buttons to the QAT.
There are some features that are no where in the ribbon tabs.
So we can further customize the quick access toolbar
by right clicking the quick access toolbar.
And there it is, the second option, Customize Quick Access
Toolbar.
And when I click that, I actually jump to Excel options
and by default, on the left, Quick Access Toolbar
is selected.
Now, the key is we pick things from this list.
But the first thing is the default is not very helpful.
Popular Commands-- you want to click the dropdown
and either select All Commands, which
is every single command available in Excel,
or if you've already gone through the ribbon tabs,
simply isolate it further with Commands Not In Ribbon.
Now you can look through this entire list
and pick out all the items you want.
I'm going to click In the List.
Type the letter S, because I want to jump to the S's, and
a button I want to add is Scenario.
So I select it and then I click the Add button.
And just like that, there it is.
Scrolling down further, Speak cells on Enter.
That's a button I like to use.
Not everyone likes that button.
But I'm going to click Add because I can't find it
anywhere in the ribbon.
I actually have to add it to the Quick Access Toolbar.
Another section to have fun with when you're building your QAT
is Paste Section.
There is a great one, Paste as Picture.
Or here's a great one, Paste As Linked Picture.
That means whatever you copy, whether in Word or PowerPoint
or somewhere in Excel, if you click this button,
it will paste it as a picture and it will totally be linked
when the source data changes.
I'm going to click Add.
Now, probably just as important as adding buttons
is removing buttons.
I do not need Auto Save at all.
That's for OneDrive.
Click Remove.
Save.
I'm never going to use Save because I
use Control-S. Remove that.
Undo, that's Control-Z. Redo, or undo the undo,
that's Control-Y. I'm going to remove those.
As soon as I have my custom list of buttons, now I can click OK.
But there's two other important things.
You can, for example, select Scenario and move it.
I'm going to move it back down.
Next video, when we talk about keyboards,
we'll see that having your most important or most often used
buttons at the very top of this QAT list can be helpful.
So you can re-order them there.
Also, if you ever need to reset back to that default,
you can simply come here and click that.
We're done.
I'm going to click OK.
And that's totally amazing.
Now--
Turned off speak on enter.
I already had my button turned on.
I'm going to turn it on.
Cells will now spoken on enter.
And this is what I love about Speak Cells on Enter.
I'm going to type 25.25 and when I hit Enter--
25.
Well, it said 25.
I know I entered 25 25.
Well, here's where our second button
is going to come in handy.
I accidentally highlighted this range
and decreased the decimals.
No problem.
I can come over and use my Increase Decimal button.
Now I want to come over here and Speak Cells on Enter.
69.43 Enter.
69.43.
125.25.
And speak cells enter is working.
Now here's a terrible joke.
You can actually turn this on, and if you remove the button--
by the way, you can remove any of these buttons at any time
by right click Remove--
it'll still be on.
And the only way you can turn it off is by adding it back on
and then turning it off.
I've actually done that before.
That's a terrible April Fool's Day joke
that you could do on somebody.
Hey, here's another great option.
If I highlight this, Control-C, come over to the side.
Instead of Control-V, I'm going to click
my Paste as Linked Picture.
Now if I come over here and change this to--
87.52.
Instantly this updates.
Now, a lot of times people use Paste Special Linked Picture.
If you have a sheet where you have maybe a couple pivot
tables and you want this formula solution over there,
but you want it to totally update
and you want it to look exactly like it does over there,
you can paste as a linked picture.
Now, the other thing we want to talk about is the ribbon tabs.
Now, by default, most of your ribbon tabs
will look like this.
But there is at least one ribbon that
doesn't come showing by default. So you can right
click any ribbon tab and point to Customize the Ribbon.
Now it opens up the same Excel Options.
Instead of Quick Access Toolbar, it says Customize Ribbon.
Now over here you can check or uncheck any of the ribbons
you might want to show.
Now you can add buttons, but we're not going to do that.
I like to add my buttons to the quick access toolbar.
Now when I click OK, I'll have a new ribbon showing.
Click OK, and there it is, the Developer Ribbon.
Another important option for showing ribbon tabs--
and we're not going to do this in this class.
But there are some features that can only
be added as a new ribbon.
So if you go over to File, down to Options.
Down here there is an Add-In section.
Now we come down here to Excel Add-Ins.
If I click the Drop Down, COM Add-Ins is an example.
If I click that and click Go--
again, we're not doing this in this class--
oftentimes there are a bunch of different ribbons
you want to add.
For example, in the class after this, Business 218,
which is advanced Excel, you're going to need Power Pivot.
Also a lot of businesses have add-ins
that they want for all of their employees.
So you might have to come to this COM Add-In,
like the Acrobat PDF Maker.
So now when I click OK, now I have one and two new ribbon
tabs.
All right.
So in this video, we saw how to customize the quick access
toolbar.
We moved it from the top down below,
and then we went to whatever button
we wanted and added to quick access toolbar.
We also saw how to right-click Customize QAT and add buttons.
And then we saw how to right-click any ribbon
and check new ribbons.
We even saw how to go to Tools, Options, Add-Ins,
and Add New Ribbons that your business might have
or items that you've purchased that only
can be added as a ribbon tab.
All right.
Next video, we'll talk about keyboards in Excel.
All right.
We'll see you next video.