Using Microsoft Excel spreadsheets you can create an inventory management system to simplify this process and keep everything organized in one place.

How to use the powerful Microsoft Excel VLOOKUP feature that allows you to search for specific data in a column and return a value from a ...

Step-by-step tutorial on creating an analytical dashboard in Excel that updates automatically using a pre-designed template or from scratch.

If you need to reconcile batches of records in Microsoft Excel, this simple VLOOKUP() solution offers a quick and easy way to find records in one batch that are missing from another.

A shared Microsoft 365 Lists list is more valuable if you can use it to update source data in Microsoft Excel.

Christina Termini’s tweet on her do-it-yourself system for managing lab inventory went viral. Here’s how to implement the tool.

I have an Excel workbook with dozens of custom-named worksheets. Is it possible to create a list of those worksheet names in Excel without having to retype them? A. Yes, you can create a list of your ...