Completed

Excel Finish Formulas and formatting for Excel Sheet

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

Skills: Excel, Data Processing, Data Entry, Visual Basic, Microsoft Office

See more: shift roster sheet excel, assumption sheet excel, keep source formatting link excel ole, buyers net sheet excel, format salary sheet excel, code update sheet excel, vba excel task mapping sheet, access vba excel task manager simple, formulas conditional formatting excel, simple salary sheet excel, professional excel task sheet, simple expense sheet excel, Very simple Excel task! Only 8 steps! , excel formulas with examples in excel sheet free download, advanced excel formulas with examples in excel sheet free download, how to copy formatting in excel to another sheet, advanced excel formulas with examples in excel sheet pdf

About the Employer:
( 2 reviews ) Farmington, United States

Project ID: #26771314

Awarded to:

(218 Reviews)
6.5

53 freelancers are bidding on average $108 for this job

P0L

(427 Reviews)
7.7
(253 Reviews)
7.2
(441 Reviews)
7.2
(62 Reviews)
6.6
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 excell More

$65 USD in 2 days
(83 Reviews)
6.1
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 exper More

$175 USD in 7 days
(61 Reviews)
5.9
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 More

$140 USD in 1 day
(112 Reviews)
5.9
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 absolut More

$140 USD in 1 day
(163 Reviews)
5.9
imfarrukh47

Hi, Greetings. I am farrukh and I am Microsoft office Specialist Master (Excel Expert-2). I am working with excel for over 2 years and have strong grip over vba. You can verify my Microsoft Credential here at Microsoft More

$100 USD in 1 day
(18 Reviews)
5.1
(55 Reviews)
5.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 Ex More

$400 USD in 7 days
(16 Reviews)
4.6
(19 Reviews)
4.8
(20 Reviews)
4.7
nemanjadj20

Hello? I have worked on Excel/Word/PPT/MACRO projects to what you are looking for, and I am confident I can exceed your expectations. I have attached samples of work very similar to what you are seeking. # create More

$100 USD in 3 days
(7 Reviews)
4.5
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
(27 Reviews)
4.1
SIBTEHASSANBUTT

Hi there, I have read your project entitled “ Excel Finish Formulas and formatting for Excel Sheet ” I am a professional accountant dealing with PowerBi, well versed with data analytics, using excel and other data visu More

$55 USD in 7 days
(10 Reviews)
3.7
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
(6 Reviews)
3.4
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, qu More

$95 USD in 1 day
(7 Reviews)
2.8
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 More

$140 USD in 1 day
(6 Reviews)
2.9
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 fo More

$30 USD in 1 day
(2 Reviews)
2.7