Excel 2016 Introduction

Table of Contents

ABOUT OFFICEPRO – WE CHANGE LIVES! ...............................................................I

WHAT TO EXPECT FROM OFFICEPRO?...................................................................II

TABLE OF CONTENTS...........................................................................................III

LESSON 1 -

EXPLORING EXCEL ..........................................................................1 Working with Excel ...................................................................................................2 Starting Excel ............................................................................................................3 Using the Interface ...................................................................................................4 Using the File Tab .....................................................................................................6 Exploring Excel Options ............................................................................................8 Working with Worksheets......................................................................................10 Using the Ribbon ....................................................................................................11 Hiding the Ribbon...................................................................................................15 Customizing the Quick Access Toolbar...................................................................17 Using the Mini Toolbar ...........................................................................................21 Customizing the Status Bar.....................................................................................23 Customize the Ribbon ............................................................................................25 Getting Help in Excel ..............................................................................................28 Exiting Excel ............................................................................................................29 Exercise...................................................................................................................31 USING BASIC WORKBOOK SKILLS..................................................33 Selecting a Cell using the Keyboard........................................................................34 Using KeyTips..........................................................................................................36 Scrolling using the Mouse ......................................................................................38 Using the Scroll Bar Shortcut Menu .......................................................................41 Using the Go To Dialog Box ....................................................................................42 Entering Text into Cells...........................................................................................44 Entering Numbers into Cells...................................................................................47 Using Flash Fill ........................................................................................................50 Saving a New Workbook.........................................................................................51 Closing a Workbook................................................................................................55

LESSON 2 -

OFFICEPRO, Inc.

Page iii