In my previous role as a data quality coordinator, I mostly use Google Sheets and Microsoft Excel. There we used to have reports and all the reports needs to be cross-validated against different systems. So we used to keep a validation, we used to mostly use validation tools and pivot tables to create a table or a chart where we could spot if there's any one department where we were getting more data inconsistencies. So tables and validation tool was mainly the main tools that we used to use. And the formulas like sum and if statements also, which was not used as much, but it was used a bit, I guess.
