Our coach assigned us a task to create a mortgage record using a spreadsheet. This exercise helped us understand how to organize and calculate key mortgage details such as loan amount, interest rate, loan term, monthly payments, and collateral information. By inputting data into the sheet, we learned how mortgage payments are structured and how different factors affect the overall loan. This practical task improved our skills in using spreadsheets for financial calculations and data management, giving us hands-on experience with mortgage concepts in a clear and organized format.

As part of a trial task while applying for a job, I was assigned to research the first five guests of The Tim Ferriss Show. My main responsibilities included identifying each guest’s episode number, providing a direct link to the episode, noting the episode release date, and finding their official social media profiles (such as LinkedIn, Twitter, or Instagram). This task aimed to assess my research skills, attention to detail, and ability to gather and organize relevant online information accurately.

I created this sales dataset as a learning tool to better understand how sales data is structured and analyzed. It includes key details such as the date of sale, product name, product category, quantity sold, unit price, total sales, customer name, and region. By working with this dataset, I aim to improve my skills in data organization, analysis, and reporting particularly in identifying sales trends, tracking performance, and generating insights that support business decisions.

This lead scraping task involves researching and collecting key information about company CEOs. The required details include the CEO’s full name, email address (if available), social media profile links (such as LinkedIn, Instagram, and Facebook), the name of the company they lead, and the company’s address or location. The data should be gathered from reliable sources like company websites, LinkedIn, or verified business directories, and organized clearly in an Excel or Google Sheet. This task is designed to assess your web research skills, attention to detail, and ability to compile high-quality leads for potential outreach.

This trial task involves working with an Excel sheet that includes columns for Name, Age, Department, Salary, and Years of Experience. The main objectives are to calculate the total average salary of all employees and to determine the average salary specifically for those in the HR department. This task assesses basic data analysis skills in Excel and the ability to filter and compute values based on department specific criteria.