Daves Excel project

Hi I work in the Training Department, for a large Oil & Gas company in Saudi Arabia which has (approximately 5000 personnel) . For each person there are approximately 16- 20 courses depending on position but we do not have an efficient stand alone system to manage this and use Excel.

We keep a master schedule stating:

Date of courses

Local ID number & Houston ID number

Employee Name

Position Course Title course Start & finish Dates

And attendance (Attended / Cancelled / No show)

On a separate sheet I have place all the courses with 1st column Date of month (1-31)/ 2ND Column No. of Employees,/ 3rd No. of Nationals /4 Column No. of Expat & TCN's / 5 Column No. Cancelled 6 Column Number of No Shows.

So I want get these numbers from this Sheet and auto populate into the course sheets for each month.

To identify the Nationals from the Expats and TCN's can be done by identifying the first 3 numbers of their Local numbers all National ID number begin with 900 whereas every one else have a different first 3 number prefix.

I have attached a small portion of our master file and also a small sample of the course sheet that need to auto fill

I need the formulas shown also so that I can add to this as and when required

Habilidades: Excel, Processamento de Dados, Processamento de dados

Veja mais: simple excel project grade, excel project manage template web design, excel project task list, visual studio excel project, excel project help needed, project based work websites, excel project macro samples, peachtree excel project, freelance access excel project work, excel vba project online work 2009, excel project work board, large data file excel project, excel add calculate work hours project, excel project based work, microsoft excel project work, offline excel project work, excel project work for students, data entry & office work training for job in excel in hindi

Acerca do Empregador:
( 1 comentário ) Al Khobar, Saudi Arabia

ID do Projeto: #31516147

Concedido a:

(42 Comentários)
(64 Comentários)

33 freelancers estão ofertando em média £18 nesse trabalho


Hello Greetings to you!! I am an Excel (Macro)/Visual Basic expert and interested to work with your project. I have checked your requirements and that makes complete sense to me. I assure you of a high-quality job. Ple Mais

£20 GBP em 1 dia
(356 Comentários)
(38 Comentários)

Hi, I hope you are doing well I am a professional on SQL server, VBA programming, MS access and also in power BI. I am doing this job since 2010.I can handle your project in a very prudent manner. As per your requirem Mais

£20 GBP in 5 dias
(22 Comentários)

Hello there I can make this formula for the entire sheet Regards Ilyas

£20 GBP em 1 dia
(78 Comentários)
(56 Comentários)
(4 Comentários)

I have read your project description and think I can help. Let’s chat in more detail about your project needs. Waiting for your good response. Let me know the more details the project.®

£10 GBP em 1 dia
(8 Comentários)

Hello Greetings I can start the work right now I am an expert in Web Scraping, Data Mining, Data Extraction using Python , Beautiful-soup, Selenium and I am really interested in your project. I am waiting to your q Mais

£20 GBP in 2 dias
(1 Comentário)

Hi Dear! I already check your description with carefully and very interesting your project. Also I have a development experience of project like your project. Specially I have more than 10 years of experience in softwa Mais

£50 GBP em 1 dia
(3 Comentários)

Hii iam certified person in this work . this work finished on time with out mistakes . i try to best for you and satisfied you and your organizatipon . in this work i invest my all tyme . thank you!

£10 GBP in 7 dias
(0 Comentários)

I have just finished with a project, and do not have any more in the pipeline at the moment. If I am hired for this project, I will be able to give it my full attention and will deliver on time. Apart from this, I poss Mais

£15 GBP in 7 dias
(0 Comentários)

Hope you are doing good. we are expert in data entry and excel team of 4 people. To do this work will be mine pleasure, As I am always volunteer to do work for my client within timeframe and provide you work accuracy Mais

£10 GBP in 7 dias
(0 Comentários)

I am a good Data Entry operator. I have 5 years of experience. So I will do it with 100% accuracy. Thanks

£10 GBP in 3 dias
(0 Comentários)

I am Data entry [login to view URL] typing speed 30ws.i enjoy Data fill [login to view URL] accuracy is 80%.I have a one opportunity I will done it.

£15 GBP in 7 dias
(0 Comentários)

Hi! I am fazian Mustafa. I will do fast work in Data Entry and Data Scraping. I am expert in data entry and Data Scraping. Please give me a one chance .fast delivery the work file.I am the Right person for you. I would Mais

£15 GBP em 1 dia
(0 Comentários)

Let me introduce myself. I am suraj.I believe in customer satisfaction, quality work and i'll complete the given task on time

£15 GBP in 7 dias
(0 Comentários)

I read job description and I can do your project. I can even work on urgent basis and complete your project soon..

£15 GBP in 2 dias
(0 Comentários)

i am data entry opreator I am doing tally work since 6 months. Earlier I have worked in Excel which I have good experience

£15 GBP in 7 dias
(0 Comentários)

Hi, I am Raman Deep Singh from Rajasthan, India. I am a graduate. I am good experience a MS Excel and word and I have good skill a data entry...and I have fast typing experience...

£13 GBP in 5 dias
(0 Comentários)

hi i have the potential to organise this work as you've stated I have vast experience in Microsoft packages and this assures you that I'll tackle this in the time frame provided looking forward to working with you

£15 GBP in 7 dias
(0 Comentários)