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

  1. [2010/11/23] Metrics for Software Development Life Cycle *1 by Andrewupmanyu ()
  2. [2010/11/29] [Free] Omnibug : tool for web metrics debugging *1 by zsrsicks (5150)
  3. [2010/12/17] Function Point Analysis Training Manual (108 pages) *3 by nadodi ()
  4. [2010/11/22] Software Testing Effort Estimation - An Art *5 by Rizwan ()
  5. [2010/12/16] [Paid] AppsWatch : End-user Metrics, Performance Monitoring *1 by VTB (1/2048)