You might want to take a step backwards from your question, and first ask "what are orthogonal functions and why are they useful in applied math and physics". Google will find you lots of web pages.
Spherical harmonics are one of may different sets of orthogonal functions, and they are useful when the boundary conditions are defined on spherical surfaces (hence the name).