Proficient in Microsoft Excel: basic and advanced formulas, VBA, Pivot Tables.
Experience includes, but is not limited to:
Handling large data files to extract statistical reports for sales or purchasing.
Create templates to calculate unit product cost in manufacturing
Create templates to periodically reconcile account receipts from different medium such as Amazon and PayPal. Using Vlookups, advanced formulas and VBA when convenient.
Create templates to calculate bonus and commission tables for complex pay schedules.
Create templates and VBA to automate daily tasks, reducing processing time from hours to seconds.
Handle text and cvs exports from different applications to populate upload templates used in the Amazon marketplace. All the while using Excel features to automate, and make the process fast and efficient.
Provide the end user with automated templates so that they can themselves do the work more efficiently