Banner Image

Skills

  • Data Analysis
  • SQL
  • VBA
  • Access Programming
  • Excel Programming
  • Macro
  • Word Processing
  • Analytics
  • Excel
  • Import and Export Operations
  • Microsoft
  • Microsoft Access
  • Microsoft SQL Server
  • Reports

Services

  • Data Analyst In VBA, Excel, SQL, Word

    $10/hr Starting at $25 Ongoing

    Dedicated Resource

    I have 13+ years of work experience in large data analysis as (200 million), automated reports generation with presentation & coordination with global team as USA, UK & Asia. Worked in Excel VBA, SQL...

    Access ProgrammingAnalyticsData AnalysisExcelExcel Programming

About

MS Excel VBA, MS Access

I am a software engineer (Master of Computer Application) & have 17+ years of work experience in large data analysis as (200 million), automated reports generation with presentation & coordination with global team as USA, UK & Asia.

Worked in Excel VBA, SQL Server & MS Access and provide best business solutions by developing customize macros and managed back-end functions to store in database with large data and import/export data in .csv, .txt with automation.

Work Terms

VBA (MS Excel 2016) :-
1. Predefined functions (split, vlookup, offset, date, time, len,
trim, text, sum, count, exact, sumif, countif, concatenate (&),
counta, match, Index, left, right, shell, average, max, min,
Ucase, Lcase, proper and InStr)
2. Loops (do while, do until, for next, for each next & while
wend)
3. Array (static & dynamic)
4. User Defined Functions (UDF)
5. ByRef and ByVal
6. Modules
7. Class modules
8. Charts (Bar, Pie and Line)
9. Pivot tables
10. ADO, DAO
11. FSO
12. File dialog
13. Select case
14. Add Ins
15. Outlook
16. Sort and Filter
17. Input Box and Message Box
18. Dictionary & collection
19. IF Then else
20. Forms
21. Data types
22. Option explicit and option base
23. Error handlers
24. Screen updating
25. Debugging
26. Objects
27. Workbooks, Worksheets, range and cells
28. Cut, copy and paste
29. DIM and set
30. Formatting and Comments