Freelancer logo How It Works Browse Jobs Log In Sign Up Post a Project
EXPLORE
Data Entry Data Processing Excel Excel VBA Visual Basic
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
$25 USD / hour
Flag of PHILIPPINES
pinamalayan, philippines
$25 USD / hour
It's currently 8:20 PM here
Joined August 14, 2020
2 Recommendations

Jian Carlo S.

@jiansevillejo

monthly-level-two.svgpreferred-freelancer-v2.svg
5.0 (96 reviews)
5.6
5.6
$25 USD / hour
Flag of PHILIPPINES
pinamalayan, philippines
$25 USD / hour
100%
Jobs Completed
100%
On Budget
100%
On Time
8%
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 • Google spreadsheet functions • 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 50+ reviews
Filter reviews by: 5.0
$32.00 USD
Great guy, knows his stuff. Very speedy and accurate
Visual Basic Data Processing Excel Mathematics
S
Flag of Waseem S. @shazadw1
22 days ago
5.0
$25.00 AUD
Once again excellent work and totally satisfactory.
Visual Basic Data Processing Data Entry Excel
+1 more
R
Flag of Ron S. @Rons8330
2 months ago
5.0
$45.00 AUD
Excellent communication, fast and to the point. Never needed to explain again. Fast response with updates and always on the meark. It was a real pleasure as I am a sometimes difficult customer due to age and medical issues but this never seemed a bother to him. Will definitely ask his assistance in the future and can recommend him to anyone looking for similar results.
Visual Basic Data Processing Data Entry Accounting Excel
R
Flag of Ron S. @Rons8330
2 months ago
5.0
$20.00 AUD
Jian is an excellent person to work with. He was provided with a highly complex raw data to output simple, meaningful data that are highly valuable to our business. I am already looking forward to working with him on the next data project.
Visual Basic Excel Statistics Data Mining Statistical Analysis
Y
Flag of Yash P. @yashnpb
2 months ago
5.0
$558.00 USD
Perfect work , he amazed me with the way he improved my file Now i can use it easily and do not worry about size I will work with him again Thank you Jian Carlo S
Excel Microsoft Office
D
Flag of Data Entry S. @Data1979
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 97 Data Processing 74 Data Entry 59 Visual Basic 46 Excel VBA 24

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 © 2023 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.