Advanced Sales Analysis Excel Sheet
Budget: $30 – $250 NZD
I'm in need of a profound expert in Excel who can design and develop a complex spread sheet that will aid in summing data, computing averages, finding maximum/minimum values and storing customer data. The data to be collated includes individual sales performance metrics and records of products purchased by customers.
Essential to the design will be the creation of interactive drop-downs to make for seamless navigation around the product selection data.
I'm envisioning a simply elegant interface with precise attention to cell borders, shading, font style and size, along with a savvy use of conditional formatting to make the sheet visually appealing and readable.
The Excel sheet needs to function effectively on Windows PCs, Macs, and even on mobile devices (Android/iOS). This feature is key as my team is often on the move and data entries or reviews may have to be done on a mobile device.
Required Skills and Experience:
- Advanced Excel knowledge
- Proven expertise in complex formula construction in Excel
- Dexterity with conditional formatting
- Experience in making sheets compatible across multiple platforms.
Essential to the design will be the creation of interactive drop-downs to make for seamless navigation around the product selection data.
I'm envisioning a simply elegant interface with precise attention to cell borders, shading, font style and size, along with a savvy use of conditional formatting to make the sheet visually appealing and readable.
The Excel sheet needs to function effectively on Windows PCs, Macs, and even on mobile devices (Android/iOS). This feature is key as my team is often on the move and data entries or reviews may have to be done on a mobile device.
Required Skills and Experience:
- Advanced Excel knowledge
- Proven expertise in complex formula construction in Excel
- Dexterity with conditional formatting
- Experience in making sheets compatible across multiple platforms.