Excelling With Excel: Analytical Method Validation Using LOD and LOQ
Don’t be fooled by bad data. Make sure your results are reliable with this quick guide to determining LOQ and LOD in Excel.
Join Us
Sign up for our feature-packed newsletter today to ensure you get the latest expert help and advice to level up your lab work.
Search below to delve into the Bitesize Bio archive. Here, you’ll find over two decades of the best articles, live events, podcasts, and resources, created by real experts and passionate mentors, to help you improve as a bioscientist. Whether you’re looking to learn something new or dig deep into a topic, you’ll find trustworthy, human-crafted content that’s ready to inspire and guide you.
Don’t be fooled by bad data. Make sure your results are reliable with this quick guide to determining LOQ and LOD in Excel.
This article explains how to use Microsoft Excel to simplify qPCR Plate Design, reducing errors and confusion when setting up multi-well plates. By creating detailed plate maps and using Excel’s speak upon enter feature, researchers can accurately add variable RNA volumes and reagents, improving efficiency and confidence in complex qPCR workflows.
Last time we brushed up on cell referencing and constructing formulae to use Excel for some basic and some slightly more advanced calculations. This time we’re going to move on to using some built-in Excel functions and go through how to apply all that we’ve done so far to a worked example that is relevant…
Microsoft Excel can be a really powerful, useful tool for certain kinds of data processing and record keeping, and the chances are you probably don’t even know how to use half of the functions it comes with! That’s OK, personally, I find Excel a bit less user-friendly than Word, but also it’s a programme I…

The eBook with top tips from our Researcher community.