Get 20+ Excel courses at Simon Sez IT, including training for Excel 365, 2021, 2019, 2016, 2013, and more ️ https://www.simonsezit.com/course-category/excel/ Get a FREE 2.4 hour Excel 2019 Beginners course here ►
https://simonsezit.lpages.co/excel-2019-beginner-course-ssit/

This tutorial describes the Microsoft Excel Ribbon for Excel 2013. The Excel Ribbon has various tabs, such as File, Home, Insert, Page Layout, Formulas, Data, Review, and View. Each tab has different groups, and each group has individual commands. Find out what each tab is used for and what the corresponding commands do. Learn how to customize the ribbon or how to autohide the ribbon. Know all these and more in this video.

Get the full course on Excel 2013 course here: https://www.simonsezit.com/course-category/excel/

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

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

Welcome back to our course on Excel 2013. If you’ve used Office 2007 products or Office 2010 products, you’ll be familiar with the Ribbon and the Quick Access Toolbar. For the different constituent programs within Office, the migration from the old Menu system to the Ribbon based system has preceded at a sort of variable pace. Some of them have completed the transition before the others. But by the time we get to 2013, it’s pretty much complete. And in Windows 8, the Ribbon is starting to make an appearance. If you’re using Windows 8, you will have seen the program that was called Windows Explorer that’s now called File Explorer has a Ribbon interface as well. So, pretty much the Ribbon is here to stay. Not everybody likes it.

Some people still prefer the old Menu system. But I think more people like it now than did originally and one of the good things about the Ribbon Interface is it is pretty highly customizable and if you do particularly repetitive work or if you focus on just a few commands within a product like Excel, so you don’t need the vast array of different options that are available, then the ability to customize the Interface can really pay off. So if you’ve not used the Ribbon before or you’re a little bit cagey about using it and you think, well, I’d really prefer the old Menu system. Give the Ribbon a chance because I think that if you use it for a while it will grow on you.

The Ribbon is this sort of rectangle here and part of the Ribbon, or just above it if you like, you have these words like View, Review, Data, Formulas, and so on. Now these correspond to tabs and at any one time with the Ribbon, you have a selected tab. Now omit the word File from this, that file white on a green background. That’s the access to Backstage View, which we’ve used already. We’re talking about the word Home onwards and at the moment you see that Home has got this sort of three-quarters of a rectangle round it. The Home tab is selected. If I click on the word Insert, the Insert tab will be selected. Page Layout and so on. So they are the tabs of the Ribbon and at any time in Excel which tabs you can see will vary. Now the tabs you see now will be there pretty much all of the time. It’s more that you get additional tabs sometimes. And you’ll see some of those later on in the course.

The Home tab, as the name implies, that’s the one which we sort of regard as Home. And when the Home tab is selected you can see a number of groups. Now the groups have names and the groups are the words at the bottom. So that’s the Clipboard Group. That’s the Font Group. And a group, the groups are separated by these vertical faint dividing lines.

So there’s a Clipboard Group, then there’s a dividing line, then there’s the Font Group, then another line, Alignment Group, another one, Number, and so on. So on each of the tabs there are a number of groups and as you will see each tab has different groups.

Now within a group there are individual commands. So for instance, on the Insert tab, in the Tables Group, Pivot Table Command, a recommended Pivot Tables Command, and a Table Command. Now note as I hover over those, I’m getting those screen tips that we talked about earlier. They’ll tell you a little bit about what each of those commands does.

Many of the commands on many of the tabs we’re going to be covering on the course so I’m not too worried at the moment about exactly a command does. I just want to show you the principle that you’ve got tabs, within tabs you’ve got groups, within groups you’ve got commands.

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