Microsoft Office Excel 2016 for Windows

[Pages:32]Microsoft Office Excel 2016 for Windows

Introduction to Excel

University Information Technology Services

Learning Technologies, Training & Audiovisual Outreach

Copyright ? 2016 KSU Division of University Information Technology Services This document may be downloaded, printed, or copied for educational use without further permission of the University Information Technology Services Division (UITS), provided the content is not modified and this statement is not removed. Any use not stated above requires the written consent of the UITS Division. The distribution of a copy of this document via the Internet or other electronic medium without the written permission of the KSU - UITS Division is expressly prohibited.

Published by Kennesaw State University ? UITS 2016 The publisher makes no warranties as to the accuracy of the material contained in this document and therefore is not responsible for any damages or liabilities incurred from UITS use.

Microsoft product screenshot(s) reprinted with permission from Microsoft Corporation.

Microsoft, Microsoft Office, and Microsoft Excel are trademarks of the Microsoft Corporation.

University Information Technology Services

Microsoft Office: Excel 2016 Introduction to Excel

Table of Contents

Introduction ................................................................................................................................................ 5 Learning Objectives..................................................................................................................................... 5 The Office 2016 Interface ........................................................................................................................... 6

The Ribbon .............................................................................................................................................. 6 Customizing the Ribbon ...................................................................................................................... 7

The Quick Access Toolbar ....................................................................................................................... 9 Tell Me and Smart Lookup .................................................................................................................... 10 The Smart Lookup Tool ......................................................................................................................... 13 The File Tab ........................................................................................................................................... 14 Columns and Rows.................................................................................................................................... 15 Entering Text ............................................................................................................................................. 16 Long Words and Numbers ........................................................................................................................ 16 Completing a Series .................................................................................................................................. 17 Selecting Multiple Cells............................................................................................................................. 18 Moving Text and Numbers........................................................................................................................ 19 Copying Data ............................................................................................................................................. 20 Insert a Row or Column ............................................................................................................................ 21 Delete a Row or Column ........................................................................................................................... 23 Changing Column Width and Row Height ................................................................................................ 23 Formatting Numbers................................................................................................................................. 25 Formatting Text and Numbers.................................................................................................................. 25 Changing the Font ................................................................................................................................. 26 Borders...................................................................................................................................................... 26

Graphics .................................................................................................................................................... 27 Clip Art .................................................................................................................................................. 28 Images from a File................................................................................................................................. 29

Printing...................................................................................................................................................... 29 Saving ........................................................................................................................................................ 31 Additional Help ......................................................................................................................................... 32

Introduction

This booklet is the companion document to the Excel 2016: Intro to Excel workshop. It includes an introduction to the Microsoft Office 2016 interface and covers the various aspects of creating, formatting, editing, saving, and printing a document in Excel 2016.

Learning Objectives

After completing the instructions in this booklet, you will be able to: Identify the components of the Office 2016 interface Be familiar with the layout of the spreadsheet Have the ability to enter text and numbers Have the ability to modify a spreadsheet Know how to change the appearance of text and numbers within the spreadsheet Be able to apply borders Be able to insert graphics Be able to add headers and footers Be able to insert hyperlinks Be able to work with shapes Have the ability to print Know how to save a worksheet

Revised: 6/2/2016

Page 5 of 32

The Office 2016 Interface

The Office 2016 interface is similar to the Office 2013 interface, with a few minor changes. The following describes the Office 2016 interface.

The Ribbon

The Ribbon is a panel that contains functional groupings of buttons and drop-down lists organized by tabs. Each application in the Office Suite has a different set of tabs (with some tabs in common) that pertain to the functionality of that particular application. Each tab is further divided into groups (of buttons), such as the Font and Alignment groups, which are shown in Figure 1.

Figure 1 - Ribbon

At the bottom-right corner of some groups, there is a diagonal arrow called a Dialog Box Launcher. Clicking this button opens a dialog box for that group containing further option selections.

Figure 2 - Dialog Box Launcher

There are also contextual tabs that appear, depending on what you are working on. For example, if you have inserted pictures, the Picture Tools tab appears whenever a picture is selected.

Figure 3 - Contextual Tab

Page 6 of 32

Customizing the Ribbon In Excel you can build your own tab(s). The following explains how to build your own tabs/groups:

1. Right-click anywhere in the ribbon. 2. Select Customize the Ribbon.

Figure 4 - Customize the Ribbon

3. On the right side of the window, underneath the Customize the Ribbon section, click the button New Tab.

Figure 5 - New Tab Button

4. You will see that New Tab has been added in the list of Main Tabs. Under New Tab, you will see

New Group. Click once to select New Group.

Figure 6 - New Tab Added to List

Page 7 of 32

5. In the Excel Options window, you will see a pane on the left with many commands. Click to select the command that you want to add to the New Group (see Figure 7).

6. Click the Add>> button (see Figure 7).

Figure 7 - Add Button

7. Repeat steps 4-5 above to add additional commands to the group. 8. To rename the tab or group, select New Tab or New Group. 9. Click the Rename button in the bottom-right corner of the window.

Figure 8 - Rename Button

10. To hide a tab, remove the check-mark next to the name of the tab. 11. When you are done, select OK. The new tab will be added to the Ribbon.

Figure 9 - New Tab added to Ribbon

Page 8 of 32

 ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download