7 Tips on how to manage your Excel spreadsheet to ensure you are tracking inventory movement accurately Avoid pitfalls and mistakes with Excel inventory. ... Update immediately. ... Use the cloud. ... Take the time to consolidate data. ... Review your data. ... Audit and review. ... Know when to upgrade.