Excel Automation and Dashboard Creation for Medical Taxi Charity
Budget: $30 – $250 CAD
I'm seeking an Excel expert to streamline our medical taxi charity's data processing. Currently, we manually track and report our statistics, which is time-consuming and prone to error. The project involves:
- Creating an "intake" sheet to capture and automatically distribute data about riders, trips, volunteer drivers, and trends to relevant statistical sheets.
- Designing a concise dashboard for our monthly reports, allowing for easy comparison of monthly trends and insights into our operations.
- Ensuring the dashboard includes key metrics such as volunteer driver stats, client characteristics, and trip details.
-Unfortunately the format for data collection has changed somewhat from month to month so there will be some manual corrections to be made to align the data.
Ideal candidates should have extensive experience with Excel, particularly in automating functions and creating dashboards. Understanding of non-profit operations, particularly in the medical transport sector, would be a plus.
- Creating an "intake" sheet to capture and automatically distribute data about riders, trips, volunteer drivers, and trends to relevant statistical sheets.
- Designing a concise dashboard for our monthly reports, allowing for easy comparison of monthly trends and insights into our operations.
- Ensuring the dashboard includes key metrics such as volunteer driver stats, client characteristics, and trip details.
-Unfortunately the format for data collection has changed somewhat from month to month so there will be some manual corrections to be made to align the data.
Ideal candidates should have extensive experience with Excel, particularly in automating functions and creating dashboards. Understanding of non-profit operations, particularly in the medical transport sector, would be a plus.