Excel gives you two main weapons. The first is the pivot table — fast, flexible, great for exploration. The second is aggregate functions like SUMIF — a bit more work to set up, but powerful for automation: the moment new data comes in, the result updates itself.