Excel Job Bid Tracker Creation
Budget: $30 – $250 USD
I'm looking for an Excel expert to create a job bidding tracking spreadsheet for me. My Excel skills are pretty basic, so I need it to be as simple as possible yet functional.
The spreadsheet should be able to filter by multiple criteria simultaneously. The key column categories I need are:
- Project Name
- Company
- Customer
- Consultant
- Date Completed (in mm/dd/yr format)
- Project Total ($)
- Awarded Status (this should be able to contain a 'Yes', 'Unknown', 'No' factor)
The spreadsheet should also allow me to generate specific reports. The most important ones for me are:
- All jobs within a date range
- Jobs for a specific company
- Jobs for a specific employee
- Percentage of jobs won, unknown or lost
The ideal freelancer for this project should have excellent Excel skills and experience in creating tracking spreadsheets. They should also have the ability to simplify complex tasks, as I need this to be user-friendly. Thank you.
The spreadsheet should be able to filter by multiple criteria simultaneously. The key column categories I need are:
- Project Name
- Company
- Customer
- Consultant
- Date Completed (in mm/dd/yr format)
- Project Total ($)
- Awarded Status (this should be able to contain a 'Yes', 'Unknown', 'No' factor)
The spreadsheet should also allow me to generate specific reports. The most important ones for me are:
- All jobs within a date range
- Jobs for a specific company
- Jobs for a specific employee
- Percentage of jobs won, unknown or lost
The ideal freelancer for this project should have excellent Excel skills and experience in creating tracking spreadsheets. They should also have the ability to simplify complex tasks, as I need this to be user-friendly. Thank you.