Excel Formatting help needed

Closed - This job posting has been filled and work has been completed.
Admin Support Other - Admin Support Posted 1 year ago

Hourly Job

Less than 30 hrs/week
Less than 1 week
$$

Intermediate Level

I am looking for a mix of experience and value

Details

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.


About the Client

(4.98) 129 reviews

Bermuda
Devonshire 09:15 AM

204 Jobs Posted
77% Hire Rate, 1 Open Job

Over $50,000 Total Spent
182 Hires, 11 Active

$20.58/hr Avg Hourly Rate Paid
8,686 Hours

Member Since Mar 13, 2009