Excel Finish Formulas and formatting for Excel Sheet

$30-250 USD

Completed

Posted

almost 4 years ago

$30-250 USD

Paid on delivery

I started with a Template for Sales/Purchasing/Inventory Management. I was able to tweak it a little bit to my needs. Now I just need it formulas added for reporting, a few more graphs and other simple task Products Sheet - Should be all set Purchases Sheet Product Name Drop down - Make Searchable without VBA Product Category have it list as soon as product is selected Total - = Amount + Tax + Shipping - Discounts Sales Sheet Total - = Amount + Tax + Shipping - Discounts Category - Link to product category have it auto select when product is chosen Product Name Drop Down - Make SEarchable withouth VBA Graphs QTR Amount by Supplier - Change to by Product Category Quantity Sorted by Supplier - Change to by Product Category Add 3rd Column with the following graphs top Ten items sold with profit (circle/pie chart) top 5 customers total sold (circle/pie chart) Amount Purchased by Supplier Graphs Month Same as QTR Profit-Loss Details on Sheet Cash Flow Details on Sheet Balance Sheet Details on Sheet Sales by Product Details on Sheet Sales by Customer Details on Sheet Inv Aging Details on Sheet Inv Sales Details on Sheet Data Sheet can be used for any formulas like it is now, if you need to add running totals on that sheet to make report page formulas simpler that's fine. If you can have

Project ID: 26771314

About the project

50 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

Awarded to:

@rashedkhanrubel

$0 USD in 1 day

5.0

(410 reviews)

7.6

50 freelancers are bidding on average $106 USD for this job

@akritisood94

Hi, How are you? I have developed several Excel & Word VBA macros before. And I know about Excel formulas very well. If needed, I first can do a demo and send it asap. And then you can see it and decide on this project. Also, I can send some of my VBA apps. I can complete your job successfully in your mind. Wishing for your response. Let me try at your job. Thanks

$140 USD in 1 day

4.9

(275 reviews)

7.0

@AnowarRatul

-------------------I CAN START RIGHT AWAY 100% ACCURACY-------------------------------- Hello sir, I have read your project details reviwed attachment. I can solve this by maintaining 100% accuracy of your data absolutely as you want. -------VBA Macro Coding, Formula Generation and Automation process expert with 5* ratting. I can start right now, please message me to discuss more. Regards, MA Hossain

$140 USD in 1 day

5.0

(382 reviews)

6.7

@GopalJp

Hi, I have gone through your requirements along attached demo sheet.I am interested in this project and provide you well created spreadsheet for achieving your desired results. I am an accountant and expert user of Excel. It would cost you $400 and I assure you quality delivery in 7 days. Kind Regards Gopal

$400 USD in 7 days

5.0

(32 reviews)

6.7

@kevivu

Hi, I have reviewed your requirement and I can definitely start immediately. Also I am 100% available during EST hours. I worked on numerous similar projects in the past and always impressed the clients with my excellent solutions. You can refer my freelancer profile for reviews and completed tasks: https://www.freelancer.com/u/kevivu.html Expert in MS Office/Google GSuite, Access/Excel/Word/Outlook, Database, complex Formulae, Statistical analysis, Macros (VBA), pivot, Charts, formatting, templates, dashboard, converting Raw data to structured report, sales dashboard, PO tracking, Invoice Automation, budgeting, profitability, estimation, time management dashboards, etc. In addition I am very comfortable with PYTHON/VBA/VB/.NET and SQL. 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 work with you.. Have a nice day Thanks.

$65 USD in 2 days

4.9

(92 reviews)

6.3

@narsim3128

NOTE : I HAVE EXPERTISE IN EXCEL AND VBA. I CAN COMPLETE THIS TASK IN QUICK TIME With respect to this project I would like to present myself as a candidate for your consideration. I have more than 12 years of IT experience. I have successfully completed projects which involved Programming, scripting, excel macros. Key features of my work are as follows: 1) Always within schedule 2) Always within scope 3) Best tools and techniques used for the completion of tasks Looking forward to hear from you. Regards

