Banner Image

All Services

Engineering & Architecture

VBA and Script Developer

$11/hr Starting at $26

Excel expert: VBA macro automation, Power BI visualization I'm a skilled Excel VBA programmer and ETL tool developer (SAP BODS) with 5 years of experience. I've worked for Fortune Global 500 companies. My experience spans diverse industries including ecommerce, retail, technology, chemical, automotive, pharma and nutrition, logistics, oil & gas, marketing and advertising. My expertise: ++ VBA / VB Macro Development for MS Office Excel, Word, PowerPoint, Access I perform task automation, data manipulation and visualization using VBA, macros, Visual Basic, formulas. * Automate repetitive tasks in Excel and Word ++ QuickBooks Data Import and IIF File Creation I have experience in converting Excel and CSV files into IIF format for importing into QuickBooks. I create Excel VBA programs that can take transaction data from various sources, aggregate and manipulate the data, and generate an iif file for quick, easy upload into QuickBooks, saving a tremendous amount of time spent on manual entries. ++ Power BI Desktop & Power BI Service As an extension to my Excel VBA expertise, I'm also trained in Microsoft Power BI, a powerful tool to analyze, visualize and share data insights and business intelligence. * Build visual and interactive reports * Build interactive dashboards and drill-downs * Connect to variety of external and on-premise data sources including Excel, CSV, databases (Access, SQL, ERP, etc.) * Manipulate data * Schedule data refreshes * Share dashboards, view data on mobile * Query data using natural language and Power query (M) * Create measures using Data Analysis Expressions (DAX)

About

$11/hr Ongoing

Download Resume

Excel expert: VBA macro automation, Power BI visualization I'm a skilled Excel VBA programmer and ETL tool developer (SAP BODS) with 5 years of experience. I've worked for Fortune Global 500 companies. My experience spans diverse industries including ecommerce, retail, technology, chemical, automotive, pharma and nutrition, logistics, oil & gas, marketing and advertising. My expertise: ++ VBA / VB Macro Development for MS Office Excel, Word, PowerPoint, Access I perform task automation, data manipulation and visualization using VBA, macros, Visual Basic, formulas. * Automate repetitive tasks in Excel and Word ++ QuickBooks Data Import and IIF File Creation I have experience in converting Excel and CSV files into IIF format for importing into QuickBooks. I create Excel VBA programs that can take transaction data from various sources, aggregate and manipulate the data, and generate an iif file for quick, easy upload into QuickBooks, saving a tremendous amount of time spent on manual entries. ++ Power BI Desktop & Power BI Service As an extension to my Excel VBA expertise, I'm also trained in Microsoft Power BI, a powerful tool to analyze, visualize and share data insights and business intelligence. * Build visual and interactive reports * Build interactive dashboards and drill-downs * Connect to variety of external and on-premise data sources including Excel, CSV, databases (Access, SQL, ERP, etc.) * Manipulate data * Schedule data refreshes * Share dashboards, view data on mobile * Query data using natural language and Power query (M) * Create measures using Data Analysis Expressions (DAX)

Skills & Expertise

AnalyticsCreativeCSV (Comma Separated Values)Dashboard DesignData ManagementDatabase DevelopmentDesignEtlImport/Export OperationsLayout DesignMacroMicrosoftMicrosoft ExcelOffice AssistantProgrammingSchedulingSoftware DevelopmentSpreadsheetsVBAVisual BasicVisualisation

0 Reviews

This Freelancer has not received any feedback.