2.

The Ribbon

In this lesson, you will learn...

1. About tabs.
Th Th
2. is
About groups. is
do do
cu cu
me me
nt nt
3. About commands. b
No ron elon No ron belon
un dy un d
a @ gs to au y@i
gs
4. Which groupsuand ini
tho commandsx ROare found on which tabs. tho nix to RO
riz i riz i
ed ndo. ND
IH ed ndo. ND
IH
co co ID c o c o ID
pie .id A pie .id AY
sa YAT sa AT
llo . llo .
we we
The Ribbon is the display you see at the d! top of the Microsoft Excel window. It is your primary interface d! 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.

Tabs
Th Th
is is
Microsoft Excel isocau powerful program which is used to analyze and present ddata,
d oc perform calculations, and much
um
me en
more. Microsoft Excel has nt hundreds of commands for working with different scenarios. t To make it easier for users
No ron elonb No ron belon
to find the specific
un commands
d gsthey are looking for, commands are organizeduonto na eight
dy main gs tabs:
au y@i uth @in
tho nix to RO ori i
to
xin RON
riz ind N z d
ed o.c DI ed o.c DI
Home . The Home tabcoincludes HI co and .id HIDA for
1. pie [Link] commands DA for formatting worksheets, cells and data pie ocommands
sa Y sa YA
inserting and deleting columns lloand [Link]. llo T.
we we
d! d!
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.
Th Th
4. Formulas is . Use the Formulas tab to browse and select formulas and
do
is functions, to define names, to audit
do
cu cu
formulas, and m more.
en me
tb nt
No ron e lon No ron belon
Data . Useuthe dy tabgto un data d
5. na Data
uth @in
s t access external data, to sort & filter, to access
oR au ytools, @ gstotogroup cells together,
t i
to add subtotals,oand ixi
riz more. ON h ori nixin RON
ed ndo. DI ze
d do
.c DI
co co HI c HI
pie . id D A
o pie [Link] DA
6. Review . Use the Review tab s Y
all to check spelling,
AT add comments, protect your worksheet or s a workbook, YAand
ow . llo T.
ed w ed
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.
Th Th
is is
do doc
cu um
me en
nt t
No ron belon No ron belon
un d gs un d gs
au y@i au y@i
tho nix to RO tho nix to RO
riz i riz i
ed ndo. ND
IH ed ndo. ND
IH
co co ID co co ID
pi .id A pi . id A
 Th Th
is is
do do
cu cu
me me
nt nt
No ron be No ron belon
lon
un d gs un d gs
au y@i au y@i
tho nix to RO tho nix to RO
riz i riz i
ed ndo. ND
IH ed ndo. ND
IH
co co ID c o c o ID
pie .id A pie .id AYyou
Note that the File menu is not the sasame as a Ytab.
AT The File menu takes you to the Backstage view,
sa where AT
llo . llo .
w
manage, rather than make changes to,edyour workbook. The Backstage view is covered in the next elesson. w
! d !

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:

Th Th
is is
do Some of the most commonly used tool tabs are:
• That they exist. do
cu cu
me me
nt nt
• SmartArt
No ron belon No ron belon
un d gs un d gs
au y@i to au y@i
• Chart t h ori n i x R tho nix to RO
ze indo OND riz i
ed ndo. ND
dc .co I c IH
op
i .id HIDA co
pie [Link] ID
AY
• Drawing e sa YA sa AT
llo T. llo .
we we
d! d!
• Picture

• PivotTable

• PivotChart

• Header & Footer

Th Th
is is
do do
c um
• That they will appear when you select commands which have related tool cu
en me
t b you insert a PivotTable, two PivotTable-specific tool tabs nt
tabs. For example,
No ron when e lon No ron b(elAnalyze
on ( Options in Excel
un dy g s u n dy g s
2007/2010) andauDesign @ ) willtoappear: au @ to
tho in RO tho in RO
riz ixind N riz ixind
ed o.c DI ed o.c NDI
co HI co HI
pie [Link] DA pie [Link] DA
sa YA sa YA
llo T. llo T.
we we
d! d!

Groups
Th Th
is is
do do
cu cu
me me
To further organize thenmanytb commands available in Microsoft Excel, commands are nt organized in groups on each
N r e N r be
tab. Each group o
o ucontains
n three l o o
o u lists
n or more related commands. The following table n thelogroups
n found on each tab:
na dy@ gs t na dy@ gs t
uth ini oR uth ini oR
ori x ori x
ze indo OND ze indo OND
dc .co IH dc . I
op .id ID op [Link] HID
i A i A
Tab Group

