Freelancer logo How It Works Browse Jobs Log In Sign Up Post a Project
EXPLORE
Data Processing Excel Hindi Translator Visual Basic Visual Basic for Apps
Profile cover photoundefined
You're now following .
Error following user.
This user does not allow users to follow them.
You are already following this user.
Your membership plan only allows 0 follows. Upgrade here.
Successfully unfollowed user.
Error unfollowing user.
You have successfully recommended
Error recommending user.
Something went wrong. Please refresh the page and try again.
Email successfully verified.
User Avatar
$20 USD / hour
Flag of INDIA
darri, india
$20 USD / hour
It's currently 7:47 AM here
Joined November 12, 2012
8 Recommendations

Virendra Singh B.

@vsprybhanu

monthly-level-two.svgpreferred-freelancer-v2.svg
4.8 (154 reviews)
6.1
6.1
$20 USD / hour
Flag of INDIA
darri, india
$20 USD / hour
96%
Jobs Completed
97%
On Budget
88%
On Time
15%
Repeat Hire Rate

Excel VBA Macro Developer, VB6 & Python Programmer

Welcome to my profile. I provide world class Data Analysis Services with Excel VBA Macro. Excel has various functions and commands that can be customized with VBA programming (Macro). I can customize all functions of excel and make it very useful for your business. Some important features of Excel that can be automated- Split any large string into fields, Manipulate rows and columns, Data Exchange to Word, Access, SQL and MySQL server, Conditional formatting, Sorting, Find and Replace, Creating userform. I can also customize MS Word features through Macro- Mail Merge with Excel/CSV, Access, SQL and MySQL server database, Manipulate docs, Exchange data between word and excel. So, I can provide Macros to automate that work which is tedious and time taking. I always give close attention to project description and ask some question for clarification and set final goal, then start the work. I maintain good communication with client and give timely update.
Freelancer Visual Basic Developers India

Contact Virendra Singh B. about your job

Log in to discuss any details over chat.

Portfolio Items

I created Excel VBA Program to search specific Barcode in excel file and print searched record as Label (width 65mm, height 29mm) with Barcode in Brother QL570 label printer.
Label Printing in Visual Basic
Client had Dashboard where all data was calculated with Formulas and she wants to replace all the Formulas with VBA Programming. So, she needs an Excel VBA Program that can replace all formulas and give correct result. I have created VBA Program to fulfill this requirement of my client and she is very satisfied with my work.
Dashboard with Excel VBA
This program will create custom mail merge with MySQL and Excel Database. It is MS Word VBA Macro in Add-Ins format. So, you can add it into your Word ribbon and use like a standard MS Word Command. I use Visual Basic program to create this Macro.
Mail Merge with MySQL and Excel
This program will create custom mail merge with MySQL and Excel Database. It is MS Word VBA Macro in Add-Ins format. So, you can add it into your Word ribbon and use like a standard MS Word Command. I use Visual Basic program to create this Macro.
Mail Merge with MySQL and Excel
Its a VBA Program for mathematical calculation of trading. All windows elements are used in this program. For example - Text boxes, Drop Down, Option, Command Buttons etc.
Mathematical Calculation
Client had requirement to apply formulas into various locations to automate the work, exchanging data between sheets, using drop down box, validation and conditional formatting. I have done all these things by Excel VBA programming.
Excel spreadsheet
Background:
I run a small retail business and I would like to better understand my sales performance and trends.  I am able to export a .csv file from my point-of-sale system which contains a portion of sales data.  The attached orders.csv file contains some data from January 2015 through mid-March 2015.  

Rquirements:
I would like to have an Excel spreadsheet which would allow me to import these .csv data files into a single “Sales” sheet on an occasional basis (likely once per month).  I would then like a “Summary” sheet which presents some key performance indicators in both data table and chart form. 

NOTE: While it would be neat to do so, I do not need to track Product Code; however, you will notice in the orders.csv file that there is often more than one row per order number (see row 3 and row 4).  This happens when a customer orders more than one product type.  For my purpose I need to combine those records into one and simply enter the total quantity sold amongst all products
Creating Dashboard in Excel VBA

