Find Jobs
Hire Freelancers

Excel - Complex formula and Conditional Formatting for some "Payment schedule"

$30-250 USD

Em Andamento
Publicado há mais de 4 anos

$30-250 USD

Pago na entrega
i need someone to write 2 lines of complex formula on excel for me. Please see the uploaded file, ill leave a comment to say what i want. A. most left table on main sheet: Table summing purchase order from all other sheet by date B. 2nd table: Date when each bills need to be paid, it is also indicated by the legend to the left. Ex: cash on delivery, cash before delivery, 7 days, etc... C. 3rd table is for payment: this will be manually keyed in, D. 4th table will be the balance this will be linked with table 2 and 3. in table 4, i want to have conditional formatting if any carried balance violate the rules to the legend lefts of table 2, it will show red then my finance officer can be alerted For more information, message me directly.
ID do Projeto: 21139359

Sobre o projeto

19 propostas
Projeto remoto
Ativo há 5 anos

Quer ganhar algum dinheiro?

Benefícios de ofertar no Freelancer

Defina seu orçamento e seu prazo
Seja pago pelo seu trabalho
Descreva sua proposta
É grátis para se inscrever e fazer ofertas em trabalhos
19 freelancers estão ofertando em média $122 USD for esse trabalho
Avatar do Usuário
Hello Sir, I am extremely good at excel as it's part of my daily professional life. Working with complex formulas is part of my daily deliverable. I will write the formulas for your process. Kind Regards Gopal
$120 USD em 3 dias
5,0 (39 avaliações)
6,8
6,8
Avatar do Usuário
I can write this complex formula. Thank you.
$50 USD em 1 dia
4,8 (167 avaliações)
6,0
6,0
Avatar do Usuário
Hi, I have opened the attachment. Understood the requirement. This conditional formatting can be done ,. I have years of experience in EXCEL to execute this job
$60 USD em 3 dias
5,0 (23 avaliações)
4,6
4,6
Avatar do Usuário
This is rather easy task. Can be done within a day. I can also help you in keeping the record in more easy form. The design in attached file is complicated. It can be updated with some additional controls
$80 USD em 1 dia
5,0 (10 avaliações)
3,6
3,6
Avatar do Usuário
hi sir I have read your post. sir I have a office with some employee. basically we do outbound calls inbound calls data entry, spread sheet fiill up. etc sir if you give this project to us. we will do very carefully with your budget. you don't need to paid extra money. your success is my happiness.
$222 USD em 7 dias
5,0 (1 avaliação)
1,6
1,6
Avatar do Usuário
Hi, I saw the requirement and the conditional formatting is already in place for the cell value less than or greater than zero. Please let me know what other conditional formatting do you want to have in it. I will do it real quick. I have got a vast experience in excel and can do any kind of job in it quickly. Please have a look into the reviews of my past work to have a confidence in my level of expertise. I have placed the bid of minimum amount, requesting you to please accept my bid and allow me a chance to work for you!! Thanks in advance!! Regards, Keshav
$30 USD em 2 dias
5,0 (4 avaliações)
1,6
1,6
Avatar do Usuário
Hello, I would like to assist you with this task Can you message me so we can have a discussion about the project?
$140 USD em 7 dias
0,0 (0 avaliações)
0,0
0,0
Avatar do Usuário
Greetings I am an Excel expert. I've check the excel file at a glance. I can write the formula for you. Actually this is what I am good at. Please accept my offer. Thanks Amir
$200 USD em 1 dia
0,0 (0 avaliações)
1,0
1,0
Avatar do Usuário
Hello, How are you? I just saw your project description carefully. I am very interested in your project. I have rich experience in PHP, Python, Data Entry, Web Scraping, Excel, Word, VBA. I can help you surely and complete in a short time. I can start your project immediately. I would like to discuss your project with you via chat. Please send your message so that we can discuss your project. thanks.
$70 USD em 1 dia
0,0 (0 avaliações)
0,0
0,0
Avatar do Usuário
Hi sir i can complete your project I have four year experience of excel and I can do what you want please contact me on my whatsup no 0919828020980
$30 USD em 1 dia
0,0 (0 avaliações)
0,0
0,0
Avatar do Usuário
My name Relevant Skills and Experience I have 2 year experience
$155 USD em 3 dias
0,0 (0 avaliações)
0,0
0,0
Avatar do Usuário
Dear Client, my name is Peter and I would be pleased to use my knowledge and creativity to assist you with the formulas in your spreadsheet. My vast background in using/teaching Excel along with Principles of Accounting and Bookkeeping makes me more than capable for this project. My experience includes: * College Instructor for over 20 years. * Analyst on a service desk for a major financial institution through IBM. * Consulting with individuals I've met professionally on their own projects (freelancing). With regards to the attachment you provided, I have studied it intensively for over an hour. I see that each of the 4 tables are set up to hold the purchases and payments on a monthly basis (one month at a time). So for example if CBC made a purchase order on the 1st of the month (table 1), the amount due will be entered in the 8th day in table 2 (cell V20) or AH7 if you count the first day. The payment if made on time will be entered in cell AL20 in table 3. If it is recorded after that, then it is flagged as overdue and table 4 is quite self explanatory. I just wanted you to know that I understand the spreadsheet and I can do it. Please look at my portfolio. My work has always required precision and timelines on my part, and I've always delivered. Because I pay particular attention to accuracy and timeliness and I am motivated by success, I guarantee your satisfaction. Thanks for your consideration. Sincerely, Peter
$140 USD em 4 dias
0,0 (0 avaliações)
0,0
0,0
Avatar do Usuário
Hi, I am proficient in Excel and Word as well as other Microsoft applications. I have data entry experience where I enter all the transactions in the receipts into the system and bookkeeping experience where I prepare financial reports. I know the importance of accuracy, confidentiality, timeliness and proficiency in this job. I will assure to deliver quality output in a timely manner and I can start immediately if hired. You can contact me anytime and would love to discuss the job with you. Looking forward to hear from you. Sincerely, Merlita Mirasol
$166 USD em 4 dias
0,0 (0 avaliações)
0,0
0,0
Avatar do Usuário
I am good in excel.I did many projects in excel. Relevant Skills and Experience Good in MS OFFICE,DATA INTERPRETATION & PROCESSING.
$35 USD em 3 dias
0,0 (0 avaliações)
0,0
0,0
Avatar do Usuário
I am professional web research data entry specialist working from Monday to Sunday. I can also handle large data entry work with short deadline.  I'm very skilful and have estimable experience in using MS Word, MS Excel, and Powerpoint. I am willing to work on any test sample before starting the actual work. If you're interested in giving me a chance to help your data entry and web research project, please feel free to place an order or message me! Thank You
$138 USD em 4 dias
0,0 (0 avaliações)
0,0
0,0

Sobre o cliente

Bandeira do(a) CAMBODIA
Sihanoukville, Cambodia
4,9
12
Método de pagamento verificado
Membro desde out. 5, 2016

Verificação do Cliente

Obrigado! Te enviamos um link por e-mail para que você possa reivindicar seu crédito gratuito.
Algo deu errado ao enviar seu e-mail. Por favor, tente novamente.
Usuários Registrados Total de Trabalhos Publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Carregando pré-visualização
Permissão concedida para Geolocalização.
Sua sessão expirou e você foi desconectado. Por favor, faça login novamente.