Excel Supervisor :: Job3K.com - non-stop freelance jobs roller, work from home

	Excel Supervisor
bid on the project		Share \|
Date posted: 22-02-2012 18:48:16
We're leading italian publishing house and are planning to make large usage of excel dashboards, integrated with our web applications too. We need a supervisor with extensive knowledge of excel 2011, templates, odbc drivers. Excel for mac too. The job can become continuous and will be well rewarded. Great communication and explanation skills are required. Do not applicate if your knowledge of excel is on a more day to day basis (other odesk contractors have underestimated the job). Please include in the application answer to all following 4 questions, candidates that do not include them will be rejected. 1. which is the easiest and most user friendly command to convert a row of data into a column 2. which is in plain english the difference between a excel table (formerly, list) and a excel range 3. which formula would you use to solve following task: you have columns A,B,C,D C contains values that are contained in A, but in different order I want to assign values in D, in such way, that if Cn1=An2, than Dn1=Bn2 4. how do you create a good looking GANNT in excel (attached example output would be appreciated)
Keywords: excel knowledge supervisor values use solve contains columns task formula