Hi,
I have over 8 years of experience working with Excel VBA and formulas
My skills include:
1. Reading/writing data from/to excel and other files (text, word, access)-using VBA
2. Adding complicated nested formulas to worksheets (vlookup, hlookup, match, index, indirect, array formulas).Directly as well as, using Macros based on conditions entered by user
3. Formatting data (rearranging, splitting, combining, sorting) using macros
4. Making macros that react to user actions
5. Combining different charts (Line, column, candlestick etc) on a single chart
6. Connecting to databases using ADO/ODBC and executing SQL queries.
Databases worked on: MySQL, Access, Oracle, Other Excel files
7. Creating rich user interfaces in Excel using various controls (buttons, list/combo boxes, radio buttons etc..) Both, directly on excel worksheets as well as on individual forms.
8. Scraping websites from within Excel VBA
9. Automatically generating charts and pivot tables from VBA
10. Optimization using Excel Solver
11. Creating Macros that interact between different Office applications (Word, Powerpoint, Excel, Outlook)
Please send me some sample of the input data for testing so I can demonstrate my knowledge then you can decide on hiring me.
thanks & regards