Using VlookUps and Pivots in Excel. Dealing with supply chain customer queries. Input weekly sales orders from the existing customer base via telephone, email,…