Work with Excel for more than 20 years. Work with all kind of formulas including searching via Index, match and vlookup functions. Building search based on VBA codes based on date, text or numbers. Like any Excel official.
We like to utilize the built-in functions to its maximum extent before thinking about VBA code to avoid Excel revisions impact due to VBA changes.
Also, I have completed:
1. We have done many Excel sheets that validate all fields based on certain criteria like text length or restricted field entries.
2. Using OCR we convert all data from pdf or any other non-textual format to Excel tables. Sure, we have to review all converted data manually.
3. We have done many Excel that is using Website data like currency exchange rates to do some financial calculations.
4. We have built a complete tracking system for Cryptocurrency transactions and report both P/L and the current situation. It was mainly tracking and reporting excel.
5. We have created a complete timesheets system on Excel to track the time Vs. projects and report the projects hours and Ideal time.