Reviews

Changes saved
Showing 1 - 5 out of 50+ reviews
Filter reviews by: 5.0
$240.00 USD
He has a lot experience ,i will work with him in the future.
Visual Basic Excel Visual Basic for Apps JSON Web API
X
Flag of Mooseok S. @xcpjmss
18 days ago
5.0
₹11,000.00 INR
Virendra has a habit of exceeding expectations.. Very humble very calm and so easy to work with..
Mobile App Development MySQL Pinterest Social Media Marketing
+1 more
M
Flag of Kunal S. @MTRND
1 month ago
5.0
₹2,000.00 INR
Highly recommended!!
Mobile App Development MySQL Pinterest Social Media Marketing
+1 more
M
Flag of Kunal S. @MTRND
1 month ago
5.0
$30.00 USD
Amazing guy. great communication and highest quality work
Facebook Marketing Google Plus Digital Marketing Marketing Strategy
+1 more
S
Flag of Waseem S. @shazadw1
1 month ago
5.0
$50.00 USD
Great work once again, just amazing. Definitely use again
Data Processing Excel Visual Basic for Apps VB.NET
S
Flag of Waseem S. @shazadw1
2 months ago

Experience

English to Hindi translation and Social Media Marketing

WENDS (UK)
Jul 2017 - Nov 2018 (1 year, 4 months)
I was working on this company as a translator. The company used to give me content in English and I used to translate it into Hindi. After the translation, I used to post the translated Hindi content in the company's Facebook and Twitter accounts.

Developing Work Management And Payroll System

UNICOAST (USA)
Sep 2015 - Sep 2016 (1 year)
I have developed a complete system to maintain work, employee and payroll system for a company UNICOAST. The system is developed by using Excel VBA Programming. I used all windows elements like Drop Down, Text Boxes, Command Buttons etc. to make the system user friendly. It has also ability to create pdf report and send Email through Outlook.

Education

MA

Guru Ghasidas University, India 2012 - 2013
(1 year)

Qualifications

The Fundamentals of Digital Marketing

Google Digital Garage
2020
The Fundamentals of Digital Marketing exam by Google Digital Garage.

Hardware and Networking

Govt.of India, Ministry of Small Scale Industries, Small Industries Development Organization, Raipur, Chhattisgarh, India
2004
I learned during this training - Computer Architecture, Computer Fundamentals, Various Basic and Peripheral parts of Computer, Trouble Shooting, Networking Concepts, TCP IP, Bus Networking, Star Networking, P2P Networking etc.

Business Professional Programmer

DOEACC Society, New Delhi India
2003
One year Computer Course from DOEACC Society New Delhi, India. In this Course I learned Advanced PC Software - MS-Word, Excel, PowerPoint, Access, Windows Operating System and Programming Languages - Visual Basic, FoxPro etc. DOEACC Society is an autonomous body of Department of Information Technology, Ministry of Communication and Information Technology, Govt of India for accreditation of Computer Courses under the AICTE-DIT Scheme.

Contact Virendra Singh B. about your job

Log in to discuss any details over chat.

Verifications

Preferred Freelancer
Identity Verified
Payment Verified
Phone Verified
Email Verified
Facebook Connected

Certifications

preferredfreelancer-1.png Preferred Freelancer Program SLA 1 89% numeracy_1.png Basic Numeracy 1 88% freelancer_orientation.png Freelancer Orientation 1 80% vb6-1.png VB6 Programming 1 80% vb1.png VB.NET 1 77%

Top Skills

Visual Basic 113 Excel 113 Data Processing 63 Visual Basic for Apps 46 Hindi Translator 19

Browse Similar Freelancers

Visual Basic Developers in India
Visual Basic Developers
Excel Experts
Data Processing Executives

Browse Similar Showcases

Visual Basic
Excel
Data Processing
Visual Basic for Apps
Previous User
Next User
Invite sent successfully!
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2022 Freelancer Technology Pty Limited (ACN 142 189 759)
There is no internet connection
Loading preview