Excel Formatting help needed

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


Less than 30 hrs/week
Less than 1 week

Intermediate Level

I am looking for a mix of experience and value


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.99) 135 reviews

Devonshire 05:08 AM

217 Jobs Posted
78% Hire Rate, 1 Open Job

Over $50,000 Total Spent
201 Hires, 16 Active

$25.16/hr Avg Hourly Rate Paid
16,072 Hours

Member Since Mar 13, 2009