Excel Metrics

Understanding Excel
Basics
Text to columns and back
Relative and absolute values
Names
CountIf / sumIf
Subtotal vs consolidate
Paste special
Autofill
Formulas if, then
Audit formulas
Filter
Conditional formatting

Application to Metrics
Understand the numbers
Types of reports
Gas gauge
Progress chart
Defect find / fix rate

Share
Related Documents
  1. Metrics for Software Development Life Cycle (1907)
  2. [Free] Omnibug : tool for web metrics debugging (4680)
  3. Function Point Analysis Training Manual (108 pages) (1825)
  4. Software Testing Effort Estimation - An Art (3653)
  5. [Paid] AppsWatch : End-user Metrics, Performance Monitoring (1966)
  6. Requirement Traceability Matrix (3160)
  7. Software Quality Assrance Traceability Audit (1641)
  8. Pareto Chart (1878)
  9. International standard for testing metrics? (2033)
  10. 2011-06-27, International Conference on Secure Software Integration and Reliability Improvement (SSIRI 2011) @ Korea (2650)
  11. What is Traceability Matrix? (3754)
  12. Complexity Management Newsletter (1050)
  13. Requirements Traceability Matrix (3444)
  14. [Ebook] Software Testing Metrics (6957)
  15. Defect Measurement Manual (1405)
  16. Systems Engineering Measurement (1394)
  17. Software Metrics and Quality (1092)
  18. An Agile Approach to "Metrics" (1903)
  19. Software Metrics and Standards (1708)
  20. Requirements Traceability Matrix (2572)