It means one who is extremely good at something. For example, I feel Celine Dion has an exceptional singing ability. Another example would be a psychic who has an exceptional ability for predicting the future (if ones believes in that sort of thing). Also, Terry Fader has an exceptional ability in ventroliquism (he won last year's America's Got Talent).