Đã hoàn thành

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

Kĩ năng: Excel, Nhập liệu, Xử lí dữ liệu

Xem nhiều hơn: 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

Về Bên Thuê:
( 1 Nhận xét ) Al Khobar, Saudi Arabia

ID dự án: #31516147

Được trao cho:

(42 Đánh Giá)
4.3
(64 Đánh Giá)
5.1

33 freelancer chào giá trung bình£18 cho công việc này

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 Thêm

£20 GBP trong 1 ngày
(356 Nhận xét)
7.4
(38 Nhận xét)
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 Thêm

£20 GBP trong 5 ngày
(22 Nhận xét)
5.4
PERPETUAL0

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

£20 GBP trong 1 ngày
(78 Nhận xét)
5.2
(56 Nhận xét)
5.1
(4 Nhận xét)
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 trong 1 ngày
(8 Nhận xét)
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 Thêm

£20 GBP trong 2 ngày
(1 Nhận xét)
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 Thêm

£50 GBP trong 1 ngày
(3 Nhận xét)
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 trong 7 ngày
(0 Nhận xét)
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 Thêm

£15 GBP trong 7 ngày
(0 Nhận xét)
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 Thêm

£10 GBP trong 7 ngày
(0 Nhận xét)
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 trong 3 ngày
(0 Nhận xét)
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 trong 7 ngày
(0 Nhận xét)
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 Thêm

£15 GBP trong 1 ngày
(0 Nhận xét)
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 trong 7 ngày
(0 Nhận xét)
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 trong 2 ngày
(0 Nhận xét)
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 trong 7 ngày
(0 Nhận xét)
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 trong 5 ngày
(0 Nhận xét)
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 trong 7 ngày
(0 Nhận xét)
0.0