Find Jobs
Hire Freelancers

excel pivot help

$8-15 USD / hour

Teljesítve
Kiadva ekkor: körülbelül 2 évvel ezelőtt

$8-15 USD / hour

i need help in some raw data i have on excel that includes huge data amount of attendance sheet and i want to make a pivot table in order to filter out people who have recorded absence after the last day they attended. i want to check each employee when was the last time they came to work... and then check if they were absent after their last time they came to work, if they were, put their names on a list and clean all their data from the big all data sheet. so for example i shahd.. the last time i went to work is 1st of january, but then i was absent after that, day.. if i was absent , then i want my data to be cleaned out of the all data ... and have my name on a seperate [login to view URL] shahd's record for example is reported, absent reported absent absent .... then it will become reported absent reported Only... so the last 2 are removed because i was absent after the last time i reported
Projektazonosító: 32771375

A projektről

38 ajánlat
Távolról teljesíthető projekt
Aktiválva: 2 évvel ezelőtt

Szeretne pénzt keresni?

A Freelancer oldalán történő árajánlatadás előnyei

Határozzon meg költségvetést és időkeretet
Kapja meg fizetését a munkáért
Vázolja ajánlatát
Ingyen regisztrálhat és adhat árajánlatot munkákra
Neki odaítélve:
Felhasználó avatár
Hi There, Hope you are doing well, Interested in your posting as I’m used to performing such projects (See Profile). I’m ready to have a look and start right away if you give me a chance. Please share data/file in order to run a test for you. I would like to assist you at a reasonable price along with high-quality work delivered on time. Looking to hearing from you soon, Thanks & Regards, Leo,
$70 USD 7 napon belül
4,9 (25 értékelés)
3,8
3,8
38 szabadúszó adott átlagosan $13 USD/óra összegű árajánlatot erre a munkára
Felhasználó avatár
Hello, I will be glad to assist you with that. I am an advance level Excel expert holding years of experience in performing Data Analytics, Automation and various other calculations and analysis using VBA, Macro, Power Queries, Pivot Tables and Excel based formulas. Lets discuss your project in detail and how I am highly suitable for this.
$12 USD 2 napon belül
4,8 (163 értékelés)
7,0
7,0
Felhasználó avatár
"⭐⭐⭐⭐⭐⭐I am an engineer and I read the details accurately.⭐⭐⭐⭐⭐⭐ I am ready to start now. Just if u have more details or questions u can ask me in chat. Check my projects that I have finished related to engineering in my profile. Let us discuss in chat. "
$12 USD 40 napon belül
5,0 (69 értékelés)
5,6
5,6
Felhasználó avatár
Hi there, I can assist you in “to make a pivot table in order to filter out people who have recorded 3 absences after their last reported attendance and list out their names” the best way & according to your project need. I am an expert and professional in all type data entry, MS excel custom formulas, filtering, pivot tables, charts, sorting, data scrapping from websites, data extraction for multiple excel sheets and consolidating in a central sheet, User forms, Shapes variation etc. I have also handled various excel tasks. It includes the creation of formulas using arrays, Pivot table creation, Creation of graphs, filtering, removing duplicates, it includes extracting information from text files, websites, transferring info in to excel, Data analysis etc. For more info. You can see my profile before awarding me your project. https://www.freelancer.com/u/yadavexpert53 With Regards, Mohit
$8 USD 40 napon belül
4,9 (66 értékelés)
5,2
5,2
Felhasználó avatár
Hi, I can get the required pivot ready for you in next 4-5 hours..I can additionally provide you some graphs so you can get better visualization of data..thanks!!
$10 USD 5 napon belül
5,0 (18 értékelés)
5,2
5,2
Felhasználó avatár
Hi - Please reach out to me on a chat so I can help you quickly with this. I am online now. I can run a sample also if you can share a sample of the attendance sheet. Regards Vishy
$12 USD 2 napon belül
5,0 (20 értékelés)
4,2
4,2
Felhasználó avatár
Hi, I can build you the pivot table to find out people who have 3 or more absences since their last reported date in 15mins maximum. This is an easy task for me as I am an Excel professional with years of experience working on such projects. You can see my profile for my past works and reviews. Happy to discuss more over chat. Cheers, Suresh.
$8 USD 40 napon belül
5,0 (20 értékelés)
3,9
3,9
Felhasználó avatár
"Hello Sir, I am an advance level EXCEL EXPERT and all Excel related work. This task is very easy ,I will complete this task with 100 % Accuracy. I have completed similar projects with five stars from client. About me I am Chartered Accountant with more than 4 years of experience from worlds leading Accountancy and auditing firm ""PWC"". I can handle this task very efficiently and you can expects 100% accuracy from me. I am Microsoft Excel, accounting, auditing, Form Creation in Excel through VBA and in Google Sheet and QuickBooks expert. I know how to meet strict deadlines without compromising the quality of the work. I will also be available for any query after the job is done as I am building my clients. Regards Spogmai Kakar "
$12 USD 40 napon belül
4,9 (23 értékelés)
3,9
3,9
Felhasználó avatár
Hi, I think I can help you in this project. I have 20 years in the development of Ms. Excel spreadsheets, including pivot tables, graphs, formulas, macros and VBA programming. Just tell me what you need and I'll be glad to help. Best regards, José M.
$14 USD 40 napon belül
5,0 (2 értékelés)
3,0
3,0
Felhasználó avatár
I can perfectly help you with that. I am a professional Data Analyst and Excel expert holding years of experience in utilizing advance level tools and functions of Excel (including VBA and Macro) to perform Data Analysis, Data Visualization, Financial Analysis, Financial Modeling and various types of Analysis, Automation and complex calculations. I will be happy to discuss in detail how I am highly suitable for this project.
$10 USD 40 napon belül
5,0 (5 értékelés)
2,6
2,6
Felhasználó avatár
Hello dear, Hope you are doing well. Please contact that i can assist you and complete your work for excel pivot table, cannot bore you with long proposal shortly come to chat and get your work done its very simple. If you have any query feel free to contact. See you in chat. Thanks Best regards Muhammad adil
$10 USD 10 napon belül
5,0 (3 értékelés)
1,3
1,3
Felhasználó avatár
Hello, I have experience in payroll and Time attendance data cleaning, organizing, and analysis. I will deliver on the project. With an extensive 6 years of experience of demonstrated competency in data validation, reconciliation, auditing, for purposes and situations, I will deliver high-quality work that meets your requirements. Advanced Excel, Macros, VBA, R Programming, Python, and many more are some of the tools I will use to deliver exceptionally. I will make sure to complete work on time. We might set aside some time to have a more in-depth discussion. I am ready to start right away. Thanks!
$8 USD 40 napon belül
5,0 (1 értékelés)
1,0
1,0
Felhasználó avatár
I worked as IT in some companies. I also have experience in creating websites and some programming languages. I also have experience in databases, so I can learn quickly and adapt to the job.
$12 USD 40 napon belül
0,0 (0 értékelés)
0,0
0,0
Felhasználó avatár
because sir I am Certified data entry operator and I have also good typing speed. IF U giving me opportunity i won't let you down.
$12 USD 40 napon belül
0,0 (0 értékelés)
0,0
0,0
Felhasználó avatár
Hello I know use excel, pivot tables, macros, filters, etc. I'm available and I would like help you.
$15 USD 10 napon belül
0,0 (0 értékelés)
0,0
0,0
Felhasználó avatár
I KNOW VERY WELL THE PIVOT FUNCTION.I USE IT A LOT AND FOR SEVERAL TYPES OF DATAS.I AM EXPERIENCED IN EXCEL
$8 USD 40 napon belül
0,0 (0 értékelés)
0,0
0,0
Felhasználó avatár
Hello prospective client from Qatar, I have read through your project and I am confident I can help you work on it. I have vast knowledge using excel spreadsheet. I am a dedicated freelancer. Kindly consider me to help you on your project and also to prove my competencei look forward to working with you. Warm regards.
$12 USD 40 napon belül
5,0 (2 értékelés)
0,0
0,0
Felhasználó avatár
I am a very diligent person and I strived to get my work done in one sitting efficiently. Hope you can consider me.
$12 USD 40 napon belül
0,0 (0 értékelés)
0,0
0,0
Felhasználó avatár
Te propondré la mejor solución automática para lo que necesitas... La prueba está en que, si eres capaz de pensar lo que necesitas, entonces seguro ya lo sé hacer. ¿El Idioma?, No te preocupes, atenderé tus solicitudes a base de Traducción.
$8 USD 40 napon belül
0,0 (0 értékelés)
0,0
0,0
Felhasználó avatár
Hey I'm new in freelance work but I'm work oriented ,dedicated guy .if you give me opportunity you will never regret
$10 USD 40 napon belül
0,0 (0 értékelés)
0,0
0,0
Felhasználó avatár
I'm interest your proposal. I have an experience in this field last 30 years and My experience is good in Microsoft Office Word, Excel, Copy past, Typing work, Data Entry & PowerPoint. I have read your requirement. I am ok with your project. I am very good at word. I can type very fast. I typing rate is 40-50wph. I will do the work best I will do the work as early as possible. I can cover PDF files into word. I have sufficient experience in copy typing and data entry using Microsoft Word. I can send you a sample of my work for scanned and the converted word files. I will follow up on your instructions to provide you with highly accurate work. We will need moor clarifications about the number of pages and the time you need your project to be finished. Looking forward to accepting me to work on your project. Thanks! Samiran Das, E-mail : samirands7 at the rate gmail dot com, City/State : Chattogram, Country : Bangladesh
$10 USD 40 napon belül
0,0 (0 értékelés)
0,0
0,0

Az ügyfélről

QATAR zászlója
Qatar
5,0
2
Fizetési mód hitelesítve
Tagság kezdete: aug. 3, 2018

Ügyfél-hitelesítés

További munkák ettől az ügyféltől

Excel Pivot/ Macro
$10-30 USD
Köszönjük! E-mailben elküldtük a linket, melyen átveheti ajándék egyenlegét.
E-mailje elküldése során valami hiba történt. Kérjük, próbálja újra.
Regisztrált Felhasználók Összes Közzétett Munka
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Előnézet betöltése
Hozzáférést adott a helymeghatározáshoz.
Belépési munkamenete lejárt, és kijelentkeztettük. Kérjük, lépjen be újra.