Basic Spreadsheet Template

$10-30 USD

完了済み

投稿日:

8年以上前

$10-30 USD

完了時にお支払い

I need to have a template constructed that will allow me to aggregate 2-5 other basic spreadsheets. The basic spreadsheets will have 5 columns (month, YTD % Change, monthly % change, month end account value and monthly NET contributions). I need the percentage changes (performance) weighted based on the size of the month end account values. So, if I have only two accounts and one is valued at 30,000 with a 4% YTD gain and one is valued at 70,000 with a 3% YTD gain - the spreadsheet should generate an overall gain of 3.3%. For someone with Excel skills, this should take about 30 minutes?

Excel

プロジェクト ID: 8720855

プロジェクトについて

11個の提案

リモートプロジェクト

アクティブ 9年前

お金を稼ぎたいですか？

メールアドレス

Freelancerで入札する利点

予算と期間を設定してください

仕事で報酬を得る

提案をご説明ください

登録して仕事に入札するのは無料です

アワード者:

@someka

Just drop me a message and take it as done in 30 minutes ;) I have a 6 years of business analyst experience in a global company and 3 years data scientist experience in a game company before my freelancer career. Excel is my legs and arms. I can make any reporting, formulas, pivot tables, macros etc.

$24 USD 0日以内

5.0

(37 レビュー)

4.7

この仕事に11人のフリーランサーが、平均$25 USDで入札しています

@elqueabandona

Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews. They speak for themselves. Best regards

$30 USD 0日以内

4.9

(72 レビュー)

5.8

@kevivu

Dear Sir, Done numerous similar projects in the past and always impressed the clients with my excellent VBA solutions. Out of my 40 projects, almost 35+ are complex VB/VBA projects, hence i can definitely deliver an excellent solution to your requirement. Expert in VB/.NET, SQL, MS Office, Access/Excel/Word, Database, complex Formulae, Statistical analysis, Macros (VBA), pivot, Charts, formatting, templates, dashboard, etc. Worked on several complex excel VBA projects, viz converting Raw data to structured using vba, sales dashboard, PO tracking, budgeting, profitability, estimation, time management dashboards, etc. Also I am a quick learner and complete tasks very quickly using keyboard shortcuts and multitasking skills. And I have been consistently rated as excellent by all the employers. Also Having more than 14 years of experience in banking /finance /accounting, Business analysis, Data analysis, Software development, Software Testing, SDLC, Budgeting, estimation, Project management, Process re-engineering, Statistics, Bookkeeping, HR, Payroll, AR/AP, copy typing, ebook creation, publishing, Web research, Social media marketing, lead generation, etc. Looking forward to work with you.. Have a nice day Thanks.

$20 USD 0日以内

5.0

(34 レビュー)

5.0

@surekash7096

I have the expertise in Excel and can create this template with formulas in the worksheets and aggregating to a main sheet. Ready to start work now and deliver in 30 minutes... Please PM me..

$25 USD 1日以内

4.9

(19 レビュー)

4.0

@rajafaizan

I am very interested in your project.I will do it quickly. I have 5+ years exp. in MS Office, Designing, Quick-books, Office Management, PDF, Google spreadsheet, Vba and typing. I would like to thank you in advance.

$25 USD 1日以内