* Analysis of raw data, cleanng the data, Importing the data into the database, cleaning, transforming, and validating. Creation of formulas and writing VBA codes in excel and Power Point. * Write VBA programs to automatically update Excel workbooks, writing program modules and external data queries. * Working with other office application using VBA. * Programming in VBA with Word, Excel, Power Point and Outlook.