Help with Excel spreadsheet - Formulas/Macros

$30-250 AUD

Đã hoàn thành

Đã đăng vào

hơn 5 năm trước

$30-250 AUD

Thanh toán khi bàn giao

Project Brief – Excel Budget & Reconciliation Assistance with formulas/macros - maybe VBA but not sure. Please note: project needs to be finished by 07/12/2018 - Create drop down categories under the main worksheets (Core, Capacity & Capital) so when an invoice is entered against that support category, the running total is correct as per the dashboard. - Put bar graphs on the NDIS Dashboard to calculate the ‘burn rate’ of funds over the course of 12 months for each category of Core, Capacity & Capital (using the support amount to the expenditure) - Automate the cell highlight once the Support Amount (dashboard) is within $500 of the Remaining Balance - Bringing across (populating) the support balances in dashboard to the forecast tab under ‘Support Income’ - Forecast tab: Enter a formula that allows the user to calculate over the cost of a week/month/year etc. - Protect cells that have formulas in them; other areas to be edited as per participants plans/budget - Hyperlink on worksheets Forecast, Core Supports, Capacity Building & Capital Supports to click back to Dashboard worksheet

Data Processing

Excel

Visual Basic

Visual Basic for Apps

Mã dự án: 18289576

Về dự án

7 đề xuất

Dự án từ xa

Hoạt động 5 năm trước

Bạn muốn kiếm tiền?

Địa chỉ email

Lợi ích khi chào giá trên Freelancer

Thiết lập ngân sách và thời gian

Nhận thanh toán cho công việc

Phác thảo đề xuất của bạn

Miễn phí đăng ký và cháo giá cho công việc

Đã trao cho:

@informatikz

Hi, hope you are well. We are in Brisbane. Your requirement can be done through excel formulas (Sumif, Vlookup, Index Match) Please refer the comments we have received from our previous client (who is from Sydney) regarding an excel based employee timesheet which captures the time span to calculate pay rates. A little bit about our selves..., We are two management accountants (CPA, ACMA, CGMA), full time employed in Australia. Our service priorities are; 1. Complete information security - We value your information as you do. 2. Highest Quality - Professional service is guaranteed. 3. 100% Accuracy - We apply only if we are capable to do it. 4. On time delivery - We value your time. 5. Flexibility - We are open for modifications, changes and improvements. We are new to this website, therefore we provide services for a competitive price as we need your feedback and reviews to grow our business. Please refer our LinkedIn profiles for more information. Ranga - [login to view URL] Sachith - [login to view URL] We are looking forward to hearing from you. Yours faithfully, Sachith J. informatikz Team

$100 AUD trong 2 ngày

4,1

(2 nhận xét)

1,7

7 freelancer chào giá trung bình $96 AUD cho công việc này

@kevivu

I am from NYC, NY, USA. Completed numerous similar projects in the past and always impressed the clients with my excellent solutions. Expert in PYTHON,.NET, VB, VBA, MYSQL, SQL, MS Office, Access/Excel/Word/Outlook, Database, complex Formulae, Statistical analysis, Macros (VBA), pivot, Charts, formatting, templates, dashboard, etc. Worked on several complex Large scale application development, Webscrapping (Amazon / Aliexpress / eBay), VBA projects, viz converting Raw data to structured report, sales dashboard, PO tracking, Invoice Automation, budgeting, profitability, estimation, time management dashboards, etc. 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, 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. Looking forward to hear from you soon. Have a great day. Thank you.

$66 AUD trong 2 ngày

4,8

(74 nhận xét)

5,9

@c4cuteconain

I am a professional accountant with a decade of experience working in a US based NASDAQ registered company's finance department with excellent excel skills and knowledge.

$100 AUD trong 3 ngày

4,8

(39 nhận xét)

5,1

@dataexplorer

"Hello Dear, Yes, I can work for you as per your project description with amazing exploration and experimental research abilities of mine organization is perfect for that you may require. My work fulfills as well as keep you returning consistently. It is because of the importance behind this field that I am confident & serious when taking these types of projects. Let me introduce with professionalism and skill that exists to supply the best. Regards"

$150 AUD trong 3 ngày

4,9

(17 nhận xét)

3,9

@Mokshith30

Hi I am Mokshith Expertised in Web Scraping & VBA Macros.. i can do any excel automation tasks, bulk email handling using outlook,File Conversion i can "SCRAPE" any website either static or dynamic also.. & in addition to VBA i can do Python programming, Google Apps Script coding, Wordpress Developement, HTML, VB.Net, PHP, Javascript & css, Ecommerce Wordpress Sites Developement. I will do this task in a Day Only.. Thankyou~

$50 AUD trong 1 ngày

4,9

(10 nhận xét)

3,0

@nvchien94

I am an Excel expert. and I can help you to solve your task. I am so free right now so I can complete it soon. Contact me and I will discuss further. Thanks

$49 AUD trong 2 ngày