Hector M. Profile

5.0

(3 reviews)

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

Error unfollowing user.

You have successfully recommended

Error recommending user.

Something went wrong. Please refresh the page and try again.

Email successfully verified.

$5 USD / hour

guadalajara,

mexico

$5 USD / hour

It's currently 10:55 PM here

Joined December 31, 2015

0 Recommendations

Hector M.

@HectorGmo

5.0

(3 reviews)

1.6

100%

$5 USD / hour

guadalajara,

mexico

$5 USD / hour

100%

Jobs Completed

100%

On Budget

100%

On Time

50%

Repeat Hire Rate

Cutting-edge data analyst, Leading Translator

As for my Data Analysis capabilities, I have , completed Microsoft's Official Academic Course certification (Word, PowerPoint, Excel), and a series of advanced Data Analysis courses; including Microsoft's "Excel for Data Analysis and Visualization", and TU Delft's "Data Analysis: Take it to the Max", that have equipped me -not only with experience working with advanced tools for problem resolution- but also with the necessary skillset for helping you in: + Overcoming data analysis challenges in your work and research + Increasing your productivity and making better business decisions + Enhancing your data analysis capabilities using spreadsheets + Making use of advance spreadsheet possibilities like array formulas and pivottables + Being able to organize and test your spreadsheets in a clean and orderly fashion + Gathering and transforming data from multiple sources + Discovering, exploring, analysing, and combining data for a simple and clear visualization

See all Excel Experts in Mexico

Contact Hector M. about your job

Portfolio

2410897

Translation of 8 page complex legal contract

A returning client wanted to be able to interact with all the data in his speadsheet in a way which would return a monthly ranking of his best sales advisers upon demand, meaning that the month to be analyzed would have to be able to be changed in order to see the rankings of another month of the year.

In order to enable to solve this challenge, data had to be extracted from a wide number of sheets/tabs in the file; formulas such as

=IFERROR(ARRAYFORMULA(SUMIFS(Commissions!C:C,Commissions!A:A,I2,month(left(Commissions!E:E,10)),$O$2,year(left(Commissions!E:E,10)),$O$4)))

=iferror(countifs('Reference sheet (Totals)'!$N$15:N,A2,'Reference sheet (Totals)'!$P$15:P,$O$2,'Reference sheet (Totals)'!$Q$15:Q,$O$4))

..had to be deviced, for it was the case that most of the data was not readily available for its extraction and analysis.

The final dashboard does not only enable the viewer to change the month he wants to request, but he will also be able to analyze other years

Interactive Excel Dashboard for Analysis

$A client needed to perform some calculations regarding a selection o stocks from the US Stock Market through Google Spreadsheets; however, even though Google provides several metrics info through its spreadsheet =GOOGLEFINANCE() feature, my client needed to extract really specific metrics, for example, the \"stock's percentage growth from the last three months\" or the \"date of the lowest price in the last three months\" froma specific stock. I was able to device a number of functions that succesfully achieved that very purpose. For the record, the function for the \"date of the lowest price in the last three months\" function was as follows (using a combination of indexing functions, where B5 contains the name of the stock): =iferror(index(GoogleFinance(B5,\"low\",TODAY()-90,today(),\"daily\"),match(min(index(GoogleFinance(B5,\"low\",TODAY()-90,today(),\"daily\"),,2)),index(GoogleFinance(B5,\"low\&q$