Suoritettu

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

Taidot: Excel, Tiedonsyöttö, Tietojenkäsittely

Näytä lisää: 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

Tietoa työnantajasta:
( 1 arvostelu ) Al Khobar, Saudi Arabia

Projektin tunnus: #31516147

Myönnetty käyttäjälle:

(42 Arvostelua)
4.3
(64 Arvostelua)
5.1

33 freelanceria on tarjonnut keskimäärin £18 tähän työhön

khushh07

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 Lisää

£20 GBP 1 päivässä
(356 arvostelua)
7.4
(38 arvostelua)
5.6
VBAautomation

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 Lisää

£20 GBP 5 päivässä
(22 arvostelua)
5.4
PERPETUAL0

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

£20 GBP 1 päivässä
(78 arvostelua)
5.2
(56 arvostelua)
5.1
(4 arvostelua)
3.6
ismail80196

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 1 päivässä
(8 arvostelua)
2.8
appnwebsol

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 Lisää

£20 GBP 2 päivässä
(1 arvostelu)
1.7
jamesdobbs11

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 Lisää

£50 GBP 1 päivässä
(3 arvostelua)
1.8
Dataopretor7

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 7 päivässä
(0 arvostelua)
0.0
MariaBeverly23

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 Lisää

£15 GBP 7 päivässä
(0 arvostelua)
0.0
tanubhadwal

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 Lisää

£10 GBP 7 päivässä
(0 arvostelua)
0.0
nitesh270499

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

£10 GBP 3 päivässä
(0 arvostelua)
0.0
parmarsiddhraj12

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 7 päivässä
(0 arvostelua)
0.0
wea34531

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 Lisää

£15 GBP 1 päivässä
(0 arvostelua)
0.0
Surajsinghrkl

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 7 päivässä
(0 arvostelua)
0.0
Zubairaaaaa

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

£15 GBP 2 päivässä
(0 arvostelua)
0.0
mp51gullyse

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 7 päivässä
(0 arvostelua)
0.0
rasingh3001

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 5 päivässä
(0 arvostelua)
0.0
scottMcCall21

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 7 päivässä
(0 arvostelua)
0.0