Microsoft Excel Expert & VBA Programmer | Data Mining & Scraping Guru | Camtasia Studio Specialist

I am experienced in Microsoft Excel Formatting, Formulas, Macros and Functions. I am capable to Automate MS Excel tasks using VBA Programming Skills. Strong grip on writing custom Functions & Scripts to take full advantage of MS Excel expertise.

Data Mining & Web scraping are also my field of experience where I implement my VBA Programming skills to automate the Data Entry & Web Scraping tasks backed by strong knowledge of Artificial Intelligence to ensure Data Integrity & Accuracy.

Excel Forms Application is also an elegant way of Data Entry. I develop Windows Forms Application with great User Interface and Data Validations to avoid any possibility of inaccurate data entry.

A brief of my skillset is as below: -

1. Automating MS Excel,
2. Writing custom functions / formulas,
3. Developing Macros,
4. Developing MS Excel forms applications.
5. Customized Formatting / Conditional Formatting
6. Data Manipulation
7. Data Cleansing / Organizing
8. Developing Robust Excel Applications
9. Dashboard Development
10. Data Presentation
11. In-sheet Controls (Button, Drop-down, Checkbox, Radio Box, Search box etc)
12. Data Validation Expertise (both in Forms / Sheets, Cells etc)
13. Preparing Automated Reports
14. Customized Report Printing & Emailing / Bulk Emailing
15. Automated Data Entry / Data Collection / Web Scraping
16. API Integration
17. Microsoft Excel Charts / Dashboards


Video development skills :-
1. Camtasia studio 8,9 full stack editor