Hi,
As I understand you need a template to built in Excel to calculate material, pricing and sales invoice in Excel. It would help to discuss further on the requirement.
I am well versed with Excel and its various features like Userforms, Pivot tables, Slicers, HLookup, Vlookup, Countif, SUMIF, Left, Right, Index Match, drop down, filters, charts, graphs, conditional formatting, mail merge, dashboards and can provide the Excel that you are looking for.
If need be I can also do automation using VBA/Macros. I have done good amount of work in Excel macro handling. It includes userform creation, extracting information from text files, transferring info in to excel, E-commerce templates, sending email through Outlook, Image handling, Shapes variation, Data Scrapping from websites, data extraction, Pivot Tables etc.
I will be happy to answer any queries that you may have.
Looking forward to your response.
Thanks