- Have done similar Quotation, PO in Excel
- Can be printed as PDF
- Depending on the choice selected the Checkbox or Text can be shown
- Also based on the number of items selected from the dropdown the price would be displayed, based on the qty the total for the item, and the whole Quote or PO can be calculated and generated.
My Skills:
- Have expertise in Excel automation, macros, formulas, calculations, summarising and Graphs.
- Extensively the macros/VBA to automat e:
- Data validation in a particular, Data consolidation into sheets, comparing, plugging in default values for few cells
- Data camparision using formulas, lookups and bringing up summaries.,
- Mathematical functions, scientific calculations, index, array, formula arrays which are advanced concepts - Have used them.
- With summary data plotting graphs, bringing pivot tables