Extend spreadsheet to handle 2014 and beyond

Concluído Postado Aug 26, 2013 Pago na entrega
Concluído Pago na entrega

Excel Experts ONLY. Payment will only occur after successful completion and verification that project is functional and 100% correct.

Attached is a sample of an employee time management spreadsheet. Note there are many hidden columns in this version. This project is to improve this spreadsheet and allow it to be more flexible and extendable.

1) Need to use "OFFSET" function in Excel to allow this spreadsheet to extend all reports into 2014 and 2015. Currently, the spreadsheet has some complicated cell references that prevent easy extension of each Team, Entire Company, and Individual report.

2) Need to add NEW column to source dataset called (Manager) where we can list who each Employee's manager.

3) Create a single Team report that has dropdown to show manager. This will allow reports Team2, Team3..etc.. to be removed.

Simple project. Should take a true Excel wizard just a hour or two to complete.

Excel

ID do Projeto: #4866131

Sobre o projeto

13 propostas Projeto remoto Ativo em Aug 28, 2013

Concedido a:

MSExcelPro

I'm a really advanced Excel user. I can do that for you really fast. Really low rate because I'm new in this site.

$50 USD em 3 dias
(0 Comentários)
0.0

13 freelancers estão ofertando em média $88 nesse trabalho

best4best

I am an Excel expert. I can Extend the spreadsheet to handle 2014 and 2015.

$88 USD in 2 dias
(58 Comentários)
5.0
hegemon88

Excel is my middle name

$87 USD in 3 dias
(3 Comentários)
3.2
hbxfnzwpf

I am very proficient in dealing with word, ppt, access, excel files, and good at VBA programming, please let expert do it.

$69 USD in 2 dias
(1 Comentário)
2.2
alexk7384

I think I got it right. Please check my private message.

$80 USD em 1 dia
(1 Comentário)
1.6
NhatAnhIT

Please check my pm !

$77 USD in 2 dias
(1 Comentário)
1.5
CoDeep

Hi, I can do this.

$70 USD em 1 dia
(1 Comentário)
1.0
frankdipasquale7

Excel expert and financial analyst background.

$100 USD in 2 dias
(0 Comentários)
0.0
sweetoasis

Hi, I'm interesting this. Thanks.

$155 USD in 3 dias
(0 Comentários)
0.0
ruboarm

I'm interested in your project and would like to do it for you. Please read PM

$70 USD em 1 dia
(0 Comentários)
0.0
kininfo2012

I will working more that 5 hours in Excel , so most probably i ill finish your project with accurate data .

$35 USD em 1 dia
(0 Comentários)
0.0
rollison

Respected Sir, I will always provide 100% quality of work with accuracy , Please check your Inbox.

$155 USD in 3 dias
(0 Comentários)
0.0
basheerpassela

We have the necessary expertise on advance Excell and looking forward to work with you

$70 USD in 2 dias
(0 Comentários)
0.0
zExcel

Interesting project. I can help you create a more functional and automated model which will allow you to extend the tables to any future year, as well as make the teams linked to their employees so you won't have to en Mais

$133 USD em 1 dia
(0 Comentários)
0.0