Excel 2016 Introduction

Excel 2016

Lesson – Exploring Excel

13. Click OK

to close the Rename dialog box.

14. Click OK

in the Excel Options dialog box to save the changes.

NOTE The first time you add a Power View report, Excel displays a prompt asking you to enable the feature.



S TEP - BY -S TEP

Customize the Ribbon.

Open a new worksheet.

Steps

Practice Data

1. Select the File tab.

Click

The File options open.

2. Select Options .

Click Options

The Excel Options dialog box appears.

3. Select Customize the Ribbon . Ribbon options appear.

Click Customize Ribbon

4. In the Main Tabs list, click the tab where you want to add a new group. The tab name is selected.

Click View

5. Select the New Group button.

Click

A new group is added with the name New Group (Custom).

6. In the Choose commands from drop- down list, select Commands Not in the Ribbon . Commands not in the ribbon appear in the list box. 7. Select the Insert a Power View Report option. The Insert a Power View Report is highlighted.

Click Commands Not in the Ribbon

Click Insert a Power View Report

OFFICEPRO, Inc.

Page 27