I always wanted to ask this question since when I joined MSE, but because I was afraid of asking too many soft questions I never asked it. I've seen some pretty complicated integrals and infinite products and infinite series and other math equations that have been reduced to simple closed form expressions using special functions like polylogarithms, Riemann's zeta function, Bessel functions and other such functions.
People like Vladimir Reshetnikov, Robjohn, Eric Naslund, SOS440 among many others have always impressed me with their ability to find closed form expressions for very complicated mathematical formulas.
The problem is that this part of mathematics, which I find it incredibly beautiful and aesthetic, is usually not covered in a typical math curriculum. I tried to find a book that explains how such closed form expressions are found with lots of problems to practice but I haven't found any yet. I checked some books about hypergeometric series, but they were rather too technical and they preferred to focus on analysis of hypergeometric series, not their manipulations and techniques of doing calculations with them.
My main question is that if I want to be nearly as good as the people I mentioned in finding closed form expressions, where should I start from? How much math background and maturity do I need? Can you suggest any good books or video lectures for that?