With over two decades of experience in software development, data analysis, and specific expertise in inventory management, I am confident that I can deliver the sophisticated Excel-based solution you're seeking. My distinguished career with UNO and WHO has granted me exclusive insights into database administration primarily using MS SQL Server and MySQL. Moreover, I'm adept at creating 'manual entry' systems, which align perfectly with one of your requirements.
Harnessing my skills in ASP.NET Core/MVC and C#, I can ensure a smooth tracking of product quantities, including batch numbers and expiry dates. Interval updates, whether manual entry or bar code scanning won't be an issue as well. My meticulous attention to detail will mean zero errors when inputting crucial product information such as name, SKU/Part number.
Lastly, given my familiarity with diverse tools such as Jquery, HTML5, DevExpress along with my adaptable nature due to Wordpress/WooCommerce experience, I'm confident in not only meeting but exceeding your expectations. I look forward to the opportunity to make your inventory management system more efficient and seamless than ever before.