Table of Contents$_{ }$ PURPOSE AND OVERVIEW .................................................................................................................................................................1 Table of Contents$_{ ........................................................................................................................................................................... 2}$ SECTION I: WHAT IS EXCEL? ...............................................................................................................................................................4 WHAT CAN I DO WITH THIS?......................................................................................................................................................................... 4  SECTION II: CELLS, ROWS, AND COLUMNS.........................................................................................................................................4 WHAT IS A CELL?........................................................................................................................................................................................ 4  WHAT ARE ROWS AND COLUMNS? ................................................................................................................................................................ 4  INSERTING ROWS AND COLUMNS................................................................................................................................................................... 4  SECTION III: NAVIGATION..................................................................................................................................................................6 MOVING BETWEEN CELLS............................................................................................................................................................................ 6  SELECTING MULTIPLE CELLS ......................................................................................................................................................................... 6  SELECTING ENTIRE ROWS AND COLUMNS ....................................................................................................................................................... 6  SELECTING MULTIPLE ROWS AND COLUMNS ................................................................................................................................................... 6  SECTION IV: FORMATTING.................................................................................................................................................................7 CELLS....................................................................................................................................................................................................... 7  TABLES..................................................................................................................................................................................................... 8  Choosing a Table Style to Create a Table ......................................................................................................................................... 8 Adjust the Table Style ....................................................................................................................................................................... 9 Creating or Deleting a Custom Table Style ....................................................................................................................................... 9 Removing a Table Style .................................................................................................................................................................. 11 Converting a Table to a Range of Data .......................................................................................................................................... 11 Formatting Table Elements ............................................................................................................................................................ 11 Pivot Tables .................................................................................................................................................................................... 12 CONDITIONAL FORMATTING ....................................................................................................................................................................... 14  Highlight Cells Rules ....................................................................................................................................................................... 14 Greater Than ............................................................................................................................................................................................. 14  Less Than ................................................................................................................................................................................................... 15  Between .................................................................................................................................................................................................... 16  Equal To ..................................................................................................................................................................................................... 16  Text That Contains..................................................................................................................................................................................... 17  A Date Occurring ....................................................................................................................................................................................... 18  Duplicate Values ........................................................................................................................................................................................ 18  Top/Bottom Rules........................................................................................................................................................................... 19 Top 10 Items.............................................................................................................................................................................................. 19  Top 10% ..................................................................................................................................................................................................... 20  Above Average .......................................................................................................................................................................................... 21  Data Bars ........................................................................................................................................................................................ 22 Color Scales..................................................................................................................................................................................... 23 New Rule......................................................................................................................................................................................... 24 Clear Rules ...................................................................................................................................................................................... 25 Manage Rules................................................................................................................................................................................. 26 SECTION V: SEPARATING TEXT WITHIN A CELL ................................................................................................................................27 SECTION VI: SORTING ......................................................................................................................................................................28 ALPHABETICAL ......................................................................................................................................................................................... 28  NUMERICALLY ......................................................................................................................................................................................... 29  MULTI-LEVEL SORTING.............................................................................................................................................................................. 29  SORTING BY CELL COLOR ........................................................................................................................................................................... 31  2 