02 - VBA expert - Budget Sheet

$10-60 AUD

Closed

Posted

about 4 years ago

$10-60 AUD

Paid on delivery

I have been playing around with some basic online template in regards to Excel Personal budgets which I could use, but I can't find something customized enough to where I can actually utilize it. I'm a free lancer and I need a customize Excel personal budget spreadsheet. I have uploaded an example file. I want to clarify that what I seek must be ten times better than what I can find my self online. Specifications: I need a spreadsheet which will include a graph that will permit me to identify my biggest spending by category. I need a second intergrated graph which will allow me to view how my income changes over a twenty for day period. I need monthly budget that will include only a total of 24 days worth of entries. I also need a section where I can input daily miles driven and track them over the twenty four days of the budget term. Categories should be easily editable whereever possible to change them in the near future to cover specific needs.

Excel

Excel Macros

Visual Basic

Visual Basic for Apps

Project ID: 24715640

About the project

17 proposals

Remote project

Active 4 yrs ago

Looking to make some money?

Email address

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

17 freelancers are bidding on average $113 AUD for this job

@vsprybhanu

Hi, My name is Virendra. I am experienced Data Analyst and Macro Developer. I have read your instructions carefully. I have excellent knowledge and experience of Manipulating and Exchanging Data in Multiple Sheets, Using Advanced Formulas, Critical Programming, Developing System for Management and Creating Reports. I have done mostly Excel VBA Programming jobs. So, I can do this job nicely. Ready to start please message me to discuss your project in more details. Thanks, Virendra

$50 AUD in 3 days

4.8

(92 reviews)

5.7

@citijayamala

1. I am an expert in Excel, VBA, Excel formulas, and all excel functions, macros, lookup, pivot tables and charts. I read your project description and I am sure that I can handle your project. 2. Have done many projects in Excel, created many dashboards, and Business intelligence tool for forex markets. Experienced MBA Finance as well. 3. Your project will be delivered on time with high standard 4. Assistance will be provided with number of clarifications until client satisfaction

$90 AUD in 3 days

4.8

(69 reviews)

5.7

@paulodayto08

Hi, Good Day! I can help you building Automated tool using excel and vba macro. Most of client need an excel tool that has userforms to make more user friendly and organize. I can help you build that tool. Please message me to discuss more about the project and I can also send you some of my works to help you decide on hiring me. I am a Project Management officer for 8 years in Accenture and Project Manager now in Appen Philippines. I do financial reports and budget forecasting for our Clients. I have all the ability to help you. I also done a lot of Reports and Templates using MS Excel. I can use my expertise in VBA Macro do it quickly and accurately. With my experience as a VBA Macro developer for 8 years I can give you the high quality tool that can generate accurate result that you wanted using MS Excel. Please message me anytime to discuss more about this project. I am willing to help you out and show you my expertise. Thank you!

$60 AUD in 3 days

4.9

(43 reviews)

4.7

@MMG2019

Hi, I have more experiences in Visual Basic and VBA . I can help you in your Excel file with your specifications mentioned. Feel free discuss with me . Thanks.

$60 AUD in 2 days

4.9

(7 reviews)

3.8

@clearatul0

Please find my scope for youe 5 specification points: 1. Pareto Can be prepared 2. Can be done if we have income details daywise 3. If budget formula is defined, we can define it for any no. of days. 4. we can reflect your input details while dasboarding 5. Can be changed in main data, use slicers or taken as input for dashboarding. We can do it simply as well as by macros. Price might change based on the data type, work structure and time required but definately will be with budget.

$10 AUD in 7 days

4.8

(3 reviews)

2.8

@Abhishek1409

Hi, let me go through your requirements one by 1. The sheet you have shared needs a lot of work. What we can do to work with your point no. 1, 2, 3 and 4 is to create a dashboard with very less clutter. On the dashboard, you can input daily entries based on subcategories, and once you click on add, these values will be added on the master sheet. The dashboard will also have both the graphs that you require and a large number showing your months spend to date or spend in the last 24 months. I can add a button to switch between monthly weekly and daily modes too. To take care of your 5th requirement, we can have a separate sheet where you can add/remove categories and subcategories. This will require good work in VBA and thus to capture all your requirements 14 days is a good time. I have put together a dummy dashboard for you to have a look. Please ping me if you are interested in seeing the same.

$40 AUD in 7 days

2.8

(1 review)

2.0

@Sajidali001

Hi! *I DID SIMILAR WORK I CAN SHOW YOU IMMEDIATELY* CHECK MY PORTFOLIO “BE YOUR OWN BOOKKEEPER”. Sounds like you need Finance as well as Excel expert for Preparation of your Budget sheet. I am Chartered Accountant- Affiliate (CPA) and certified in Accounting and Finance with the diversified experience of 6+ years in the field of Accountancy and Finance (In varies industries such as Service, Manufacturing, Retail, Education, IT). I can prepare budget sheet for you as i did similar work earlier. Because i recently started my career as freelancer so you cannot assess my skills from reviews so the only thing is my portfolio i did same work before and i can show you a sample work. looking forward to your response. Thanks

$56 AUD in 1 day

4.2

(1 review)

1.5

@asifsikder02

Hello Sir/Madam I'am ready for your data entry project please send me a massage for further discussion. Thank you

$1,125 AUD in 7 days

5.0

(2 reviews)

0.2

@gops3044

I am work oriented guy andni believe in focusing on work without doing any other things and provide quality work in enough time.

$40 AUD in 10 days

0.0

(0 reviews)

0.0

@Bekhalvik

Hello! I am a beginner freelancer, please do not look at my rating :) I am interested in your offer! I will do everything quickly and efficiently, give me a chance! I have a lot of experience with working in databases, and vizualization so this task will not be a problem for me. I think this will be a good start to my freelance career. Contact me to discuss the details :)

$15 AUD in 1 day

0.0

(0 reviews)

0.0

@Rakeshsharmahsr

I have wonderful experience in this regard. I preform my work with high level of accuracy. I will keenly interested to work with you. I assure you will love my work once you get it done. After this work our bonding will flourish further. I look forward for your positive response to my this proposal.

$35 AUD in 7 days

0.0

(0 reviews)

0.0

@ljayasooriya83

I am a mechanical engineer with years of experience in professional organizations. I have used excel extensively for projects and with my knowledge in macros and VBA, I have help companies to get their work done fast and efficiently. Put me a message and let’s discuss further

$60 AUD in 3 days

0.0

(0 reviews)

1.1

@LuceroArz

I have made several excel/vba templates which were used to track expenses of big competitions and expenses of small organizations, so I'm confident I can make a budget template for you :) Relevant Skills and Experience I have made several excel/vba templates which were used to track expenses of big competitions and expenses of small organizations, so I'm confident I can make a budget template for you :)

$15 AUD in 7 days

0.0

(0 reviews)

0.0

@Pradeep9000

Please share me the example you have, as per your request I can help you out. Relevant Skills and Experience I work on excel dashboards

$40 AUD in 10 days

0.0

(0 reviews)

0.0

@pedrocsa

Hi, Although new to freelancer I'm a very experienced VBA programmer being completed a lot of tasks using VBA integrating with MS Access, SQL Server, and having most of this programs developed in VBA running in multiple computers at the same time. The time to complete the project will depend on the details, but with my experience I can assure you that I'll be pretty quick on completing it. I'll be very happy to take your project and help you complete it. I hope to have the opportunity to help you. Best regards, Pedro

$20 AUD in 2 days