LatticeMLS
Menu

Module GLP-36 · Version 1.0

Excel Analysis and Laboratory Data Visualization

A guided walkthrough of building a validated, auditable spreadsheet analysis from a raw laboratory export: cleaning data without altering the source, writing structured formulas that are tested and locked, and choosing an honest chart for the question being asked.

Your next section

Start section 1

Read without an account. Sign in to save.

Who this module is for

Laboratory technologists, generalists, and section supervisors who build or review spreadsheet-based calculations, dashboards, or turnaround-time summaries from laboratory data.

Learning objectives

  • Import and clean tabular laboratory data while preserving the original raw source values unaltered
  • Use structured references, formulas, lookups, and validation controls to build a calculation chain that is auditable and correctly handles missing or boundary values
  • Choose a chart that honestly reveals a trend, distribution, comparison, agreement, or process-performance question without exaggerating or hiding a result

How completion works

Mark every required section done and answer every knowledge check in those sections correctly. The final save completes the module automatically.

Sources

12 sources

  1. 1. 42 CFR § 493.1291, Standard: Test report. Code of Federal Regulations, current.

    Source note · federal regulation

  2. 2. 42 CFR § 493.1105, Standard: Retention requirements. Code of Federal Regulations, current.

    Source note · federal regulation

  3. 3. 42 CFR § 493.1283, Standard: Test records. Code of Federal Regulations, current.

    Source note · federal regulation

  4. 4. 45 CFR § 164.312, Technical safeguards, HIPAA Security Rule; HHS Office for Civil Rights, Summary of the HIPAA Security Rule.

    Source note · federal regulation

  5. 5. College of American Pathologists, Guide to Accreditation, November 2025 edition; CAP Accreditation Checklists program page.

    Source note · accreditation standard

  6. 6. CLSI QMS06, Quality Management System: Continual Improvement, 4th edition. Clinical and Laboratory Standards Institute, published July 28, 2025.

    Source note · consensus standard

  7. 7. CLSI C24, Statistical Quality Control for Quantitative Measurement Procedures: Principles and Definitions, 4th edition. Clinical and Laboratory Standards Institute, 2016.

    Source note · consensus standard

  8. 8. CLSI EP28-A3c, Defining, Establishing, and Verifying Reference Intervals in the Clinical Laboratory; Approved Guideline, 3rd edition. Clinical and Laboratory Standards Institute.

    Source note · consensus standard

  9. 9. CLSI EP09c, Measurement Procedure Comparison and Bias Estimation Using Patient Samples, 3rd edition. Clinical and Laboratory Standards Institute.

    Source note · consensus standard

  10. 10. Panko, R.R. "What We Don't Know About Spreadsheet Errors Today: The Facts, Why We Don't Believe Them, and What We Need to Do." Proceedings of EuSpRIG 2015.

    Source note · peer-reviewed literature

  11. 11. Novis, D.A. et al. "Biochemical Markers of Myocardial Injury Test Turnaround Time," CAP Q-Probes study reported via Hawkins, R.C. "Laboratory Turnaround Time," Clin Biochem Rev / PMC summary.

    Source note · professional society guidance

  12. 12. Centers for Disease Control and Prevention, "Describing Epidemiologic Data," CDC Field Epidemiology Manual.

    Source note · professional society guidance