Enroll in our Data Processing in Excel course for Scientists for only $99!
Exact Mass Calculator in Excel
The monoisotopic mass, also known as the exact mass of a molecule, is determined by adding the exact masses of the most abundant isotopes of its component elements.
USP <905> Uniformity of Dosage Units Explained (+ Excel Calculator Templates)
Learn how USP <905> uniformity of dosage testing works, including content uniformity and weight caration methods, acceptance value calculations, and Excel templates for pharmaceutical analysis
How to Calculate USP <905> Content Uniformity in Excel
Step-by-step guide for calculating USP <905> content uniformity and acceptance value (AV) in Excel with downloadable spreadsheet template
USP <905> Weight Variation Testing Explained (+ Excel Calculator Template)
Learn how USP <905> weight variation testing is performed in pharmaceutical analysis, including acceptance criteria, calculations, and downloadable calculator template.
Tablet Scoring Guidance in Pharmaceuticals: FDA and USP Considerations
Understand tablet scoring requirements for pharmaceutical products, including regulatory guidance, dissolution considerations, content uniformity, and functional score evaluation.
Evaluating Tablet Splitability by Calculating Loss of Mass (+ Excel calculator)
Learn how to evaluate tablet splitability by calculating loss of mass. Includes Excel calculator.
USP <1216> Tablet Friability Testing Explained (+ Excel Calculator Template)
Understand USP <1216> tablet friability testing including loss of mass calculations, aceptance criteria. Includes automated loss of mass calculator.
Leveraging Ion Ratio for Analyte Confirmation in Mass Spectrometry
Analysis of chemical compounds by liquid chromatography-tandem mass spectrometry (LC-MS/MS) in complex samples presents unique challenges that should be considered.
How to transform Empower raw data into an organized Excel table in 2 minutes
Raw data from Empower typically contains a ton of information that we do not need and extracting the important data can be a time-consuming task.
How to use the F1 and F2 Dissolution Calculator Excel Tool
Learn how to use the F1 & F2 dissolution calculator to compare similarity factors in drug release profiles. Simple guide on how to use the Excel tool.
Exploring the Power of Pivot Tables: Three Essential Features for Enhancing Data Analysis
In this article, we'll explore three powerful features within pivot tables that can help enhance your data analysis process.
Microsoft Excel Keyboard Shortcuts for Scientists
Microsoft Excel includes lots of keyboard shortcuts that can make the process go faster, allowing you to move from one task to the next quickly and efficiently.
How to Calculate Void Volume in Liquid Chromatography (Simple Formula + Excel Calculator)
Learn how to calculate void volume in liquid chromatography using a simple formula and excel calculator. Step-by-step guide for analytical chemists and QC labs
Dissolution Profile Comparison: F1 and F2 Calculation in Excel
Learn how to calculate dissolution profile similarity factors f1 and f2 using Excel. Includes formulas, examples, and downloadable calculator template
How to Adjust Column Widths Automatically
Learn how to quickly and easily adjust the width of your columns in Excel so that you can view your data perfectly. No more manual resizing!
How to Create a Dropdown List
Creating a dropdown list in Microsoft Excel can be a useful tool for scientists to efficiently manage and organize their data.
How to Alphabetize Your Data in Excel
Sorting data in Excel is a fundamental operation that helps scientists arrange their data in a specific order, making it easier to analyze and draw insights.
How to Create a Pivot Table in Excel in under 2 minutes!
Scientists often have to work with large datasets, and pivot tables can help make sense of this data by aggregating and transforming it into meaningful information.
How to Remove Duplicates From Your Data
Removing duplicates in Excel is a key task for scientists. This can be especially important when working with large datasets.
How to Embed an Excel File within a Word Document
Embedding an Excel file in Word allows you to include spreadsheet data directly within a Word document, making it easy to combine text and data in a single document.