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

You would..
Share
Related Documents
  1. Requirement Traceability Matrix (2748)
  2. Software Testing Effort Estimation - An Art (2859)
  3. [Free] Omnibug : tool for web metrics debugging (3301)
  4. What is Traceability Matrix? (3097)
  5. Metrics for Software Development Life Cycle (1677)
  6. 2011-06-27, International Conference on Secure Software Integration and Reliability Improvement (SSIRI 2011) @ Korea (2169)
  7. [Free] MTBF (Mean Time Between Failures) Calculator : Software tool for Reliability Prediction (2867)
  8. Pareto Chart (1516)
  9. Software Quality Assrance Traceability Audit (1342)
  10. International standard for testing metrics? (991)
  11. [Paid] AppsWatch : End-user Metrics, Performance Monitoring (1552)
  12. Function Point Analysis Training Manual (108 pages) (1577)
  13. Software Metrics and Standards (1441)
  14. Requirements Traceability Matrix (2096)
  15. Defect Measurement Manual (1146)
  16. [Ebook] Software Testing Metrics (5799)
  17. Systems Engineering Measurement (1117)
  18. 12 Steps to Useful Software Metrics (1489)
  19. where can I find a detail about Goal Question Metric (GQM) approach? (866)
  20. Complexity Management Newsletter (804)