Urgent Financial & Sales Data Spreadsheets
Budget: $2 – $8 AUD
I need a skilled Excel guru to create two stand-alone spreadsheets. One is for "Groups" and the other for "Events".
1. Data Type
- Both spreadsheets need to capture and automatically update Financial and Sales data.
2. Data Summarization
- Each spreadsheet should be designed with the capability glean a comprehensive summary featuring total revenue from the embedded data.
3. Automatic population
- The spreadsheets should automatically capture and populate the following, based on formulas: Date, Narration, and Financial Values.
A sample of the "Groups" spreadsheet is attached. It shows the cash book which is used to populate the individual Group worksheets. It also shows the summary of all the worksheets
1. Data Type
- Both spreadsheets need to capture and automatically update Financial and Sales data.
2. Data Summarization
- Each spreadsheet should be designed with the capability glean a comprehensive summary featuring total revenue from the embedded data.
3. Automatic population
- The spreadsheets should automatically capture and populate the following, based on formulas: Date, Narration, and Financial Values.
A sample of the "Groups" spreadsheet is attached. It shows the cash book which is used to populate the individual Group worksheets. It also shows the summary of all the worksheets