I need an excel genius!

$30-250 AUD

I përfunduar

Postuar

about 5 years ago

$30-250 AUD

Paguhet në dorëzim

I run a personal training company and I keep all my sessions tracked via excel/google sheets. I have a spreadsheet created but I find the information is too complicated and not easy to explain to other people how I have come up with the sheet. I need to track sessions completed/remaining that I (and my other trainers do - we all might train the same clients on different days so it can be complicated when merging our data and keeping it smooth. We need to track GST, income tax, processing fee (depending on the method of payment), weekly/monthly expenses. We need to know when a member is running out of sessions on that week or a "remaining" balance. I will be the only one with access to this file but I need my team to input (or communicate) to me the number of sessions that they have completed in a given week. The uploaded file is almost how I imagine I would like it but I feel my excel skill is rather amateur and I would be better to incorporate macros - which I have no idea what to do. I have a centralised database to input client rates and session details and it links to each month so the beginning of March will have the same amount of sessions at the end of February, but if the name is not present in that month it creates an error message. It is more difficult than it needs to be but I don't have the time or the skill to fix it. I input sessions done in a month tab (but weekly might be best) - and it references onto a summary sheet but I find it difficult to visualise my business within this. [The file was created in google sheets and I can't upload it here so I am converting it to excel so the functionality will be not working but hopefully you will have enough to understand what I mean.

ID e Projektit: 19030065

Rreth projektit

11 propozime

Projekt në distancë

Aktive 5 yrs ago

Po kërkoni të fitoni para?

Adresa e email-it

Përfitimet e ofertës për Freelancer

Vendosni buxhetin dhe afatin tuaj

Paguhuni për punën tuaj

Përshkruani propozimin tuaj

Është falas të regjistrohesh dhe të bësh oferta për punë

I dhënë për:

@zekovicm

Hi there,I am Excel expert from Bosnia & Herzegovina,Europe. I have carefully gone through with your requirements and I would like to help you with this project ! I can start immediately and finish it within the agreed deadline. Check out my profile, portfolio and former clients feedback - that'll let you know everything about me. Please feel free to contact me so that we can discuss further details. Thank you for taking the time to read my proposal.I am looking forward to hearing from you. Best regards, Miljan

$164 AUD në 3 ditë

4,8

(122 përshtypje)

7,2

11 freelancers are bidding on average $319 AUD for this job

@jkaranm

Hi, My name is Janis and I have been here in freelancer since 2014. One of the preferred freelancer because of the good standing and have good feedback from previous employers. I was asked by the freelancer staff Albert to bid on your project. I believe we can help you with your excel work because I do have a team and are mostly my cousins/close friends that is why we have been working as a good team with trust. My business is to make your business effective, profitable & efficient. We are able to have a sound understanding of our Clients’ operations and their corporate goals, and we continually bring knowledge and new ideas to them. I am a pioneer in the outsourcing/call center industry in the Philippines, and as such, have a deep understanding of world-class customer service, prompt delivery of jobs & the importance of client satisfaction of our work. The team is led by me–a forward-thinking, resourceful professional with more than 13 yrs of experience in Sales, Marketing & Customer Service; who understands the power of good relationships with customers/clients, and that this is the foundation of a successful business & attracts repeat sales. We are highly-skilled, well-educated, English-speaking, smart professionals ready to deliver results for you. Been working on different projects since 2014, with most of my clients are from here (you can check the good reviews we garner on my profile). Willing to discuss.

$294 AUD në 5 ditë

4,9

(69 përshtypje)

8,0

@prameswara

Hello Sir Im excel VBA macro and formula Expert :) i already see your MOMENTUM REPORTING 2018-2019 (1).xlsx and i need discuss more about what modify/adjustment that u need please ping me now and we can start discuss to make sure everything before start Thank you Galih

$294 AUD në 10 ditë

4,9

(356 përshtypje)

7,1

@paris2785

