Hi I am fairly new to excel as I have been using iWork numbers but have switched back to office for mac 2011

I have got the hang of creating tables and changing their names but is it possible to have the table name actually above the table? I am re writing an athletics work book that did not transfer well from numbers. I have got several identical tables that are named under each pupil. I would like to be able to see which pupils table I am working in by simply seeing the name above the table and not having to find it in the name box on the left.