Find Jobs
Hire Freelancers

organize a couple spreadsheets to 1) pull from automated reports and feed into a more useable format and 2) organize a list of contacts, including characteristics about what their company does, in a format where we can easily update w/ new contacts

$15-25 USD / hour

Disiarkan 3 bulan yang lalu

$15-25 USD / hour

I am looking for a freelancer who can help me with organizing a couple of spreadsheets. The main objectives of this project are to: 1. Translate a system-generated report to a user-friendly report to track client information. Currently we get monthly automated reports from our system that include detailed info, and we would like to be able to pull certain key information from this data to show up in our preferred user-friendly format. We have to update this monthly, so we need a way to just copy/paste/import from our automated reports and then have it feed into our user-friendly format each time we update the data. This is all in Excel. 2. Organize a master, sortable list of contacts for a specific purpose, and have an easy way to periodically update this list with accurate information. We are an insurance firm, and have clients of all different types of businesses that we insure. We need a master spreadsheet that is a reference tool to help identify which insurance companies we should approach for our clients based on our criteria (target appetite, client size, geography, and more). For example we get a potential client who is a construction company generating $50M in revenue in California - we would select these details and get a complete list of potential insurers we should approach that might be able to quote the client's insurance program for us. 3. Include individual contact info for the companies we identify based on the above. Our underwriter contacts change frequently and we need a way to quickly update this info that will feed into the selections we make based on the above. We currently have all the correct current individual contact info for each company, mainly in Outlook contact format, but it is unorganized. We want to have a way to include the individual info in conjunction with the above, as well as have a way to easily update contacts when they change. Ideally, I am looking for a freelancer who has experience with data organization and manipulation in Excel. They should be proficient in creating formulas, sorting, filtering, and creating user-friendly layouts. Attention to detail and accuracy are crucial in this project. If you have previous experience in similar projects and can deliver timely and accurate results, please submit your proposal.
ID Projek: 37492019

Tentang projek

31 cadangan
Projek jarak jauh
Aktif 2 bulan yang lalu

Ingin menjana wang?

Faedah membida di Freelancer

Tetapkan bajet dan garis masa anda
Dapatkan bayaran untuk kerja anda
Tuliskan cadangan anda
Ianya percuma untuk mendaftar dan membida pekerjaan

Tentang klien

United States
Kaedah pembayaran disahkan
Ahli sejak Nov 30, 2023

Pengesahan Klien

Terima kasih! Kami telah menghantar pautan melalui e-mel kepada anda untuk menuntut kredit percuma anda.
Sesuatu telah berlaku semasa menghantar e-mel anda. Sila cuba lagi.
Pengguna Berdaftar Jumlah Pekerjaan Disiarkan
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Memuatkan pratonton
Kebenaran diberikan untuk Geolocation.
Sesi log masuk anda telah luput dan telah dilog keluar. Sila log masuk sekali lagi.