Hi, there! My name is Paris, and I was glad to see that you're looking for an Excel developer. According to your brief, you want to have your Excel application upgraded with macros. Although I've not understood the required tasks fully, I believe that I can help you with VBA coding. I will charge you $250 and can deliver within a week (a single milestone to release once you're satisfied with the final result). I'm among the most experienced, and skilled Excel, and VBA developers on this platform. I have completed over 290 projects successfully in six years, and I feel confident in achieving your task as well. You're welcome to visit my page (https://www.freelancer.com/u/paris2785) and get an idea of who I am and what services I provide to my clients. I'm online from 8 am to 9 pm, Athens time (including weekends). I'm looking forward to working with you. Sincerely, Paris Pallas

$250 AUD në 7 ditë

4,9

(184 përshtypje)

7,2

@dgled

Hi, to my opinion it can be better to prepare the main file in Microsoft Excel and to import the info of your employees in real time. why? it is because of the capacity (I.E cells quantity). to convert your sheets to one structured database, I need a capacity around 800,000 rows X 20 columns per year which it does not fit to google sheets. regarding my suggestion: I have considerable experience working with Excel, especially with organized structured database and populate reports from it. Also, I know how to import data from google sheets into the main database (by google drive). I do it by Pivot table formulas and macros. I consider myself a guru in Excel/VBA/Macro. I have extensive knowledge and expertise in advanced formulas, Pivot Tables, Visual Basic Application (including preparation of dynamic dashboards, screen layout's (user-forms), drop-down boxes, generator reports, and charts). I come up with creative and sophisticated financial & statistical modules in a simplified and logical manner. I have extensive experience in Financial Reports, accounting, consolidating, forecasting, budgeting, and cost acquisition. I am a specialist in managing cash flow and liquidity solutions for the multi-currency environment and globally including collections, payments, inventory, and taxation.

$500 AUD në 7 ditë

4,9

(89 përshtypje)

7,1

@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

$250 AUD në 15 ditë

5,0

(224 përshtypje)

6,9

@atifdar

Hi there, MS Excel/VBA expert here with Accounting edge I've read the project description, I will re-design the spreadsheet so tracking for completed & remaining sessions is visualize more effectively Will also make GST/Income Tax/Processing Fees being tracked for each client separately based on method of payment The reporting tabs will be completely automated and will display when a member is running out of sessions Would like to access original version (google sheet) as well Would love to speak to you further to discuss more via chat Thanks

$199 AUD në 3 ditë

4,9

(95 përshtypje)

6,4

@vaidyag

HI, I would suggest you use an Access system to do this instead of just Excel and we can use forms to do data entry and can generate reports from the same. So it will fit your requirements as well. I have excellent experience in C#, Excel and Access and other Microsoft related technologies. I have written complex macros like creating a BoM for an ERP, creating P/L, Cashflow statements from a database. I have worked in Infosys a top IT services company for more than 10 years and now i have started on my own. As part of my infosys tenure i have been executing projects for Microsoft as a customer across various technologies like DotNet, SQL Server, SSIS, SSRS. have executed many turn key projects for them in their licensing space which is very critical for them. Will be able to leverage this experience to deliver this project successfully. Once we discuss the project scope in detail will be able to provide a more accurate pricing and timelines. Thanks Regards Vaidy

$823 AUD në 20 ditë

5,0

(14 përshtypje)

5,3

@michael767

Ohew - that's quite a system of spreadsheets you've got there. It's going to need quite a bit of work. I see you maximum budget is AUD250 which I can only get 212 for myself. Still, it looks intriguing and being an Aussie like you, we all like a challenge. You can see my background in my profile and the success I've had in the past.

$247 AUD në 7 ditë

5,0

(5 përshtypje)

4,0

@freelancerpr0

Excel VBA automation consultant I am blessed to be able to do what I love, and I think my reviews shows in my work. I love problem solving, and creating automated solutions to streamline processes and save my clients countless hours of manual work. I like the wide exposure to different projects that the freelancing environment offers, and the opportunity to interact with such a diverse range of clients is very exciting. If you are looking for someone to create a complete spreadsheet solution for your business, automate current manual processes, or are struggling with any complex spreadsheet or VBA issue, feel free to contact me. Looking forward to hearing from you!

$249 AUD në 10 ditë