The ribbon contains every command you’ll ever need in Excel, grouped by logical function into tabs.
It’s a great way to explore what Excel can do.
Let’s take a look.
The ribbon is divided into tabs.
Each tab contains logically grouped commands, further sub-divided into Groups.
Clicking this arrow brings up more related commands.
The first tab is called File.
The file tab allows you to go “backstage”, in Microsoft’s parlance.
We’ll look at this tab in more detail in an upcoming lesson.
The next tab is Home.
The Formulas tab provides tools for inserting functions.
It also contains commands for naming ranges and tools for troubleshooting formulas and calculating worksheets.
The Data tab contains tools for importing external data.
It also contains commands for sorting and filtering data, manipulating data, and outlining.
The ribbon also has context sensitive tabs that only appear when you select certain items.
And if you select a chart, you’ll see new tabs for Design, Layout, and Format.
Click once to hide the ribbon.
Click again to show the ribbon.
