Greeting! I am an expert in MS Excel, Google sheet, MS Access and MS Excel VBA. I have 18 Yrs experience. I have worked 6 MNC companies. I have developed 1000 macros & formula sheets in Google sheets, MS Excel and MS Excel VBA for global sales team, paper mill, manufacturing companies and upload data on websites and worked in 200 million data in MS Access.
Examples: -
Market, Portfolio, Funnel, Revenue, Vision and True North for (Sales Playbook)
Module for paper size cutting (stop for wastage)
Macro for purchase paper reels (as per requirement)
Formula sheet for finance balance sheets for maintain as (opening, closing &
GST)
Formula sheet for data entry (inward & outward material PMS & IMS)
Module for PIR as production process in part in machine wise.
VBA (MS Excel) :-
1. Predefined functions (split, vlookup, offset, date, time, len,
trim, sum, count, sumif, countif, concatenate (&),
counta, match, Index, left, right, shell, average, max, min,
Ucase, Lcase, proper, strReverse 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. collection
16. Sort and Filter
17. Input Box and Message Box
18. Dictionary
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
: MS Access 2016 (full outer join, left join, right join, inner join,
select, in, not in, create table, like, drop, where, order by, ASC,
DESC and ODBC)
I would love to have the opportunity to discuss your project with you.
I believe my skills are a match for your project. I would be easily able to achieve the task.
Ensure projects are completed on time and achieving 100% success rate.