In this report, I employed Microsoft Excel, a widely used spreadsheet software, to create a comprehensive list of 20 customers' mortgage information. The file, titled "Customer Mortgage List", is a meticulously crafted table that showcases the customers' essential details, including customer ID, gender, location, position, education, salary, and mortgage outstanding. The Excel file is organized into columns and rows, allowing for easy navigation and analysis of the data. I utilized Excel's various features to ensure the accuracy and precision of the data, including data validation to ensure correct formatting of dates and numbers, and conditional formatting to highlight potential errors or anomalies. The file also includes formulas to calculate the total mortgage outstanding for each customer, as well as percentages to display the percentage of mortgage outstanding compared to the customer's salary. Additionally, I used Excel's built-in functions to sort and filter the data, making it simple to identify trends and patterns in the information. Overall, the use of Excel enabled me to efficiently collect, organize, and analyze the customer mortgage data, providing a comprehensive report that is both informative and easy to understand.