I will provide excel or access macro for calculation for automation powerbi dashboards

India

200 orders completed

Level 1

Has met certain performance criteria and shows strong potential in the marketplace.

About this Gig

Development of Excel or MS Access Macro for the automation, data transfer and form development. I will provide you delivery very fast.


Wide variety of automation were performed right from balance sheet to impossible things with Excel Power point etc

  • Created attractive dashboards with Excel ,Power BI, Power Point to impress the final presentation to end clients
  • Provided solution to make an ERP in Access from Forms, database design and migration to other databases
  • Split the access database to make user interface separate and data into different server in network or on cloud or remote server or even migrated to MSSQL or MYSQL and connection made with UI
  • Power point functions are not exposed which are automated with and add-in provided from ribbon control to make the use easy for the end user
  • Word automation was done to create a Software Compliance report for the Audit
  • Tests were designed in Excel for evaluation and report generation etc


Platform:

Excel

Google Sheets

OpenOffice

Development technology:

VBA

Python

Power Query

Expertise:

Forms

Formulas

Functions

Macros

Add-ins