Welcome to our free Introduction to Microsoft Excel tutorial. This tutorial is based on Webucator's Introduction to Microsoft Excel 2019 Training course.
The Ribbon is the display you see at the top of the Microsoft Excel window. It is your primary interface with Excel. It allows you to access most of the commands available to you in Excel. The Ribbon is composed of three parts: Tabs, Groups, and Commands.
Microsoft Excel is a powerful program which is used to analyze and present data, perform calculations, and much more. Microsoft Excel has hundreds of commands for working with different scenarios. To make it easier for users to find the specific commands they are looking for, commands are organized onto eight main tabs:
Note that the File menu is not the same as a tab. The File menu takes you to the Backstage view, where you manage, rather than make changes to, your workbook. The Backstage view is covered in the next lesson.
In addition to the main tabs, there are numerous tool tabs which include less commonly used commands. Individual tool tabs are covered in detail in our intermediate and advanced Microsoft Excel classes. For now you should know:
To further organize the many commands available in Microsoft Excel, commands are organized in groups on each tab. Each group contains three or more related commands. The following table lists the groups found on each tab:
The group options may differ slightly if you are using previous versions of Excel. Excel 2016 and 2019 provide some new groups, including Insert > Add-ins and Tours, Data > Get & Transform and Forecast, and Review > Insights ..
In some groups, you will see a button in the lower right corner, next to the group name. This is the Dialog Box Launcher. Opening the group's dialog box will give you access to additional commands associated with that group:
In Excel 2016 and 2019, the Ribbon contains the text "Tell me what you want to do..."
If you click this text, it becomes a text box where you can enter text to search on to quickly perform actions. Just clicking the box pops up some possible ideas.
For example, "Add a comment" brings up a comment in the cell the cursor is in.
Commands are controls that enable you to accomplish specific tasks, such as bolding a word, wrapping text, changing the format of a number to percent, or adding a column.
In this exercise, you will explore the Ribbon to answer the following questions:
If your installation of Microsoft Excel has been customized, some of your answers may differ.