facebook google plus twitter
Webucator's Free Introduction to Microsoft Excel 2013 Tutorial

Lesson: The Ribbon

Welcome to our free Introduction to Microsoft Excel 2013 tutorial. This tutorial is based on Webucator's Introduction to Microsoft Excel 2013 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. In this lesson, you will learn about all three.

Lesson Goals

  • Learn about tabs.
  • Learn about groups.
  • Learn about commands.
  • Learn which groups and commands are found on which tabs.

Tabs

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:

  1. HOME. The HOME tab includes commands for formatting worksheets, cells and data and commands for inserting and deleting columns and rows.
  2. INSERT. Use the INSERT tab to insert tables, illustrations, charts, links, sparklines, headers & footers, custom text and symbols, and more.
  3. PAGE LAYOUT. Use the PAGE LAYOUT tab to change your margins, change the page background, change the page orientation, and more.
  4. Formulas. Use the FORMULAS tab to browse and select formulas and functions, to define names, to audit formulas, and more.
  5. DATA. Use the DATA tab to access external data, to sort & filter, to access data tools, to group cells together, to add subtotals, and more.
  6. REVIEW. Use the REVIEW tab to check spelling, add comments, protect your worksheet or workbook, and more.
  7. VIEW. Use the VIEW tab to change your workbook view, show or hide gridlines, headings, the formula bar and the ruler, arrange windows, freeze panes, zoom in or out, and more.
  8. ADD-INS. You may or may not see the ADD-INS tab. This tab shows up after you install and activate your first Add-In. Add-Ins are beyond the scope of this course.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.

Tool Tabs

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:

  • That they exist. Some of the most commonly used tool tabs are:
    • SMARTART
    • CHART
    • DRAWING
    • PICTURE
    • PIVOTTABLE
    • PIVOTCHART
    • HEADER & FOOTER
  • That they will appear when you select commands which have related tool tabs. For example, when you insert a PivotTable, two PivotTable-specific tool tabs (ANALYZE (Options in Excel 2007/2010) and DESIGN) will appear: PivotTable Tools Tabs

Groups

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:

Tab Group
HOME
  1. Clipboard
  2. Font
  3. Alignment
  4. Number
  5. Styles
  6. Cells
  7. Editing
INSERT
  1. Tables
  2. Illustrations
  3. Charts
  4. Sparklines
  5. Filter
  6. Links
  7. Text
  8. Symbols
PAGE LAYOUT
  1. Themes
  2. Page Setup
  3. Scale to Fit
  4. Sheet Options
  5. Arrange
FORMULAS
  1. Function Library
  2. Defined Names
  3. Formula Auditing
  4. Calculation
DATA
  1. Get External Data
  2. Connections
  3. Sort & Filter
  4. Data Tools
  5. Outline
REVIEW
  1. Proofing
  2. Language
  3. Comments
  4. Changes
VIEW
  1. Workbook Views
  2. Show
  3. Zoom
  4. Window
  5. Macros
ADD-INS
  1. Custom Toolbars

The group options may differ slightly if you are using Excel 2007 or 2010.

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:Dialog Box Launcher

Commands

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.

Exploring the Ribbon

Duration: 10 to 20 minutes.

In this exercise, you will explore the Ribbon to answer the following questions:

  1. How many tabs are there?
  2. How many groups are there on the VIEW tab?
  3. Which tab contains the most commonly used groups and commands?
  4. What is another name for the FILE menu?
  5. On what tab are the following groups found:
    1. Sort & Filter
    2. Zoom
    3. Charts
    4. Page Setup
    5. Function Library
    6. Number
    7. Formula Auditing
  6. On what tabs and groups are the following commands found?
    1. Font Color
    2. New Window
    3. Sort
    4. Trace Precedents
    5. Wrap Text
    6. Group
    7. Print Area

Solution:

If your installation of Microsoft Excel has been customized, some of your answers may differ.

  1. How many tabs are there? Answer: 7
  2. How many groups are there on the VIEW tab? Answer: 5
  3. Which tab contains the most commonly used groups and commands? Answer: Home
  4. What is another name for the FILE menu? Answer: the Backstage view
  5. On which tab are the following groups found:
    1. Sort & Filter - Answer: DATA
    2. Zoom - Answer: VIEW
    3. Charts - Answer: INSERT
    4. Page Setup - Answer: PAGE LAYOUT
    5. Function Library - Answer: FORMULAS
    6. Number - Answer: HOME
    7. Formula Auditing - Answer: FORMULAS
  6. On what tabs and groups are the following commands found?
    1. Font Color - Answer: HOME > Font
    2. New Window - Answer: VIEW > Window
    3. Sort - Answer: DATA > Sort & Filter
    4. Trace Precendents - Answer: FORMULAS > Formula Auditing
    5. Wrap Text - Answer: HOME > Alignment
    6. Group - Answer: DATA > Outline
    7. Print Area - Answer: PAGE LAYOUT > Page Setup