accounts, and stock control

What do you guys use to workout things like bestselling products, revenue, profit, revenue per manufacturer etc?

At the moment I type every order into Excel manually which works fine but it takes ages.

Would appreciate some feedback as obviously my method isnt the best way.