Excel 2016 Introduction

Creating a New Workbook .....................................................................................56 Using a Template ....................................................................................................58 Opening an Existing Workbook ..............................................................................60 Using Data Entry Shortcuts.....................................................................................63 Editing Cell Entries..................................................................................................66 Checking Worksheet Spelling .................................................................................68 Creating a New Folder ............................................................................................72 Renaming an Existing Workbook............................................................................75 Exercise...................................................................................................................78 WORKING WITH RANGES .............................................................81 Using Ranges...........................................................................................................82 Selecting Ranges with the Mouse ..........................................................................82 Selecting Ranges with the Keyboard ......................................................................85 Selecting Non-Adjacent Ranges..............................................................................88 Entering Values into a Range..................................................................................90 Using the Auto Fill Feature .....................................................................................92 Exercise...................................................................................................................95 CREATING SIMPLE FORMULAS......................................................97 Using Formulas .......................................................................................................98 Entering Formulas ..................................................................................................99 Using Functions ....................................................................................................102 Using the AutoSum Button...................................................................................103 Using the AutoSum List ........................................................................................105 Using Formula AutoComplete ..............................................................................107 Inserting Functions in Formulas ...........................................................................111 Editing Functions ..................................................................................................114 Using the AutoCalculate Feature..........................................................................116 Using Range Borders to Modify Formulas............................................................119 Checking Formula Errors ......................................................................................121 Exercise.................................................................................................................124 WORKING WITH COLUMNS AND ROWS ...................................... 127 Selecting Columns and Rows................................................................................128

LESSON 3 -

LESSON 4 -

LESSON 5 -

Page iv

OFFICEPRO, Inc.