Tamamlanmış

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

Beceriler: Excel, Veri İşleme, Veri Girişi, Visual Basic, Microsoft Office

Daha fazlasını gör: 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

İşveren Hakkında:
( 2 değerlendirme ) Farmington, United States

Proje NO: #26771314

Seçilen:

(218 Değerlendirme)
6.5

Bu iş için 53 freelancer ortalamada $108 teklif veriyor

P0L

(427 Değerlendirme)
7.7
(253 Değerlendirme)
7.2
(441 Değerlendirme)
7.2
(62 Değerlendirme)
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 Daha Fazla

$65 USD in 2 gün içinde
(83 Değerlendirme)
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 Daha Fazla

$175 USD in 7 gün içinde
(61 Değerlendirme)
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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(112 Değerlendirme)
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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(163 Değerlendirme)
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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(18 Değerlendirme)
5.1
(55 Değerlendirme)
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 Daha Fazla

$400 USD in 7 gün içinde
(16 Değerlendirme)
4.6
(19 Değerlendirme)
4.8
(20 Değerlendirme)
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 Daha Fazla

$100 USD in 3 gün içinde
(7 Değerlendirme)
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 gün içinde
(27 Değerlendirme)
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 Daha Fazla

$55 USD in 7 gün içinde
(10 Değerlendirme)
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 gün içinde
(6 Değerlendirme)
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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(7 Değerlendirme)
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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(6 Değerlendirme)
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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(2 Değerlendirme)
2.7