Laboratory Data Management and Excel Training
The Laboratory Data Management and Excel Training hosted by the Centers for Disease Control and Prevention (CDC) and the Association of Public Health Laboratories (APHL) was a four-day virtual training held in September 2024. The videos include lectures on laboratory data management, accessioning, data privacy, confidentiality, and biosecurity as well as topics on Microsoft Excel including data cleaning, formulas and functions, and tables and graphs.
This video highlights the characteristics and purpose of Laboratory Data Management. The course explains the phases of data life cycle in the context of laboratory workflow and benefits of software solutions for laboratory data management or Laboratory Information Management System (LIMS).
This video highlights the importance of organizing and cleaning data in Excel. It covers various methods for identifying and correcting errors, as well as the tools available through Excel that can help automate these tasks and save time.
This video explores the various formulas and functions in Excel that can be used to automate processes and reduce errors in data entry. This video provides examples of the eight most commonly used formulas in Excel.
This video describes the steps to accessioning and good accessioning practices. It covers best practices for adequate data management throughout the sample lifecycle.
This video introduces participants to tables and graphs in Excel. It explains what a PivotTable is and how it can be utilized to summarize data. It also covers the three most commonly used charts and graphs, describing how to use each one to visualize data.
This video highlights the importance of data security and privacy in laboratory data management. It includes the importance of data protection and how to ensure patient confidentiality throughout the laboratory sample collection and testing life cycle.
This video demonstrates how to use the various Excel skills discussed in the training videos. It includes examples of cleaning data, functions and formulas, and making different types of graphs and tables.