Excel related You are a Loan Officer at a bank with several branches. You are responsible for managing the main bank and two satellite locations for...

Excel related

You are a Loan Officer at a bank with several branches. You are responsible for managing the main bank and two satellite locations for reporting loan data to the bank manager. You receive monthly loan figures that cover the loan amounts requested, loan amounts approved and the percentage rates that may apply to the loan. You are tasked with creating a report that shows which location has the most loans requests, the amounts of the loans, including any necessary data that would impact a loan approval or rejection.

Explain in detail how you would prepare a weekly summary report for the three locations including:

Part 1: Describe the process needed to place the three locations data into one workbook.

Part 2: Explain how the data from each location would best be summarized in the workbook.

Part 3: Explain how to update the variable loan percentage rates (provided by the bank manager on a weekly basis).

Part 4: Describe how to update the color formats and tab names in the quarterly report.