EXCEL TRAINING MANUAL Page 1 GLYPH<g3> TABLE OF CONTENTS 1. INTRODUCTION TO EXCEL .......................................................................................................... 5 1.1 WHAT IS A SPREADSHEET? .................................................................................................. 5 1.2 WHAT CAN A SPREADSHEET DO? ..................................................................................... 6 1.3 BENEFITS OF USING EXCEL .................................................................................................. 6 1.3.1 USER FRIENDLY INTERFACE ....................................................................................... 6 1.3.2 MANAGES AND ORGANIZE MASSIVE DATA ......................................................... 6 1.3.3 PROVIDES BETTER ANALYSIS...................................................................................... 6 1.3.4 ENJOY POWERFUL AND IMPROVED TABLE FEATURES ...................................... 7 1.3.5 SHARE SPREADSHEETS ................................................................................................. 7 2. ERROR MESSAGES (CELL REFERENCE) ..................................................................................... 7 2.1 INVALID CELL REFERENCE ................................................................................................. 7 2.2 COLUMN NOT WIDE ENOUGH ........................................................................................... 8 2.3 DIVIDING BY ZERO ................................................................................................................. 8 3. CONDITIONAL FORMATTING..................................................................................................... 8 3.1 ADVANTAGES OF CONDITIONAL FORMATTING ......................................................... 9 3.2 HOW TO APPLY CONDITONAL FORMATTING .............................................................. 9 3.2.1 TO APPLY CONDITIONAL FORMATTING: ............................................................... 9 3.2.2 TO REMOVE CONDITIONAL FORMATTING:......................................................... 10 3.2.3 TO APPLY NEW FORMATTING:................................................................................. 10 3.2.4 TO MANAGE CONDITIONAL FORMATTING: ....................................................... 11 4. SORTING .......................................................................................................................................... 12 4.1 HOW TO APPLY: .................................................................................................................... 12 4.1.1 TO SORT IN ALPHABETICAL ORDER: ...................................................................... 12 4.1.2 TO SORT FROM SMALLEST TO LARGEST: .............................................................. 12 5. FUNCTIONS ..................................................................................................................................... 13 5.1 INDEX MATCH FUNCTION................................................................................................. 13 5.2 How to Apply: .......................................................................................................................... 15