No name manager in Excel Mac 2011

view full story

http://superuser.com – I am currently following a video tutorial on this link: http://www.youtube.com/watch?v=vkPoViUhkxU Please start it on 9:50, you will see he is using name manager command but in Excel Mac 2011 it hasn't got it. I want to know what is the equivalent way of doing this on mac excel because i am trying to create a searchable drop down menu. I tried Insert, name, Define and did it that way but it does not seem to allow the drop down menu to work so I think this isn' the correct solution. Thanks (HowTos)