You have joined Williamson Finance, a renowned financial firm in South Africa, as a business analyst. Every week, it collects data about customer payments in Excel format from its various branches throughout the country Company's head office has a master Excel file containing detailed information of every customer. Here main challenge for the company is that the payment files contain customer number against each record, but the weekly payment report requires customer details such as name, gender, age, address, phone etc that are available only in the master file. Now you have been asked to perform two tasks - search the customer details from master file and print them on the payment by matching the customer number and combine payment data coming from different files in a single file. What different techniques in Excel will you use to create such a weekly report? Elaborate in detail