Excel 2016 Tips and Tricks

Table of Contents

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

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

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

LESSON 1 -

USING CONDITIONAL AND CUSTOM FORMATS ...............................1 Applying Conditional Formats ..................................................................................2 Changing a Conditional Format ................................................................................4 Adding a Conditional Format....................................................................................7 Creating a Custom Conditional Format ....................................................................9 Using Data Bars.......................................................................................................11 Deleting a Conditional Format ...............................................................................13 Creating a Custom Number Format .......................................................................14 Exercise...................................................................................................................18 WORKING WITH TABLES...............................................................19 Using Tables............................................................................................................20 Creating a Table from Existing Data .......................................................................20 Changing the Table Name ......................................................................................23 Changing the Table Style ........................................................................................25 Changing Table Style Options.................................................................................26 Creating a Total Row ..............................................................................................29 Adding Table Rows and Columns ...........................................................................32 Inserting/Deleting Table Rows/Columns................................................................35 Creating a Calculated Column ................................................................................37 Selecting Parts of a Table .......................................................................................38 Moving a Table .......................................................................................................41 Sorting Data by Multiple Levels..............................................................................43 Using Text Filters ....................................................................................................47 Using Number Filters ..............................................................................................50 Using Data Validation .............................................................................................53 Validating Data using a List.....................................................................................56 Creating a Custom Error Message ..........................................................................59

LESSON 2 -

OFFICEPRO, Inc.

Page iii