David Nettleton, is an FDA Compliance Specialist for 21 CFR Part 11, HIPAA, and Computer System Validation. His latest book is "Risk Based Software Validation - Ten easy Steps" that relates to the development, purchase, installation, operation and maintenance of computerized systems used in regulated applications. He specializes in performing gap analysis, remediation plans, SOP development, vendor audits, training, and project management. He has completed more than 185 mission critical software validation projects.
Excel has a variety of tools like sorting, filtering, and subtotal to manage large lists of data, but if you need to analyze all that data and do it quickly, there's no better feature than a PivotTable. You can quickly create a compact summary report (based on tons of data) without needing to write complex formulas or rely on lengthy techniques.