Get a FREE 2.4 hour Excel 2019 Beginners course here ►https://simonsezit.lpages.co/excel-2019-beginner-course-ssit/

During this Microsoft Excel 2016 training tutorial video, you will get to familiarize the Ribbon with its different tabs, commands, and controls. We will show you how commands become enabled/disabled, how to hide/unhide the Ribbon, how to use key tips, and how to customize the Ribbon.

Checkout some of our other training on YouTube:

VBA for Excel tutorials: https://www.youtube.com/playlist?list=PLzj7TwUeMQ3hWRi0mgxdyWkT0QaYKuBGZ

Excel 2016 training: https://www.youtube.com/playlist?list=PLzj7TwUeMQ3jUeMoLReqNzzuKj7rdLhZ2

Excel 2013 training: https://www.youtube.com/playlist?list=PLzj7TwUeMQ3jVfCjoptJb_mimawnVezqh

Access 2013 training: https://www.youtube.com/playlist?list=PLzj7TwUeMQ3gbtcZ9Z3kbhk-2v65bfGeX

Project 2013 training: https://www.youtube.com/playlist?list=PLzj7TwUeMQ3i1QJ6-Z91KRjFg5dzacD1O

Visio 2013 for beginners: https://www.youtube.com/playlist?list=PLzj7TwUeMQ3jpAwkTGD6hGNxF8ML_FfsF

SharePoint 2013 training: https://www.youtube.com/playlist?list=PLzj7TwUeMQ3jloGuvewOe0Iv1EE2POKge

PowerPoint 2013 training for beginners: https://www.youtube.com/playlist?list=PLzj7TwUeMQ3gX0kiJc3k8d31y0zTLcECq

Stay in touch:
SimonSezIT.com: https://www.SimonSezIT.com/
StreamSkill.com: https://StreamSkill.com/
YouTube Channel: https://www.youtube.com/user/simonsezittraining
Facebook: https://www.facebook.com/SimonSezIT/

If you enjoyed the video, please give a "thumbs up" and subscribe to the channel ;-)


Welcome back to our course on Excel 2016.
In this section I’m going to cover the use of the Ribbon in some detail. If you’ve used a relatively recent version of Excel before you may be pretty familiar with the Ribbon and you may well not need to go through this section at all. If on the other hand you haven’t used the Ribbon before or you’ve used a much older version of Excel, maybe one of the early versions that used the Ribbon, or you want to find out about Key Tips or Auto-Hiding the Ribbon then I suggest you go through this section because I’m going to try to cover it fairly thoroughly to give you all of the basic things you need to know to get the best out of using the Ribbon.

The Ribbon is this rectangular area here. And above the rectangular area there are individual words or phrases and these correspond to the Tabs. The Ribbon is actually made up of a number of Tabs. Now you can’t see all the Tabs here at the moment. Some of them are only shown under certain circumstances. And you can in fact add your own Tabs. But the ones you see here are the basic default Tabs. A couple of exceptions. On the left the word File there as you know gives you access to Backstage View. Technically it’s not really a Ribbon Tab at all. And on the right we have the new Tell Me feature. So in fact the Ribbon I’ve got here has seven tabs: Home, Insert, Page Layout, Formulas, Data, Review, View. If you see a different list to that all will be revealed later to explain why that is.
Now one thing to notice straightaway is that Home is highlighted. We say that the Home Tab is selected. But on the Ribbon you see a lot of grayed out controls. Most of those are various types of command. They’re ways of doing certain things to your Excel workbooks. But on the Home Tab they are currently all grayed out. And the reason they’re grayed out is that you couldn’t actually use any of them at the moment. And the reason you can’t use them at the moment is because I don’t have a workbook open.

Now let me open one of the recently opened workbooks. So let me go into Backstage View. Let’s try Demo 1 again. And you see that the controls on the Home Tab on the Ribbon are no longer grayed out. You could actually use those commands. And in fact if I click on a couple of the other tabs, let’s look at the Insert Tab, they are not grayed out either. Let’s go to Page Layout, Formulas. Now when you get to Formulas there are one or two, there’s one there, a command that’s still grayed out. Now the fact that that’s grayed out means that I couldn’t do whatever it does at the moment with my current situation.

So let’s go back to the Home Tab then and let’s see what we can do. Let’s suppose I type in the currently selected cell the word Hello. Now having typed Hello if I click on the Enter tick there next to the Formula Bar now I’m going to go up to the B command here, the one that I’ve currently got selected, Bold. I’m going to click that and it makes the text in that cell bold.


Sorry, we couldn't fit the entire video transcription here since YouTube only allows 5000 characters.