Find Jobs
Hire Freelancers

Excel to sort categories like overdue less than 60 days, overdue more than 60 days, warning, and not due. I'd like to understand the formulas used for this. I want to make sure I learn from this, so I won't pay for this work unless I understand it.

$8-15 USD / hour

Në vazhdim
Postuar 6 months ago

$8-15 USD / hour

I am looking for a freelancer to help me with an Excel project. The main goal is to sort categories based on the date range. I want to understand the formulas used for this, so I will only pay for the work if I fully comprehend it. Requirements: - Sort categories into "overdue less than 60 days," "overdue more than 60 days," "warning," and "not due." - The range for the "overdue" category should be less than 60 days. Using pivot tables. - Detailed explanation required for each formula used. - Specific formatting preferences for the Excel sheet are necessary. Ideal Skills and Experience: - Expertise in Excel formulas and functions. - Strong understanding of data sorting and categorization. - Ability to explain complex formulas in a clear and concise manner. - Attention to detail for formatting preferences. If you possess the skills and experience required for this project, please submit your proposal.
ID e Projektit: 37441424

Rreth projektit

45 propozime
Projekt në distancë
Aktive 6 mos ago

Po kërkoni të fitoni para?

Përfitimet e ofertës për Freelancer

Vendosni buxhetin dhe afatin tuaj
Paguhuni për punën tuaj
Përshkruani propozimin tuaj
Është falas të regjistrohesh dhe të bësh oferta për punë
I dhënë për:
Avatari i Përdoruesit
Hi sir, I have good experience in data analyst and advanced excel , and i will close your project withing time frame , Thanks a lot
$8 USD në 1 ditë
0,0 (0 përshtypje)
0,0
0,0
45 profesionistët e pavarur ofrojnë mesatarisht $12 USD/orë oferta për këtë punë
Avatari i Përdoruesit
"""""""""""""""""""""""ADVANCE EXCEL EXPERT""""""""""""""""""""""""" ""Sir, EXCEL is my specialty and I can perform any complex task in EXCEL. I am an EXCEL VBA and CODING, AUTOMATION, TEMPLATE, REPORTS, FORMULA'S, DASHBOARD in EXCEL Advanced Level Expert. This is my field and I can complete this project with added quality. About me I am a Chartered Accountant with more than 7 years of experience including 4 years from the worlds leading Accountancy and auditing firm ""PWC"" and 1 year working at managerial level in Multination company and 2 years as freelancer. I can handle this task very efficiently and you can expect 100% accuracy from me. I am Microsoft Excel, accounting, auditing, financial statements, Form Creation in Excel through VBA and in Google Sheet, QuickBooks, and Sage expert. I have been working as a freelancer from the last 2 years and I have 300+ 5 stars reviews here. I am not new to work. 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. please be my client and get any type of accountancy, Excel, QuickBooks, and auditing-related work with quality, efficiency, and at reduced rates. Note. The price is negotiable. I will be available for any query round the clock even if the project is completed. Regards Arman Kakar "
$15 USD në 40 ditë
4,9 (278 përshtypje)
7,3
7,3
Avatari i Përdoruesit
Hi Hope you are doing good, I can perfectly help you with that in quick turnaround. I am a professional Excel expert holding 7 years of experience in utilizing advance level tools, creating dynamic dashboards and Excel (including VBA and Macro) to perform Data Analysis, Data Visualization, Automation and complex calculations. I will be happy to discuss in detail how I am highly suitable for this project. Kind Regards Arun
$12 USD në 40 ditë
5,0 (40 përshtypje)
5,6
5,6
Avatari i Përdoruesit
Hi there! My name is Mahmoud and I'm a support professional with experience in Excel formulas and functions, data sorting and categorization, formatting preferences for the Excel sheet, creating formulas in Excel, typing in Microsoft Office Word and Adobe Illustrator, editing Photoshop files, creating designs in Canva, generating flow charts in Microsoft Visio, translating texts and designing CV's and writing web search engine optimized medical articles. I understand that you are looking for someone to help you with an Excel project involving categories based on date range. I am confident that I would be the best fit for this job because of my expertise in Excel formulas and functions, strong understanding of data sorting and categorization as well as ability to explain complex formulas in a clear and concise manner. Additionally I pay attention to detail when it comes to formatting preferences for the Excel sheet.
$8 USD në 40 ditë
4,9 (67 përshtypje)
5,1
5,1
Avatari i Përdoruesit
Dear Project Manager and Recruiter, ONLY I5 MINUTES needed to EXPLAIN the functioning of the formula. Understand that you are looking for someone who can not only provide solution but is also good at educating the project manager, how the computation happens. If interested, feel free to reach out. Regards, MM
$15 USD në 40 ditë
5,0 (5 përshtypje)
4,7
4,7
Avatari i Përdoruesit
Hi sir, I have a lot experience I can be the best for your project. I have a experience of more than 06+ years of Data Entry in Government Departments. I will do this project without any mistake. You can trust me. Please give me a chance so that I can show you my skill and tell you about my hard work.
$8 USD në 40 ditë
4,9 (29 përshtypje)
3,9
3,9
Avatari i Përdoruesit
Hello there! My name is Daksh Mahaur and I am an experienced Excel specialist. With 3 years of experience in MIS Data Management/VBA development, I am confident that I can help you with your project. Specifically, I would like to understand the formulas used for sorting categories based on date range. I have the skills necessary to complete this project including expertise in Excel formulas and functions, strong understanding of data sorting and categorization, ability to explain complex formulas in a clear and concise manner and attention to detail for formatting preferences. Additionally, I am available for any questions or concerns regarding the project. If you are interested in my services please feel free to contact me directly so we can discuss further. Thank you for considering me for this position!
$12 USD në 40 ditë
4,5 (23 përshtypje)
4,0
4,0
Avatari i Përdoruesit
Hello there! I am excited to learn more about your project and discuss a potential solution! As someone with experience in Excel formulas and functions, strong understanding of data sorting and categorization, ability to explain complex formulas in a clear and concise manner, and attention to detail for formatting preferences, I believe I am the perfect fit for your requirements. I understand that you are looking for someone to help you with an Excel project – specifically, to sort categories based on the date range. You want to make sure that the range for the "overdue" category is less than 60 days so that you don't run into issues with calendars crossing over each other. Plus, you want the categories to be sorted into "overdue less than 60 days," "overdue more than 60 days," "warning," and "not due." With my expertise in Excel formulas and functions and data processing skills, I am confident that I can deliver an amazing solution! Please let me know if you would like me to discuss further or answer any additional questions please don't hesitate to reach out -
$8 USD në 30 ditë
5,0 (3 përshtypje)
2,7
2,7
Avatari i Përdoruesit
Hello Sir. I have read the job description and I am interested in this job. I have 5 years experience in developing products using Excel, Copy Typing, Word, Data Entry and Email Developer. I fully understand what your requirements are I am very much confident to take up this job. Thanks Best Regards Sourab
$8 USD në 40 ditë
5,0 (2 përshtypje)
2,2
2,2
Avatari i Përdoruesit
Hi there, My name is Iqra and I am an experienced and versatile professional offering expertise in website development, data entry, mathematics and physics. With a proven track record of delivering high-quality results, I am committed to providing efficient and reliable services to meet your specific project needs. I understand you are looking for someone to help you with an Excel project related to sorting categories based on the date range. Specifically, you want to know how to sort categories into overdue less than 60 days, overdue more than 60 days, warning, and not due categories. The range for the overdue category should be less than 60 days. I believe I am the perfect person for this task because of my expertise in Excel formulas and functions as well as strong understanding of data sorting and categorization. Additionally, I have the ability to explain complex formulas in a clear and concise manner so that you can fully understand them before being paid for the work done. My attention to detail for formatting preferences is also required for this job. Best Regards, Iqra Ahmad.
$12 USD në 40 ditë
4,1 (7 përshtypje)
2,3
2,3
Avatari i Përdoruesit
Hi, I have have worked on a similar project to analyse customers for their credit accounts. I’m happy to teach you the formulas Message me so we can chat further!
$12 USD në 40 ditë
5,0 (1 review)
2,0
2,0
Avatari i Përdoruesit
Hello boss... I have experience in processing data in MS Excel, one of which is sorting data which requires formulas and functions. So far, data processing is often carried out in schools and business places. Have plenty of free time to complete this project within the specified time and be able to explain the formulas and functions used. I hope you are willing and able to collaborate with me. Thank you for your attention Abi Insani R
$8 USD në 40 ditë
5,0 (1 review)
1,2
1,2
Avatari i Përdoruesit
Dear Sir, I'm an excel expert. I used to work in ordering and tracking spare parts orders for Audi Vietnam company. Therefore, I am confident that I have enough skill to complete this job in the most accurate way. Please be free to sent message to me to discuss more. Thank you.
$8 USD në 8 ditë
5,0 (3 përshtypje)
1,0
1,0
Avatari i Përdoruesit
Sir, I am a seasoned FREELANCER specializing in Excel, Word, PowerPoint presentations, and a spectrum of data-related tasks such as Data Entry, Copy-Paste operations, Data Processing, Data Extraction, Data Analysis, and Database Development. With a proven track record, I offer a meticulous and efficient approach to meet your specific project requirements. I have 19 years of working experience in several International NGOs like; CARE International, Pathfinder International, PLAN International, Save the Children, Medicine Sans Frontiers (MSF), DAM, OKUP, etc. in Bangladesh as a Database Management and Development Expert. My expertise includes crafting dynamic Excel spreadsheets, creating polished PowerPoint presentations, and ensuring accurate data management through comprehensive Data Entry, Copy-Paste, Data Processing, and Data Extraction techniques. I am committed to delivering precise results, facilitating seamless Data Analysis, and contributing to robust Database Development. I am eager to bring my skills to your project, ensuring excellence in every aspect of data handling. Let's collaborate to achieve your goals effectively. Thank you for considering my proposal.
$8 USD në 40 ditë
4,6 (3 përshtypje)
0,9
0,9
Avatari i Përdoruesit
Good day! I am a data entry expert and can do sort categories like overdue less than 60 days, overdue more than 60 days, warning, and not due. I have read the description and have excellent attention to detail and strong organizational skills. I am a very efficient, workaholic and can do the task on time. I am pretty confident that do this for you super quickly and efficiently open the chat box for further discussion Looking forward to your reply regarding Husnain
$8 USD në 40 ditë
0,0 (0 përshtypje)
0,0
0,0
Avatari i Përdoruesit
Hello Employer, I have gone through the attached files and ready to achieve the goal you have set. Message me so that i share sample of the project. Thanks for your time. Looking for forwards. Regards, Irshad Ali
$12 USD në 40 ditë
0,0 (0 përshtypje)
0,0
0,0
Avatari i Përdoruesit
Hi there, Are you seeking an Excel expert to streamline your data sorting and categorization? I'm here to assist you in achieving your goal of organizing categories based on specific date ranges. With a keen expertise in Excel formulas and functions, I'll employ pivot tables to efficiently categorize your data into "overdue less than 60 days," "overdue more than 60 days," "warning," and "not due." Each formula utilized in this process will be thoroughly explained, ensuring your complete understanding of the methodology. My strong understanding of data sorting and categorization, coupled with attention to detail, will guarantee that your Excel sheet not only meets but exceeds your expectations. I'll adhere to your specific formatting preferences, delivering a polished and professional final product. Please engage in a conversation with me. Let's collaborate to create an organized and visually appealing Excel sheet that aligns perfectly with your requirements. Looking forward to the opportunity to assist you. Regards, Faisal
$12 USD në 40 ditë
0,0 (0 përshtypje)
0,0
0,0
Avatari i Përdoruesit
Hi Jack, I will summarize all the lectures and provide you with clear, concise notes. I've worked on several similar projects compiling presentation slides and lecture notes into a single set of notes. I can deliver quality notes to tight deadlines.
$8 USD në 40 ditë
0,0 (0 përshtypje)
0,0
0,0
Avatari i Përdoruesit
I'm interested.
$10 USD në 40 ditë
0,0 (0 përshtypje)
0,0
0,0
Avatari i Përdoruesit
Hello. I have plenty experience in what you want and most important. I'm very patient and I don't mind explaining whatever number of times until everything is clear.
$9 USD në 40 ditë
0,0 (0 përshtypje)
0,0
0,0
Avatari i Përdoruesit
Hello, my name is Asep Saepul and I am a data entry expert, experienced in data entry, Excel, Microsoft Office and other similar software. As you mentioned that you are looking for someone to help you with an Excel project sorting categories based on the date range and require detailed explanation for each formula used specifically formatting preferences for the Excel sheet I believe I am the perfect fit for this project. I have extensive knowledge of Excel formulas and functions as well as strong understanding of data sorting and categorization which will be necessary for the job. My ability to explain complex formulas in a clear and concise manner along with attention to detail for formatting preferences make me an ideal candidate for this project. Additionally my success rate is 100% and professional workmanship so feel free to reach out if you would like me to discuss further or take a look at my portfolio as a reference for your consideration.
$8 USD në 40 ditë
0,0 (0 përshtypje)
0,0
0,0

Rreth klientit

Flamuri i UNITED STATES
Morris Plains, United States
0,0
0
Mënyra e pagesës u verifikua
Anëtar që nga maj 12, 2023

Verifikimi i klientit

Faleminderit! Ne ju kemi dërguar me email një lidhje për të kërkuar kredinë tuaj falas.
Ndodhi një gabim gjatë dërgimit të email-it tuaj. Ju lutemi provoni përsëri.
Përdorues të regjistruar Punë të postuara
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Po ngarkohet shikimi paraprak
Leja u dha për Geolocation.
Seanca e hyrjes ka skaduar dhe ke dalë. Hyr sërish.