- Worked on Google sheets automation.
- Used formulas extensively. Can get the template with formulas in Google sheets to track the costing on various advertising channels, including Adwords, FB, Pinterest.
- On button click can get the allocated budget adjusted based on the percentage fitment which can be as a parameter to allocate across channels.
- Can discuss further.
- Can get the data in csv files to be formatted per the Shopify format for quick upload.
- Have done similar product catalog listing (eBay Turbo Lister) from supplier list including the product code, description, price, variations, image url etc.
- Can discuss further.
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 recent projects.