To manage product inventory in Excel, create a spreadsheet with columns for item name, SKU, quantity, price, and supplier details, then regularly update it to track stock levels.