The ribbon, which displays many of the program’s capabilities without requiring you to open a menu, makes it easier for you to find what you’re looking for and to discover capabilities you might not have encountered before.
- [Instructor] If you're just upgrading to Excel 2019 from Excel 2008, you'll probably notice that the program has a different user interface. This interface, called the ribbon, appears below the menu bar and above the body of the worksheet. The reason this change occurred is that Microsoft studied how users interacted with Excel and other Office programs and what they realized is that a lot of users didn't discover features that have been built into Excel for years. So rather than hide a lot of the capabilities behind a menu system, Microsoft created the ribbon to bring as much to the surface as possible.
The ribbon itself is the series of tabs starting with home, insert, and so on, and the groups that lay below it. So you can see here on the home tab, we have pasting, cutting, copying, and copying formats, using the format painter. Also, changing fonts, alignment and so on. The insert tab, which you can display by clicking it allows you to insert things such as pivot tables or charts, pictures or shapes. You might have also noticed that there is a differently formatted tab here called table.
That ribbon tab is created so that you can work with an Excel table in detail and I explain what Excel tables are how to create them elsewhere in the course. If I click the table tab on the ribbon then I see tools that are specifically related to an Excel table. If I click a cell that is not part of the table, then that contextual tab goes away and I'm just back to the home tab. Other parts of the ribbon include galleries.
So for example, if I wanted to change the formatting of this Excel table, I can click inside of the table and then you see here, on the table contextual tab, that I have an in ribbon gallery. So I have different styles that I can apply. If I want to move to other styles I can click left and right or if I want to see the entire gallery at one time or at least as much as will fit on the screen I can click this down arrow and that displays the entire gallery.
You can also display dialog boxes from within the ribbon, so for example if I go back and click home, and then click the font color button's down arrow, I see more colors, I can click more colors there which has three dots after the label. Anytime you see three dots you know that there is a dialog box behind it, so I'll click there and I get the colors picker, or the colors dialog box. I'll go ahead and click cancel.
Finally, if you want to minimize the ribbon, you can do that. To hide the ribbon but leave the tabs in place then just click a selected tab and you can see here that I now just have home, click a tab again, and it displays all the items beneath it. As you can see, the ribbon displays more of Excel's capabilities than a traditional menu system can. Instead of digging through one menu at a time looking for what you want, displaying a ribbon tab let's you see all of the available commands at once.
- Creating workbooks
- Manipulating cell data
- Sorting, filtering, and managing worksheets
- Using core functions and formulas
- Formatting worksheet elements
- Creating and managing conditional formats
- Working with charts
- Adding images and shapes
- Working with PivotTables
- Exporting workbooks
Skill Level Beginner
What you should know1m 11s
1. Getting Started with Excel
2. Managing Workbooks
3. Working with Worksheets, Cells, and Cell Data
4. Sorting, Filtering, and Managing Worksheets
5. Summarizing Data Using Formulas and Functions
6. Formatting Worksheet Elements
7. Working with Charts
8. Working with External Data and Objects
9. Exploring PivotTables
10. Reviewing and Sharing Spreadsheets
Further information1m 2s
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.