Excel Total purchase and sold item stock maintain record in excel

I am looking for someone to create an Excel sheet to maintain a record of my total purchase and sold item stock. The items being tracked are products. I require advanced calculations to be included in the sheet. Additionally, I need the sheet to have conditional formatting to help visualize the data. Ideal skills and experience for this job include proficiency in Excel, advanced knowledge of formulas and calculations, and experience with creating visually appealing Excel sheets.