Completed

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

Skills: Excel, Data Entry, Data Processing

See more: 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

About the Employer:
( 1 review ) Al Khobar, Saudi Arabia

Project ID: #31516147

Awarded to:

(42 Reviews)
4.3
(64 Reviews)
5.1

33 freelancers are bidding on average £18 for this job

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 More

£20 GBP in 1 day
(356 Reviews)
7.4
(38 Reviews)
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 More

£20 GBP in 5 days
(22 Reviews)
5.4
PERPETUAL0

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

£20 GBP in 1 day
(78 Reviews)
5.2
(56 Reviews)
5.1
(4 Reviews)
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 in 1 day
(8 Reviews)
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 More

£20 GBP in 2 days
(1 Review)
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 More

£50 GBP in 1 day
(3 Reviews)
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 in 7 days
(0 Reviews)
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 More

£15 GBP in 7 days
(0 Reviews)
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 More

£10 GBP in 7 days
(0 Reviews)
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 in 3 days
(0 Reviews)
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 in 7 days
(0 Reviews)
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 More

£15 GBP in 1 day
(0 Reviews)
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 in 7 days
(0 Reviews)
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 in 2 days
(0 Reviews)
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 in 7 days
(0 Reviews)
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 in 5 days
(0 Reviews)
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 in 7 days
(0 Reviews)
0.0