I have more than 8 years of experience in Excel and Excel VBA.
I have done several projects on excel and automating the tools. Any user can handle and work on these tools even if the user doesn't have excel knowledge.
1) Automated excel VBA tool where once user enters the data and click submit button, it creates presentation slides with each product, region, segmentation... on each slide also designs and arrange the tables.
2) Developed Excel VBA tool where it updates the data and charts on the excel report based on the selection on the drop down boxes (product, region, segmentation's...) and click submit button.
3) Created a tool with user forms, where user enters name, demographic, phone, email... details in the list boxes and submit, tool creates an unique ID (based on the different criteria )for the new customer and save the record in the table. It can also print customers information and many more...
4) Created dashboards, it gives all product information based on the region and category and also includes graphs and charts.
Reviews For This Service