Excel Mantra

Excel, Data Analysis, Management Reporting, VBA Automation (MACROS)

Overview

Excel VBA and Analytics Am an expert on Microsoft Excel and VBA with more than 12 years of professional experience. I have delivered various projects related to Microsoft Excel such as Analytics, Dashboards, Excel Macros and VBA Automation Projects. I specialize in VBA Coding and automation projects. A specialized custom menu for each project I delivered is one of the USPs most liked by my past clients. Excel based reporting and Analytics comes natural to me. I follow Stephen Few's methodologies for professional reporting Dashboards. Data Visualization - Tableau, Alteryx, PowerBI, SQL and Google Data Studio Using the tools I have delivered projects related to data modeling, visualization and complex management dashboards. Have also delivered projects related to data reconciliations using custom SQL logics in Alteryx. Am pretty versed with data blending in Google Data Studio where multiple sources were required to be clubbed and represented as Dashboard Stories. Google Sheets and AppScript Have delivered projects involving Google Sheet as the final data storage app and fetching details from external sources either by API connection or by data import features. In such projects, java based Google AppScript is used to interact with the external source and fetch data. These AppScript containers can be scheduled to run at a given time and execute automatically removing the need of human/manual intervention. Languages & Framework: VBA, VB 6.0 Desktop Software, vb.net, JAVA, Google AppScript Reporting: Excel, Tableau, Alteryx, Power BI, SQL, Google Data Studio, and Access

Read more

Services

Data Visualization

You want to display huge data into meaningful reports? I can create Corporate Standard Dashboards, MIS and Reporting systems both Offline and Online systems Tools am proficient at are: - R-Programming - Python - Google Data Studio - Google Analytics - Microsoft Excel and Microsoft Access

Data Extraction/ETL
Scripts & Utilities
100% Job Success

To discuss your project with Excel Mantra, sign up.

We'll connect you two when your project is posted.

or

Upwork activity

Hourly rate

$8.00 - $30.00

Total earned

$20K+

Total hours

890

Total jobs

46

Member since

Nov 5, 2013

Company information

Agency size

1 worker

Year founded

2013

Client focus

Large business

Medium business

Very small business

Small business

Languages

English: Fluent
Hindi: Native or Bilingual