Freelancer logo
How It Works
Browse Jobs
Log In
Sign Up
Post a Project
EXPLORE
Data Entry
Data Processing
Excel
Excel VBA
Visual Basic
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.
Email successfully verified.
User Avatar
$10 USD / hour
Flag of PH
pinamalayan,
philippines
$10 USD / hour
It's currently 1:02 PM here
Joined August 14, 2020
0 Recommendations

Jian Carlo S.

@jiansevillejo

monthly-level-two.svgpreferred-freelancer-v2.svg
5.0 (42 reviews)
5.0 (42 reviews)
4.3
4.3
$10 USD / hour
Flag of PH
pinamalayan,
philippines
$10 USD / hour
100%
Jobs Completed
100%
On Budget
100%
On Time
9%
Repeat Hire Rate

Excel VBA/Data Analyst

Hi, Thank you for visiting my profile. I'm a professional Data Analyst for 5 years. I have strong analytical skills and am very proficient in Microsoft Excel. Skills include creating complex formulas, pivot tables, dynamic graphs and automation processes. I also know Visual Basic coding, which will allow you to automate repetitive tasks. You can send me a message regarding your Excel work. Thanks. Services Offered: • Basic to Complex Excel Formulas • Excel Graphs and Charts • Pivot Tables and Slicers • Interactive Dashboards • PDF file conversions • PowerPoint Presentations • Excel VBA / Macros I’m part of the Planning and BI analyst team from a large company and my job experience helps me a lot to gain more knowledge in my field. It is my hobby to learn new skills and apply it in my daily tasks. When it comes to my client, I always gave my 100% quality service as I know that my work will also reflect on their feedbacks.
Freelancer
Excel Experts
Philippines

Contact Jian Carlo S. about your job

Log in to discuss any details over chat.

Portfolio Items

- Data sorting with the use of Pivot tables, charts, and slicer.
Pivot Tables with Slicer
- Get all unique values by removing duplicates in one click.
Remove Duplicate Macro
- Searchable drop down lists from multiple ComboBox.
ComboBox with Searchable Drop Down List
Distribution graph for employees' performance.
Bell Curve Chart
The user form saves the data for employees who filed their vacation leave.
VBA User Form
Macro for Data Update
Macro for Data Update

Reviews

Changes saved
Showing 1 - 5 out of 42 reviews
Filter reviews by:
5.0
$70.00 NZD
they completed my project and i recieved exactly what i was hoping for. Really satisifed with the work overall. Thank you heaps :)
Data Processing
Accounting
Excel
Charts
Highcharts
R
Flag of NZ Raniya K. @raniikhan
1 month ago
5.0
₹4,300.00 INR
JIan is great to work with. He had my project done in a very short period of time and it was exactly what I needed.
Visual Basic
Data Entry
Excel
Visual Basic for Apps
Microsoft Outlook
User Avatar
Flag of IN Vinay M. @vinaymhatre2
1 month ago
5.0
$40.00 SGD
Very patient freelancer with professionalism. Will definitely work with him again soon!
Data Entry
Excel
Powerpoint
Word
Presentations
User Avatar
Flag of SG Hugh D. @gameon91
1 month ago
5.0
₹1,800.00 INR
Excellent and fast work. Completed in 1 hour my work. Will work again with him.
Data Processing
Data Entry
Excel
Web Scraping
Data Mining
User Avatar
Flag of IN Rashi A. @rgu579640eef05e0
2 months ago
5.0
€20.00 EUR
Jian was fast to do my excel Macro and it worked first try.
Visual Basic
Data Processing
Data Entry
Excel
Web Scraping
A
Flag of SI Anze V. @AngeloVon
2 months ago

Experience

Planning and BI Analyst

Entain
May 2016 - Present
Data Analysis, maintaining quality dashboard and different types of reports like occupancy and absenteeism of employees.

Education

Bachelor's degree

Polytechnic University of the Philippines, Philippines 2005 - 2009
(4 years)

Contact Jian Carlo S. 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 100%

Top Skills

Excel
44
Data Processing
36
Data Entry
31
Visual Basic
21
Excel VBA
10

Browse Similar Freelancers

Excel Experts in Philippines
Excel Experts
Data Processing Executives
Data Entry Clerks

Browse Similar Showcases

Excel
Data Processing
Data Entry
Visual Basic
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 © 2021 Freelancer Technology Pty Limited (ACN 142 189 759)
There is no internet connection
Loading preview