We have 2 spreadsheets with 5-6 tabs each. We would like to first merge these into a single spreadsheet while preserving all formulas. The data does NOT overlap so there should be no problems with this and the receiving spreadsheet can get new tabs to put the new content in.
The next step is to format the data on all tabs so everything looks consistent. This may mean standardizing on font sizes, types, table header formats, etc.
The next step will be to color every manually input cell on any given tab with blue fore color so its obvious this is manually input. Any cell that directly derives its value from a formula on another tab should be colored green.
The next step is to format everything so it prints optimally. That will mean defining print areas and grouping content logically with page breaks in between so when printed the data looks legible and consistent.
Critical skills we are looking for is a good working knowledge of Excel, careful attention to detail, an ability to make things look pretty, good communication skills and responsive turn around.
The ideal candidate will be a fluent English communicator (written is fine, oral is a bonus). They should also have a feedback score above 4.8, have at least 20 feedbacks and have at least 500+ hours on oDesk already.