Go to: Level 1 2 3 4 5 6 7 8 9 10 11 12 16 13 14 15 17

Practice Exercise

  • Open the sample Excel list, Friends and Family.xls

  • When prompted, SAVE to your Documents folder

  • Open the Friends and Family spreadsheet and review the data.

A B C D
1 FirstName LastName Company JobTitle
2 Todd Borek Bell-Borek Home Director
3 Mary McCrickard Charity Social Services Manager
4 Bonnie Bondy Brighton Towne Co Sales Associate

 

Sort the Data

  • Go to the Home Ribbon

  • Select Sort & Filter.

  • Sort this data by LastName.

more on the next page

Level 6: Create a Form Letter, part one