Find Jobs
Hire Freelancers

Microsoft Excel formulas and tables

$10-30 USD

In Progress
Posted about 6 years ago

$10-30 USD

Paid on delivery
I need someone who knows how to use excel functions and tables and things like that to fill out the highlighted portions in the sheet labeled “Mo 1” and “Jan 1” by using the data in Sheet 1. Sheet 1 is a list of People with ID numbers in column A with their payment history in columns D and the amount they paid in Column E. In the sheet labeled “Mo 1” I want to see the amount they paid in the first month they made a payment, and then the amount they paid in each subsequent month. For example, if John Smith made their first payment in February ’17 and Bob Smith made their first payment in April ’17, those months would be “Month 1” for those two people. Then in sheet “Jan 1”, same thing except it is broken down by the actual month. I have attached a link to the spreadsheet – if you are interested in the project, please only respond “I have filled out the two people in the sheets you’ve requested” and then fill out sheet “Mo 1” and “Jan 1” for the Identifier or Name of these two people 1) 387187Edwardo Conde and 2) 617171sadagat kamalifard If you do not follow the instructions exactly in the above paragraph, you will not be considered, Thank you
Project ID: 16386319

About the project

24 proposals
Remote project
Active 6 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
24 freelancers are bidding on average $36 USD for this job
User Avatar
Hi, I am good at Excel formulas and vba. I have referred the requirements. I would like to discuss it further to start work on the project. I have filled out the two people in the sheets you’ve requested Please message me in the chat. -Chandra
$30 USD in 0 day
5.0 (1098 reviews)
8.3
8.3
User Avatar
Hello, I’m an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.
$30 USD in 1 day
5.0 (498 reviews)
8.0
8.0
User Avatar
I have filled out the two people in the sheets you’ve requested Dear client, I have sound knowledge in Excel and I have previously carried out a number of projects in excel using macros and formulas. I ensure you will be happy after hiring me. Roy
$30 USD in 1 day
4.9 (487 reviews)
7.4
7.4
User Avatar
Good day, I have filled out the two people in the sheets you’ve requested. I am Luis and I can help you with your Excel project. Please contact me by chat and then we could discuss better your project! Kind regards, Luis Romero
$25 USD in 2 days
5.0 (191 reviews)
6.1
6.1
User Avatar
- Went through the descirption. - Can have the lead amount paid month wise from the beginning month and the other Jan to Dec. - Can be done in a day, I cant attach sheets here so here is the data. 387187 Edwardo Conde - Mo1 sheet, Month1 is $495.00 Jan1 Sheet , January 17 - 0 February 17 - 495 Similarly for 617171 sadagat kamalifard Mo1 Sheet - Month 6 is $495.00 (Others 0) Jan1 sheet - only for Jun 17 - value is $495.00 My Skills: - Have expertise in Excel automation, macros, formulas, calculations, summarising and Graphs. - Extensively the macros/VBA to automate: - Data camparision using formulas, lookups and summaries., - Data validation in a particular, Data consolidation into sheets, comparing, plugging in default values for few cells - Data camparision using formulas, lookups and bringing up summaries., - Mathematical functions, scientific calculations, index, array, formula arrays which are advanced concepts - Have used them. - With summary data plotting graphs, bringing pivot tables - Pl. review my portfolio on recent projects.
$25 USD in 1 day
4.7 (53 reviews)
6.2
6.2
User Avatar
Greeting, I have understood your Microsoft Excel formulas and tables task and can do it with your 100% satisfaction. Please ping me for more discussion. I have more than 5 years of experience in Data Entry, Data Processing, Excel, Microsoft Office, Visual Basic
$50 USD in 1 day
4.8 (14 reviews)
5.3
5.3
User Avatar
I can do this. please review my profile and inbox me. I have good command over MS Excel especially povit table, charts, advance formulas etc. thanks
$25 USD in 1 day
4.9 (34 reviews)
4.7
4.7
User Avatar
hi my name is andrew mikhail i can do this for u in less time and u will get a perfect work i can send u more than 1 sample ;)
$10 USD in 1 day
4.8 (14 reviews)
3.4
3.4
User Avatar
I have filled out the two people in the sheets you’ve requested. Hello. I bid for this project because I'm an Chartered Accountant with lot of experience in MS Excel and VBA programming (macros) I guarantee you an accurate job, full functionality and fast delivery, all this in exchange of a fair rate that is perfectly adjusted to your budget.
$30 USD in 1 day
4.8 (24 reviews)
3.5
3.5
User Avatar
A proposal has not yet been provided
$30 USD in 7 days
5.0 (1 review)
1.0
1.0
User Avatar
Good afternoon! Currently working with Business Intelligence, where my job is to turn data into relevant information and present it in reports and dashboards. I work daily with multiple data sources at the same time to analyze the information, see what are duplicates, if a request is in all systems, then I believe that I am fit for the project. Software used: Builder Dashboards and Reports: Tableau, Power B.I ETL(Data processing) Integration Services and Pentaho Data Integration Databases: Oracle,SQL Server, MySQL Best regards.
$25 USD in 6 days
5.0 (1 review)
0.6
0.6
User Avatar
i will work properly. i have proper knowledge about copy typing , data entry , data processing . I am expert in excel . I have proper knowledge about web searching . I assured that you don't frustrated by me.
$21 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Dear sir, I'm a teacher and I've experience in Data entry, Excel, Data Processing, Internet Research, Web search, Copy Paste etc. I'll do my jobs very fast and accurate. If you have any question ask me plz. I'm ready to work with you so pls reply me with work details. Thank You. :) Best regards Onanna
$25 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Please explain this in the other page of each column and the information you want to place in order to be completed as you want
$277 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$25 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Try me once... If not satisfied.. Will return the money Relevant Skills and Experience I have been working in. Excel in my office for last 2 years and have a vast knowledge in it
$35 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$15 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello, Please attach the correct file. I am an Excel Expert and I can help you right away. You are making reference to a file that is not attached. I am new to freelancer.com but i have more than 15 years of business experience.
$30 USD in 0 day
0.0 (0 reviews)
0.0
0.0
User Avatar
I love doing data entry and I am certain I will do a good work for you and even be considered a long term partner or freelancer Relevant Skills and Experience Well versed with excel and data entry
$25 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I wrote a small program, with which I had already done half of the work. The program already selects the first payment of people to the "Mo 1" sheet. If you are interested in my results, contact me and we will discuss the details of the project. I'm sure I can complete it in one day. I have a lot of experience in programming in MS Excel.
$15 USD in 1 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Los Angeles, United States
4.9
45
Payment method verified
Member since Apr 6, 2012

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.