Excel Customer Management & Pivot
Budget: €6 – €12 EUR
I need a clean, easy-to-maintain workbook set up with two sheets.
Sheet 1 will act as the customer database and must contain these columns in the order shown: Customer Name, Age, Gender, Purchases per Month, Average Spending, Contact Information, Customer ID, and Preferred contact method. Populate it with fifty realistic sample rows so I can see how everything looks and test filters right away.
Sheet 2 should be a Pivot Table that breaks down Average Spending by Gender. Please make sure slicers or straightforward filters are in place so I can quickly explore the data without extra setup.
Simple, accurate formulas and clear formatting are all that’s needed—nothing overly complex. Once finished, I should be able to open the file and immediately sort, filter, and refresh the Pivot without touching anything else.
Sheet 1 will act as the customer database and must contain these columns in the order shown: Customer Name, Age, Gender, Purchases per Month, Average Spending, Contact Information, Customer ID, and Preferred contact method. Populate it with fifty realistic sample rows so I can see how everything looks and test filters right away.
Sheet 2 should be a Pivot Table that breaks down Average Spending by Gender. Please make sure slicers or straightforward filters are in place so I can quickly explore the data without extra setup.
Simple, accurate formulas and clear formatting are all that’s needed—nothing overly complex. Once finished, I should be able to open the file and immediately sort, filter, and refresh the Pivot without touching anything else.
Related categories:
Visual Basic
Data Processing
Data Entry
Excel
Excel Macros
Data Visualization
Data Analysis
Data Management