$175 USD in 7 days

4.8

(80 reviews)

6.2

@haleem0786

i can do this. i have good command over Ms excel especially pivot table, charts, advance formulas, formatting, macro etc. Please inbox me and share detail. Thanks Abdul Haleem

$120 USD in 2 days

4.9

(35 reviews)

5.0

@yadavexpert53

Hello, My historical achievements :-) I can assist you in best way &I have done several projects in Excel PDF conversion, 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. Let's initiate quick chat and discuss together. I would be happy to answer any queries that you may have Thanks, MBY

$49 USD in 1 day

4.9

(66 reviews)

5.2

@Jatin77777

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

$140 USD in 1 day

5.0

(24 reviews)

4.7

@ammar3215

I am pro in excel & working as a order management specialist with 7 years of experience & well versed with Sales/Purchasing/Inventory Management , I saw the attached excel file & can help you out in adding formulas for reporting & some graphs as desired , please share more details via chat so that I can start working

$30 USD in 1 day

5.0

(7 reviews)

4.6

@VbaStudio

Hello. I'm a specialist in Excel and macros programming. I can implement all formulas or coding if needed.

$30 USD in 3 days

5.0

(15 reviews)

3.9

@EDSRD

Hi there, I can create vba coding or excel formulas into your Sales/Purchasing/Inventory Management spreadsheet. I have 10+ years of experience in Excel VBA, creating complex automation tools, formulas, databases, queries and macros. Please message me to discuss more. Thank you.

$95 USD in 1 day

5.0

(13 reviews)

3.3

@trishverma2

Hey There, I am an expert in Web Scraping , Data Entry , Excel, Web Search and I am really interested in your project. I have great researching skills and would gladly work on your project. I am waiting to your quick positive reply and if you have any questions, feel free to ask Thanks.

$50 USD in 1 day

5.0

(1 review)

1.5

@mallinathc

Hi There, Greetings! I went through the project requirement and it interests me a lot. Hence i would like to take up this project responsibility. I have very good experience in excel database management such as your project. You may decide the cost of the project once you see my work. Regards, Mallinath

$30 USD in 1 day

5.0

(3 reviews)

1.6

@asifmahmudpro

Hi there, Let's do this right now. We can discuss more regarding the given project in the inbox. So, I will wait to hear from you. Thanks. Stay home, stay safe, and take care.

$30 USD in 1 day

5.0

(1 review)

1.1

@liejuni

hi, base on the file that you provided, i can create a simple vba for you i.e. P.O.S and Stock from purchasing department. check my portfolio in youtube channel name "Excel Dahsyat" for my previous job thank you

$250 USD in 7 days

5.0

(1 review)

0.8

@frkhanpathan973

Hello Dear Client, Are you looking for a Trusted and Professional Data expert to execute your work perfectly ? I am here one for you are on right place and quality freelancers and hire me . You will realize you never have to look for any other freelancer on here for your above task. I would love to work with you for a long time. Let me know if any question and please check out my profile for pricing and working hours and give me change to work with you and message me for your requirement . Thanks & Regards, Furkan Pathan

$30 USD in 2 days

0.0

(0 reviews)

0.0

@DharMonika

I have 10 + years of the experience in same kind of projects. I am available almost 24*7. Dedication , time management and positive attitude are my key strengths. You can be rest assured, your work will be delivered on time with high quality standards. Kindly contact me via chat for further details and discussion.. Thank you

$30 USD in 2 days

0.0

(0 reviews)

0.0

@Sameershukla30

my name is sameer shukla, You can do the work and deliver exceptional results. You will fit in beautifully and be a great addition to the team. You possess a combination of skills and experience that make you stand out from the crowd. Hiring you will make him look smart and make his life easier, Thank you .

$35 USD in 7 days