Freelancer logo How It Works Browse Jobs Log In Sign Up Post a Project 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.
Email successfully verified.
User Avatar
$20 USD / hour
Flag of PHILIPPINES
muntinlupa, philippines
$20 USD / hour
It's currently 7:29 PM here
Joined August 14, 2017
22 Recommendations

Aubrey F.

@aubrey03

monthly-level-three.svgpreferred-freelancer-v2.svg
4.9 (253 reviews)
7.1
7.1
$20 USD / hour
Flag of PHILIPPINES
muntinlupa, philippines
$20 USD / hour
100%
Jobs Completed
95%
On Budget
97%
On Time
21%
Repeat Hire Rate

Excel / VBA Expert | Data Analysis & Visualization

My specialization is spreadsheet automation using Excel VBA or Google scripts. I also have vast experience in data analysis, creating dynamic dashboards/data visualization in Google data studio, Excel, and Google sheets. I love solving problems. I take pride every time I am able to turn a very tedious work into a more efficient process. In one of my previous jobs, I have worked with a team of data analysts that monitors a huge volume of revenue data. The team's daily activity is so repetitive and time-consuming. We needed to download, combine, cleanse hundreds of CSV files before we could actually start analyzing the data. I improved this process by creating a macro-enabled Excel file that could automatically download, process, and aggregate data in a dynamic dashboard. This dashboard made data monitoring easier because it shows and highlights trends and inconsistent patterns. I am always looking for challenges and other work opportunities, if you want to work with me, feel free to send me a message.
Freelancer Excel Experts Philippines

Contact Aubrey F. about your job

Log in to discuss any details over chat.

Portfolio Items

An Excel database that has a data entry userform with edit and search functions. It also includes a report / dashboard for monitoring purposes.
Excel Database
A dynamic sales monitoring dashboard created in Google Data Studio. Data source is from a Google sheet with advance formulas used to summarize the data.
Sales Dashboard
MS Access relational database that can be used for case monitoring purposes. It includes auto save, report generation, edit and search functions.
Case Monitoring Database
A macro enabled Excel file using SeleniumBasic reference library to manipulate a web browser to go to a web form and fill it up using data coming from Excel rows
Excel to Web Form
A dynamic dashboard in Google sheets which can be use to monitor the company profits and losses. Graphs are dynamic and are filtered using Google query function.
P & L Dashboard in Google Sheets
This is an Excel form I created for a Quality Assurance Team. This file is full of complex Excel formulas used to generate QA scores and ratings.
Quality Assurance form

Reviews

Changes saved
Showing 1 - 5 out of 50+ reviews
Filter reviews by: 5.0
$100.00 USD
Got my issues resolved quickly and understood my requirements.
PHP Visual Basic Data Processing Excel Microsoft Access
User Avatar
Flag of Hector G. @Licensedsports
2 months ago
5.0
$183.00 AUD
Easy to work with and got the job done very quickly!
Visual Basic Data Processing Data Entry Excel
+1 more
M
Flag of Mark C. @maxeus
3 months ago
5.0
$500.00 AUD
Great Communication, Passionate and willing to try anything... investigates to find the best way to achieve good outcomes. Will continue to work with Aubrey.
Tableau Business Intelligence Power BI
B
Flag of Nick B. @bakerfm
4 months ago
5.0
$300.00 AUD
Has delivered a very complex job on time and on budget, excellent skill set. If anyone is looking for a very talented guy this is one who I would use
Data Processing Project Management Data Entry Excel Microsoft Project
L
Flag of Steve S. @LuxHomesQLd
4 months ago
5.0
$200.00 AUD
Aubrey is great to work with. Quick turn around and high quality of work.Highly recommend!
Visual Basic Data Processing Data Entry Excel Software Architecture
K
Flag of Mikolaj E. @kozey
5 months ago

Experience

DATA ANALYSIS OFFICER

Comfac Corporation / GlobalComRCI
Nov 2017 - Present
Monitor data collection by the audit platform, gather data, analyze and report anomalous or suspicious data, and consolidate data gathered every end of day.

SHIFT MANAGER

Paragon International Customer Care Ltd.
Jun 2008 - Jan 2017 (8 years, 7 months)
Responsible for all operations during a shift which includes ensuring that the service provided to customers meets the established standards of quality including reliability and information accuracy.

Education

Associate in Computer Technology

Philippines 2003 - 2005
(2 years)

Contact Aubrey F. 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 97% us_eng_1.png US English 1 92%

Top Skills

Excel 254 Visual Basic 170 Data Entry 136 Data Processing 132 Excel VBA 91

Browse Similar Freelancers

Excel Experts in Philippines
Excel Experts
Visual Basic Developers
Data Entry Clerks

Browse Similar Showcases

Excel
Visual Basic
Data Entry
Data Processing
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