- Went through the FIFO worksheet and the History and INventory tabs.
- Based on the daily transactions purchase or Sales of a particular SKU the costing and selling prices and the items sold on ongoing basis can calculate "As of Day" Status and show it up in the Inventory list the quantity available and the rate using FIFO method.
My Skills:
- Have expertise in Excel automation, macros, formulas, calculations, summarising and Graphs.
- Extensively the macros/VBA to automate:
- Data camparision using formulas, lookups and summaries.,
- 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
- Pl. review my portfolio on projects done - https://www.freelancer.com/u/satishtl