Banner Image

All Services

Programming & Development Programming & Software

Expert Excel formula and VBA developer

$25/hr Starting at $25

Expert Microsoft Excel developer specializing in creation of complex formulas and VBA macros with nine years professional experience.  Projects have included:

* Excel VBA macro to format reports from a project management software to always fit to a single page wide when printed with desired text formatting and color.

* Excel formulas to parse complex data, such as extracting specific cell characters and applying logic based on these extracted values, reformatting dates and numerous nested if, then, else statements each of which performs a different action, extensive use of vlookup

* Excel VBA macro to combine data from separate Excel spreadsheets, performing logic when encountering multiple duplicate entries, and formatting the final output

* Excel VBA macro to compare invoices against a customer spreadsheet based on specific data

* Excel VBA macro to parse hundreds of thousands of rows of data to extract user location contained in this data, throughout more than 300 buildings based on data identifying their location throughout the day

* Excel VBA macro for personal budgeting / debt tracking

* Excel VBA macro to take a raw data spreadsheet and insert multiple columns and custom formulas in each of these columns, parsing existing rows to create actionable data for end of life replacement of roughly 7,000 pieces of distinct hardware across nearly 200 individual model numbers, and taking projections originally only only accurate to 2-3 years into the future and extending these projections to as much as 13 years into the future based on the last three generations of vendor lifecycle support, ultimately specifying which hardware needed to be replaced each fiscal year


Professional Experience Encompasses

* Alamo Community Colleges - 7 years

* Nix Health Care System - 10 years

* HEB - 2 years

* Credit Human (previously SACU) - 2 years

* Alamo Community Colleges (as an instructor) - 15 years

* City of San Antonio - 5 years


About

$25/hr Ongoing

Download Resume

Expert Microsoft Excel developer specializing in creation of complex formulas and VBA macros with nine years professional experience.  Projects have included:

* Excel VBA macro to format reports from a project management software to always fit to a single page wide when printed with desired text formatting and color.

* Excel formulas to parse complex data, such as extracting specific cell characters and applying logic based on these extracted values, reformatting dates and numerous nested if, then, else statements each of which performs a different action, extensive use of vlookup

* Excel VBA macro to combine data from separate Excel spreadsheets, performing logic when encountering multiple duplicate entries, and formatting the final output

* Excel VBA macro to compare invoices against a customer spreadsheet based on specific data

* Excel VBA macro to parse hundreds of thousands of rows of data to extract user location contained in this data, throughout more than 300 buildings based on data identifying their location throughout the day

* Excel VBA macro for personal budgeting / debt tracking

* Excel VBA macro to take a raw data spreadsheet and insert multiple columns and custom formulas in each of these columns, parsing existing rows to create actionable data for end of life replacement of roughly 7,000 pieces of distinct hardware across nearly 200 individual model numbers, and taking projections originally only only accurate to 2-3 years into the future and extending these projections to as much as 13 years into the future based on the last three generations of vendor lifecycle support, ultimately specifying which hardware needed to be replaced each fiscal year


Professional Experience Encompasses

* Alamo Community Colleges - 7 years

* Nix Health Care System - 10 years

* HEB - 2 years

* Credit Human (previously SACU) - 2 years

* Alamo Community Colleges (as an instructor) - 15 years

* City of San Antonio - 5 years


Skills & Expertise

Data ExtractionGeneral / Other Programming & SoftwareMicrosoftProgrammingReportsSpreadsheetsVBA

0 Reviews

This Freelancer has not received any feedback.