Excel and VBA macros
Excel macros play an important role to perform repetitive operations in excel. It takes lot of time, when handled manually. I have done quite good amount of work in excel macro handling. It includes, extracting information from text files, transferring info in to excel, E-commerce templates, Image handling, Shapes variation, Pivot Tables, Data Scrapping from websites, etc.\\\\\\\\n\\\\\\\\nI have handled various excel tasks. It includes creation of formulas using arrays, Pivot table creation, Creation of graphs, Filtering, Removing duplicates, Data analysis, Data entry works, etc.
Live Well For A Better Society: ✔ Excel: Advanced Array Formulas, Charts, Pivot Tables, Pivot Charts, Power query, Mail Merge, VBA Macros. Email through Outlook,gmail, Add-in, Customized Macros :::: Extraction from JSON, XML, SQL Database :::: Conversion to JSON, XML :::: Creating reports from various data sources :::: XML customUI ribbon :::: Windows Task Scheduler using VBScript ✔ Microsoft applications: Excel, Word, Access, Powerpoint, Outlook and creating VBA macros. ✔ Google Sheets: Advanced Formulas, SQL queries, Google Forms, Script, Google Data Studio ✔ Adobe Pro DC: PDF Fillable Forms, Editing, Java Script. ✔ Web Scraping and Browser Autonation: Extraction of Data and Images, Image extraction :::: Excel VBA, Python, imacro, PHP, .Net, C# :::: JSON, XML, API :::: Zillow (Zestimate), Yelp, Yellow Pages, Houzz, Racing And Sports, Sport sites, etc. ✔ Dashboarding / Business Intelligence / ETL / Data Integration / Data Warehousing :::: Power BI, Pentaho, Qlik View, Qlik Sense, Talend, Google Charts :::: Connection to Various data formats CSV, JSON, XML, etc. ✔ Web Design & Development: HTML, CSS, PHP, E-Commerce, Financial Calculators ✔ Applications: Java (Java, J2EE, Servlets, Hibernate, Swing), .Net, C# ✔ Database: Access, MySQL ✔ 3D Modeling: AutoCAD, Solid Edge, Solid Works, Tekla, Automation using LISP, C#, .Net ✔ Product Listing: Woocommerce, Magento, Etsy, Amazon ✔ Google Sheets: Google Advanced Formulas, SQL, Scripts, Linking to Web ✔ Virtual Assistant: Daily, Weekly, Monthly, Long term Opportunities at best deals :::: perform the tasks via screen sharing with little demo :::: Can Perform tasks in shared screen mode live to meet your deadlines. The testimonials will prove the care and effort, that will be taken during the execution of projects.