Have an excel spread sheet built that would have formulas built in so that I could copy and past in information and have it auto filter

I use software that does not organize information as I need it. I can run a report and download as an excel file. I would like to know if an excel spreadsheet can be created with formulas built in so that I could copy and paste the information from my software report and have it organize it with formulas for sum, average and if/then statments.