Home 1. Clipboard

2. Font

3. Alignment

Th 4. Number Th
is is
do do
cu cu
me me
nt 5. Styles nt
No ro be No ron belon
lo
un ndy@ ngs un d gs
au to au y@i
tho in RO tho nix to RO
riz ixind
6. Cells
riz i
ed o.c NDI ed ndo. ND
IH
co HI co co
pie [Link] DA pie .id ID
AY
sa YA 7. Editing sa AT
llo T. llo .
we we
d! d!
Insert
1. Tables

2. Illustrations

3. Add-ins

Th Th
is 4. Charts is
do do
cu cu
me me
nt nt
No ro be 5. Tours No ron belon
lo
un ndy@ ngs un d gs
au to au y@i
tho i n RO tho nix to RO
riz ixind riz i
o.c NDI ed ndo. ND
6. Sparklines
ed IH
co HI co c
pie [Link] DA pie [Link] ID
AY
sa YA sa AT
llo T. 7. Filters llo .
we we
d! d!
8. Links

9. Text

10. Symbols

Th Th
is is
Page Layout do 1. Themes do
cu cu
me me
nt nt
No ro be No ron belon
lo
un ndy@ ngs 2. Page Setup
un d gs
au to au y@i
tho in RO tho nix to RO
riz ixind riz i
ed o.c NDI 3. Scale to Fit ed ndo. ND
IH
co HI co co
pie [Link] DA pie . id ID
AY
sa YA sa AT
llo T. 4. Sheet llo .
we we
d! d!
Options

5. Arrange

Formulas 1. Function Library

Th Th
is is
do 2. Defined Names do
cu cu
me me
nt nt
No ro be No ron belon
lo 3. Formula Auditing
un ndy@ ngs un d gs
au to au y@i
tho in RO tho nix to RO
riz ixind riz i
ed o.c NDI 4. Calculation ed ndo. ND
IH
co HI co co
pi [Link] DA pi . id ID
A
Data
1. Get External Data
 Tab Group

2. Get &

Transform

3. Connections

4. Sort & Filter

Th Th
is is
do do
cu 5. Data Tools cu
me me
nt nt
No ro be No ron belon
lo
un ndy@ ngs 6. Forecast un d gs
au to au y@i
tho in RO tho nix to RO
riz ixind riz i
ed o.c NDI 7. Outline ed ndo. ND
IH
co HI co co
pie [Link] DA pie .id ID
AY
sa YA sa AT
llo T. llo .
we we
Review d! 1. Proofing d!

2. Insights

3. Language

4. Comments
Th Th
is is
do do
cu cu
me 5. Changes me
nt nt
No ro be No ron belon
lo
un ndy@ ngs un d gs
au to au y@i
View tho i n RO tho nix to RO
riz ixind 1. Workbook Views riz i
ed o.c NDI ed ndo. ND
IH
co HI co c
pie [Link] DA pie [Link] ID
AY
sa YA 2. Show sa AT
llo T. llo .
we we
d! d!
3. Zoom

4. Window

5. Macros

Th Th
Add-ins is is
do 1. Custom Toolbars do
cu cu
me me
nt nt
No ron be No ron belon
lon
u dy un dy
The group optionsnamay @ gslightly
uth differ
st
o R if you are using previous versions of Excel. au Excel @ 2016 gs
tprovides
o some new
ini t ini
o xin ON h ori xin RON
groups, including Insertriz>edAdd-ins do and D Tours , Data > Get & Transform and Forecast, z ed and d oReview D > Insights ..
co .co.i I HID co .co.i I HID
pie d AY pie d AY
sa AT sa AT
llo . llo .
In some groups, you will see a buttonwin ed the lower right corner, next to the group name. This is theweDialog Box
! d !
Launcher . Opening the group's dialog box will give you access to additional commands associated with that
group:

Th Th
is is
do do
cu cu
me me
nt nt
No
ron be No ron belon
lon
un d gs un d gs
Commands au y@i
tho nix to RO
au y@i
tho nix to RO
riz i riz i
ed ndo. ND
IH ed ndo. ND
IH
co co I c o co ID
pi . id DA pi . id A
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.
 Watch and follow along as your instructor walks you through the Ribbon and points out some of the
groups and commands located on each tab.

