Lengkap

Microsoft Excel formulas and tables

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

Kemahiran: Pemasukan Data, Pemprosesan Data, Excel, Microsoft Office, Visual Basic

Lihat lagi: www microsoft excel formulas, microsoft excel formulas, microsoft excel formulas cheat sheet, microsoft excel end chapter project open bidding, microsoft excel spreadsheet template project management, supply chain formulas microsoft excel, microsoft excel project, microsoft excel project work, microsoft excel vba project organization, formulas microsoft excel, microsoft excel functions formulas, excel formulas project, ready project microsoft excel, microsoft excel project function, start project microsoft excel

Tentang Majikan:
( 38 ulasan ) Los Angeles, United States

ID Projek: #16386319

Dianugerahkan kepada:

sunprah2018

As you mentioned "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) 617171sadaga Lagi

$30 USD dalam sehari
(1 Ulasan)
1.2

29 pekerja bebas membida secara purata $34 untuk pekerjaan ini

cgullapalli

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 Pleas Lagi

$30 USD dalam 0 hari
(660 Ulasan)
7.7
P0L

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 dalam sehari
(246 Ulasan)
6.9
TonmoyRoy111

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 wil Lagi

$30 USD dalam sehari
(254 Ulasan)
6.4
The24CarrotsInc

Greetings for the day!! We have experience working on this subject. We ensure 100% QUALITY with ON-TIME [url removed, login to view] allow us to take this opportunity. Thanks & Regards, Team@The24CarrotsInc VBA/EXCEL Lagi

$25 USD dalam sehari
(61 Ulasan)
5.7
satishtl

- 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 C Lagi

$25 USD dalam sehari
(43 Ulasan)
5.3
beltran0404

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 reg Lagi

$25 USD dalam 2 hari
(82 Ulasan)
5.0
whitehorsetechn

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 Lagi

$50 USD dalam sehari
(13 Ulasan)
4.9
laurajiannaras

I have filled out the two people in the sheets you’ve requested. Since there must be a least 100 characters to my proposal, here is an explanation of my implementation to accomplish the results, as I have already ap Lagi

$30 USD dalam sehari
(6 Ulasan)
3.7
Ahmed818

Hello, i am expert in this kind of jobs samples of my excel VBA jobs https://www.freelancer.com/projects/Excel/VBA-loop-code-sum/ https://www.freelancer.com/projects/Excel/Complete-Some-Advanced-VBA-Microsoft Lagi

$10 USD dalam sehari
(19 Ulasan)
3.5
ReneRondon

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 a Lagi

$30 USD dalam sehari
(12 Ulasan)
2.8
haleem0786

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 dalam sehari
(7 Ulasan)
2.8
andrewmikhail95

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 dalam sehari
(3 Ulasan)
2.3
SureshXobos

I have filled out the two people in the sheets you’ve requested. 387187Edwardo Conde April '17 $39.00 617171sadagat kamalifard June '17 $495.00

$15 USD dalam sehari
(2 Ulasan)
0.7
Jahidj

Dear Sir, I’m interested in this [url removed, login to view] of your terms and conditions.I’m confident to perfect delivery about this project. Thanks and regards.

$25 USD dalam 7 hari
(0 Ulasan)
0.0
mdahdoli

A proposal has not yet been provided

$30 USD dalam 7 hari
(0 Ulasan)
0.0
$25 USD dalam sehari
(0 Ulasan)
0.0
veniaminspivak

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 Lagi

$15 USD dalam sehari
(0 Ulasan)
0.0
ParadoxEditor

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 dalam sehari
(0 Ulasan)
0.0
rarruda1988

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 tim Lagi

$25 USD dalam 6 hari
(0 Ulasan)
0.0
johnp9603

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 dalam 2 hari
(0 Ulasan)
0.0