Find Jobs
Hire Freelancers

Custom excel sheet

$10-30 USD

Completed
Posted almost 4 years ago

$10-30 USD

Paid on delivery
I need a custom excel sheet built for my ecommerce business that I can manually enter order details, costs and monthly overhead costs and see data. I need: 1. Products -cost price vs sales price 2. Shipping- Shipping revenue vs shipping costs 3. Total profit 4. Profit Margin 5. Monthly overhead costs 6. Monthly Summary page with graphs The attached spreadsheet is one that I built myself to just figure out true financials of a couple of orders, but it should give you an idea. But I am not the best formula and sheet link person.
Project ID: 25777429

About the project

38 proposals
Remote project
Active 4 yrs ago

Looking to make some money?

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
Awarded to:
User Avatar
Hi there, I can automate excel sheet for you through vba in which you can track your E- commerce - Products -cost price vs sales price/ Total profit/Monthly Summary page with graphs and can customize other requirements. I am excel vba expert and have experience in Excel VBA, creating complex automation tools, formulas, databases, queries and macros. Let's discuss details over chat. Thank you. Ravinder
$25 USD in 1 day
4.9 (159 reviews)
6.1
6.1
38 freelancers are bidding on average $23 USD for this job
User Avatar
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 will be happy after hiring me. Kindly contact me. Akriti
$30 USD in 1 day
4.9 (348 reviews)
7.3
7.3
User Avatar
Hi Dear Employer, Thanks for seeing my response to your project. I have read your job description, learned your goal to hire a professional accountant to review and fix the formulas. I am a professional accountant with Certified Accounting Technician (UK) and MBA-Finance with a professional team of CA, ACA, ACCA and ACMA more than 14 years’ experience, ERP, ORACLE and QUICK BOOK, bookkeeping up to finalization of accounts, data entry with good presentation and communication skills, Excel, Word and presentation of PowerPoints, periodically analyzing, in the end, I want to say that my skills not limited to Task completed of writing Business plan, critical essays, management subjects, Accounts, financial reporting/analysis, Capital Budgeting (NPV, IRR, Payback Period, WACC (Weighted Average Cost of Capital), Accounts Management, Accounts reconciliations, Receivable/Payables, Budgeting, If interested, open PMB (message board) so we can discuss and provide you a 1-day free trial for testing my workability. Looking forward to work with you and to build a long-lasting work relationship. Sincerely, Habib Ur Rahman
$50 USD in 2 days
4.9 (76 reviews)
6.2
6.2
User Avatar
Hello, I can assist you in best way &I have done several projects in MS Excel & VBA. It. It includes extracting information from text files, websites, transferring info in to excel, User forms, Shapes variation, Pivot Tables, Data Scrapping from websites, data extraction for multiple Excel sheets and consolidating in a central sheet, etc. I have also handled various Excel tasks. It includes the creation of formulas using arrays, Pivot table creation, Creation of graphs, filtering, removing duplicates, Data analysis etc. Thanks, Mohit
$20 USD in 1 day
5.0 (89 reviews)
5.5
5.5
User Avatar
Hello, I can help you create a custom sheet in excel for your business. I can create a page where you can compare and visualize the various costs, prices and margins. The dashboard will be simple, yet functional and dynamic. I can also make the present sheet dynamic, so that all future data inclusions can be taken care off in the dashboard page. Shall we discuss this further? Let me know if i could help you. Thank you
$30 USD in 1 day
5.0 (24 reviews)
5.2
5.2
User Avatar
Hello, I have gone through with contents and attached files to understand the requirements. I am interested to do this work and break your huddle. Please allow me to do this job. I am available to support you 24*7 just ping me once. I have a good knowledge of Excel, Advance Excel functions and VBA. I know Sumifs, Countifs, Averageifs, Index, Match, Vlookup, Hlookup, Sorting, Pivot table, Slicers, Developer functions & Conditional formatting, etc. Please check my portfolio to know more. Thanks, Jitender Kumar
$20 USD in 1 day
5.0 (24 reviews)
4.7
4.7
User Avatar
Hi, I have gone through your project placement & it matches my expertise, I understand that you are looking for an expert in excel to make dashboard for an over all snaphot of your activity. I have 13 YEARS of Experience in working with MS EXCEL, WORD & PPT. I can automate processes, make Fully dynamic, Real time updating Financial Reports, Models & Dash boards through formulas, Power query, Power BI and Macros. Financial & management reporting, Financial analysis, Forecasting & budgeting is my domain. Compiling Data from different sources, cleaning and transforming it to a standard form in most efficient way for optimal integration with advanced excel features, analyzing and then Reporting in a presentable way is a routine. You can expect a very professional outcome. Looking forward to your Response Regards
$10 USD in 1 day
4.9 (16 reviews)
3.6
3.6
User Avatar
Hi I am CA Qualified and have relevant experience of more than 12 years. i can be a better choice for this project.
$30 USD in 7 days
5.0 (3 reviews)
1.3
1.3
User Avatar
Hello dear I `m Ahmed from Pakistan I mastered the field of data entry, PDF files, Word, Excel, PowerPoint, Word and other programs. I can do this job for you in record time just give me this job and it not be the last if you see my work Thanks
$10 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
I have gone through your project. You need to create an excel sheet. I am skilled at this task. I have been doing this task since last 3 years. Wish to working with you. Regards.
$15 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi I am a professional in the field of data entry and dealing with Microsoft software, so I guarantee that you will finish your work as soon as possible and have the best quality available
$10 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I'm a MBA graduate in finance, do bankruptcy analysis for 2 years for 13 companies.
$25 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Greethings The required work for your e-commerce business will be done in Professional way please dont look i am new here just give me a chance & relax yourself Thanks
$25 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, Hope this finds you well. I am ready to begin to be a valuable asset to your project. I have a proven track record. I am a database developer and information systems specialist. I have worked with many facets involving data systems and applications. Lets discuss this further. Thank you.
$30 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Sir I will complete your work so please give me a chance Relevant Skills and Experience Microsoft Excel, Microsoft office
$25 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello, I am Yogesh Charokar. It was great to know about your project. I find a lot of interest in this project. I am a beginner and start my carrer with your project. I know very well about data entry and Excel. Please Respond, I am waiting for your work.
$10 USD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Having a good experience on excel sheets and on handling data from last 3 to 4 years. Can easily do this job depends on clarity of the requirements asked.
$15 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi there! I would like to convey my interest for this project. You could expect an outstanding outcome with a negotiable pay. I hope you could grant me the opportunity to serve you. Thank you so much! Just message me if you want to discuss more.
$20 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
I read careful your project. Experience in Excel,word,Pdf file So i do properly and give you correct schedule ti
$10 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
I AM EXPERT IN EXCEL I CAN MAKE THIS DATA VERY GOOD WAY EVEN YOU CAN ANALYSIS YOUR REVENUE AND EXPENSES
$16 USD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, sir
$25 USD in 1 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
BUCKEYE, United States
5.0
1
Payment method verified
Member since May 1, 2020

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.