Excel Spreadsheet Quartering & Cleanup
Budget: $10 – $30 USD
I'm searching for a professional with advanced Excel skills to modify my spreadsheet. The tasks include:
1. Quartering: Split my dataset into four sections (Q1, Q2, Q3, and Q4).
2. Data Removal: Erase specific rows or columns as per provided instructions.
The ideal person for the job is quick, efficient, and meticulous, with a keen eye for detail. The ability to understand and work efficiently with large datasets is a must. Proficiency in Excel is expected and prior experience with similar projects would be highly advantageous.
DETAILED DESCRIPTION OF JOB:
On the attached spreadsheet:
Remove all of the accounts that are exempt from work comp (column R shows who is exempt)
Remove all columns except for Business name, address, city, state zip.
Then I want it broken into 4 separate spreadsheets based on Work Comp x-dates. Q1 (Jan, Feb, March), Q2 (April, May, June), Q3 (July, Aug, Sept), Q4 (Oct, Nov, Dec)
Be careful when looking at expiration dates, the bond expiration date is on there, but I want these categorized by Work Comp expiration dates, please.
1. Quartering: Split my dataset into four sections (Q1, Q2, Q3, and Q4).
2. Data Removal: Erase specific rows or columns as per provided instructions.
The ideal person for the job is quick, efficient, and meticulous, with a keen eye for detail. The ability to understand and work efficiently with large datasets is a must. Proficiency in Excel is expected and prior experience with similar projects would be highly advantageous.
DETAILED DESCRIPTION OF JOB:
On the attached spreadsheet:
Remove all of the accounts that are exempt from work comp (column R shows who is exempt)
Remove all columns except for Business name, address, city, state zip.
Then I want it broken into 4 separate spreadsheets based on Work Comp x-dates. Q1 (Jan, Feb, March), Q2 (April, May, June), Q3 (July, Aug, Sept), Q4 (Oct, Nov, Dec)
Be careful when looking at expiration dates, the bond expiration date is on there, but I want these categorized by Work Comp expiration dates, please.