Freelancer logo
Log In Sign Up
Post a Project

EXPLORE

Data Processing Excel Excel Macros Excel VB Capabilities Python
Profile cover photo
User Avatar

Viswanathan R.

@edatawiz

5.0
44

5.4

5.4

98%

Data Enthusiast: Excel | Python | Data Automation

$20 USD / Hour

・

Flag of

India (10:20 AM)

・

Joined on March 29, 2008

$20 USD / Hour

・

Welcome to my portfolio! I'm Vishy, also known as Viswa, a seasoned Excel and Data Automation Specialist. My expertise includes: • Automating Excel tasks and designing sophisticated Dashboards. • Tailoring Google Sheets and dashboards to meet your specific needs. • Harnessing the power of Python alongside BS4, Requests, and Selenium for Web Scraping. • Integrating Python for General Scripting to optimize your data workflows seamlessly. Through my engagement with communities and utilization of AI technology, I've honed my professional capabilities significantly. I remain committed to ongoing improvement, consistently exploring new avenues for advancement and innovation. I'm ready to enhance your data workflow and help you unlock the full potential of your data. Let's collaborate to turn your data challenges into opportunities for success. Have a wonderful day !

Verifications

On time

100%

On budget

100%

Accept rate

100%

Repeat hire rate

15%

Freelancer Excel Experts India
See all Excel Experts in India

Portfolio

Portfolio

11681806
Quick Dashboard using Google Sheets new formulas, Charts and Pivots Note: This is only a sample data to show how it would look. The number and count may vary with actual figures.

Sales Processing ! Google Sheets

11681802
Features: One for daily claim uploads: A macro will run and examine about 19 columns to see if they require any updating. If so, it will log the updates and update them to a different page with the claims number so that it can be verified at all times. Will add to the consolidated sheet if the claim is not present. Claims that do not match will be deleted from the combined sheet. Extra options: Data validation and drop-down menus are included to prevent errors during human entry. Every item will be tagged according to specific criteria, and the comment section will be updated by formulae and macros with the appropriate steps to finish the process. Dashboard: There will be a summary of the claims that are pending and ongoing. Here is an example screenshot (the number will display dummy values because this is only an example).

Claim Management System

10959667
A performance dashboard for project management was the goal of the project. To create a real-time update to the summary, Excel macros, pivot tables, and pivot charts are all employed. To visualize the development, key metrics like Actual Vs. Expected completion and Yet to Recover Vs. Revenue are displayed on a trend line chart.

Project Performance Dashboard

10916496
This VBA takes as input a folder containing all of the csv files that record the delivery of data for each day, then computes a ratio for the month Max to Min, and then plots the results on a graphs. You can compare two symbols also. The drop-down, charts are automatically populated. Attached is a sample screenshot.

Portfolio Comparison and Analysis

10822896
The project was to automate the creation of serial number based on inputs. The Excel sheet had to be automated using Forms to avoid manual errors and to speed up the process.

Excel Form - Serial Number Automation

10769734
A sample sales dashboard covering key parameters to be measured.

Sample Quick Sales Dashboard

11681806
Quick Dashboard using Google Sheets new formulas, Charts and Pivots Note: This is only a sample data to show how it would look. The number and count may vary with actual figures.

Sales Processing ! Google Sheets

11681802
Features: One for daily claim uploads: A macro will run and examine about 19 columns to see if they require any updating. If so, it will log the updates and update them to a different page with the claims number so that it can be verified at all times. Will add to the consolidated sheet if the claim is not present. Claims that do not match will be deleted from the combined sheet. Extra options: Data validation and drop-down menus are included to prevent errors during human entry. Every item will be tagged according to specific criteria, and the comment section will be updated by formulae and macros with the appropriate steps to finish the process. Dashboard: There will be a summary of the claims that are pending and ongoing. Here is an example screenshot (the number will display dummy values because this is only an example).

Claim Management System

10959667
A performance dashboard for project management was the goal of the project. To create a real-time update to the summary, Excel macros, pivot tables, and pivot charts are all employed. To visualize the development, key metrics like Actual Vs. Expected completion and Yet to Recover Vs. Revenue are displayed on a trend line chart.

Project Performance Dashboard

10916496
This VBA takes as input a folder containing all of the csv files that record the delivery of data for each day, then computes a ratio for the month Max to Min, and then plots the results on a graphs. You can compare two symbols also. The drop-down, charts are automatically populated. Attached is a sample screenshot.

Portfolio Comparison and Analysis

10822896
The project was to automate the creation of serial number based on inputs. The Excel sheet had to be automated using Forms to avoid manual errors and to speed up the process.

Excel Form - Serial Number Automation

10769734
A sample sales dashboard covering key parameters to be measured.

Sample Quick Sales Dashboard

5.0 · 44 Reviews
Reviews
User Avatar

Excel Dashboard -- 2 • ₹1,500 INR

It was a pleasure to work with Vishwanathan and a smooth experience. He was proactive in both execution and thought process and worked well basis high level scope shared. He also was open to incorporating feedback and change requests at a short notice.

Praveen K.

@pkumar0080

•

Flag of

, India

•

3 years ago

Share

L

Google sheet expert with formulas for basic project • $70 USD

The guy went beyond the scope Definitely hire him again

Edgar S.

@Lvtn2099

•

Flag of

Mexico, Mexico

•

3 years ago

Share

User Avatar

CORRECTION_SHEET_GENERATOR • ₹600 INR

He delivered the my task before time and his coordination is outstanding. He is one of the best freelancer i have worked with till now.

Shuvam D.

@Shuvam9

•

Flag of

Kolkata, India

•

3 years ago

Share

A

Power BI Pro • $10 NZD

Really good what he do.

Amit S.

@ammyshro1495

•

Flag of

Hamilton, New Zealand

•

3 years ago

Share

User Avatar

Help with a formula. • £12.40 GBP

Viswanathan solved my problem really quickly. His responses were fast and professional. Will definitely go back to him directly next time I need help with a formula. Recommended.

Avraam G.

@makisgeorgiadis

•

Flag of

London, United Kingdom

•

3 years ago

Share

Certifications

US English - Level 1

US English

E

Employer Orientation Exam

G

General Orientation Exam

Freelancer logo US (International) / English
Help & Support

Freelancer

Categories Projects Contests Freelancers Enterprise Innovation Challenges AI Development Membership Preferred Freelancer Program Project Management Local Jobs Photo Anywhere Showcase API for Developers Get Verified

About

About us How it Works Security Investor Sitemap Stories News Team Awards Press Releases Careers

Terms

Privacy Policy Terms and Conditions Copyright Policy Code of Conduct Fees and Charges

Partners

Escrow.com Loadshift Warrior Forum

Apps

Apple App Store logoGoogle Play logo

Registered Users

Total Jobs Posted

Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)

Copyright © 2025 Freelancer Technology Pty Limited (ACN 142 189 759)