Microsoft Excel 
  St. George’s Information Services 
 
Contents 
Understanding Workbooks ................................................................................................................................ 1 
Navigating in a File ............................................................................................................................................ 2 
Typing Text or Numbers Into A Worksheet ....................................................................................................... 3 
Typing Simple Formulas In A Worksheet .......................................................................................................... 4 
Filling A Series ................................................................................................................................................... 5 
Inserting And Deleting Worksheets ................................................................................................................... 6 
Copying A Worksheet ........................................................................................................................................ 7 
Renaming A Worksheet ..................................................................................................................................... 8 
Moving or Copying A Sheet To Another Workbook ........................................................................................... 9 
Changing Worksheet Tab Colours .................................................................................................................. 10 
Grouping Worksheets ...................................................................................................................................... 11 
Freezing Rows And Columns .......................................................................................................................... 12 
Selecting Ranges .............................................................................................................................................................. 13 
Selecting Rows ................................................................................................................................................ 14 
Selecting Columns ........................................................................................................................................... 15 
Understanding Formatting ................................................................................................................................................. 16 
Applying General Formatting ........................................................................................................................... 17 
Changing Fonts ............................................................................................................................................... 18 
Changing Font Size ......................................................................................................................................... 19 
Understanding Borders .................................................................................................................................... 20 
Applying A Border To A Range ....................................................................................................................... 21 
Wrapping And Merging Text ............................................................................................................................ 22 
PRACTICE EXERCISE .......................................................................................................................................... 23 
PRACTICE EXERCISE .......................................................................................................................................... 24