Excel/VBA Wizard, Business/ Financial Dashboards and templates expert
Last active: 21 hours ago
I have over 12 yeas of experience in using Microsoft Excel and VBA. I have designed several Business and Financial Dashboards, Templates, Calculators and various tools to help businesses in their planning.
My Skill sets are:
1- Microsoft Excel / VBA
2- Dashboards and templates
3- Financial statement analysis
4- Number Crunching
5- Business growth calculators
6- Interpretation of extremely complex data
7- Link Excel with Access, Outlook, Powerpoint and Word using VBA.
Some Examples of my work over Upwork.
1- I have extensive experience of linking Excel with other applications using my VBA skills. I can link Excel and Access, Excel and Powerpoint, Excel and Word, Excel and Outlook, Excel and MySQL. I have worked on several projects where I have linked multiple Microsoft Office applications with Excel. For example I have used Excel VBA to import data from MySQL(and Access) into a Dashboard, built in Excel, and then linked it with Outlook to send email, with a pdf attachment of the report.
2- I have created an Excel based accounting software, specific to client's needs, where Access was used as database.
3- I have used Excel with Powerpoint where, using VBA, data was processed in Excel and then automatically presented, with the help of charts and tables, in Powerpoint.
I enjoy working on complex tasks involving Excel, finance, business and numbers.