Exercise 2 Exploring the Ribbon

10 to 20 minutes
Th Th
is is
In this exercise,dyou
oc will explore the Ribbon to answer the following questions: do
cu
um me
en nt
tb
No ron elon No ron belon
1. How manyutabs
na aredy there? gs un d gs
uth @in to au y@i
ori ixin RO tho nix to RO
riz i
2. How many groups are
ze do
d cthere
ND
. on the I View tab? ed ndo. ND
IH
op [Link] HID co co
pie .id ID
ies AY sa AY
all AT l AT
3. Which tab contains the most commonly ow .
used groups and commands? l ow .
ed ed
! !
4. What is another name for the File menu?

5. On what tab are the following groups found:

A. Sort & Filter

B. Th
Zoom Th
is is
do do
c um cu
en me
C. Charts t nt
No ro belo No ron belon
un ndy@ ngs un d gs
au to au y@i
D. Page Setuptho in RO tho nix to RO
riz ixind riz i
ed o.c NDI ed ndo. ND
IH
HI c
E. Function Library copie [Link] DA co
pie [Link] ID
AY
sa YA sa AT
llo T. llo .
we we
F. Number d! d!

G. Formula Auditing

6. On what tabs and groups are the following commands found?

A. Font Color
Th Th
is is
B. New dWindow
oc do
cu
um me
en nt
t
C. Sort
No ron belon No ron belon
un dy un d
au @ gs to au y@i
gs
tho in RO tho nix to RO
D. Trace Precedentsriz ixind riz i
ed o.c NDI ed ndo. ND
IH
co HI co co
pie [Link] DA pie . id ID
AY
E. Wrap Text s all YA sa AT
ow T. llo .
ed we
! d!
F. Group

G. Print Area

Exercise Solution
Th Th
is is
do do
cu cu
me me
nt nt
If your installation
No of
ron b
Microsoft
e Excel has been customized, some of your
No ron belonmay differ.
answers
lon
un d gs un d gs
au y@i au y@i
1. How many tabs thare nix toAnswer:
ori there? RO 7 tho nix to RO
ze indo ND riz i
ed ndo. ND
dc . I IH
op [Link] HID co
pi
co
. id ID
2. How many groups are there i on the View A tab? Answer: 5 A
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:

A. Sort & Filter - Answer: Data

B. Zoom - Answer: View

Th Th
is is
C. Chartsdo - Answer: Insert do
cu cu
me me
nt nt
D. No Setup
Page ron - bAnswer:
elo
ng Page Layout No ron belon
un d un d gs
au y@i s au y@i
tho nix to RO tho nix to RO
riz - iAnswer: riz i
E. Function Library ed ndo. NDFormulas
IH ed ndo. ND
IH
co co ID co co ID
pie .id AY pie .id AY
F. Number - Answer: Home sa AT sa AT
llo . llo .
we we
d! d!
G. Formula Auditing - Answer: Formulas

6. On what tabs and groups are the following commands found?

A. Font Color - Answer: Home > Font

B. New
Th Window - Answer: View > Window Th
is is
do do
cu cu
C. m
Sort - Answer:en Data > Sort & Filter me
tb nt
No ron elon No ron belon
d
TraceunPrecendents gs- Answer: Formulas > Formula Auditing un d gs
D. au y@i au y@i
tho nix to RO tho nix to RO
riz i riz i
ed ndo. ND
I>HAlignment ed ndo. ND
I
E. Wrap Text - Answer: co Home co ID c op [Link] HID
pie .id A i e AY
sa YA sa AT
llo T. llo .
F. Group - Answer: Data > Outline we we
d! d!

G. Print Area - Answer: Page Layout > Page Setup

Conclusion
Th Th
is is
do do
c um
In this lesson, you learned about tabs, groups and commands and which groups cu and commands are on which tabs.
en me
tb nt
No ron e lon No ron belon
un d gs un d gs
au y@i au y@i
tho nix to RO tho nix to RO
riz i riz i
ed ndo. ND
IH ed ndo. ND
IH
co co I c o co ID
pie . id D AY pie . id AY
sa A s a AT
llo T. llo .
we we
d! d!

Th Th
is is
do do
cu cu
me me
nt nt
No ro be No ron belon
lo
un ndy@ ngs un d gs
au to au y@i
tho in RO tho nix to RO
riz ixind riz i
ed o.c NDI ed ndo. ND
IH
co HI co co
pi [Link] DA pi . id ID
A