Kevin O.
Delray Beach, United States
100%
Job Success
Top Rated Plus
IT Professional and Excel Expert
$100.00/hr
IT professional with 23 years of experience implementing software solutions for clients prior to becoming a freelancer. In my career I have worked in all phases of the software development life cycle (SDLC). I'm a problem solver with good communication skills. I have worked with clients at all levels. I bring this wealth of experience to my Upwork clients to effectively and efficiently deliver spreadsheet-based solutions to improve their business processes and save them time.
Areas of proficiency and experience:
- Complex Formulas (including Array Functions)
- Advanced Lookup (including lookup on multiple values/fields)
- Dashboards and Data Visualization
- Power Query / Data Transformation and Loading
- Complex Conditional Formatting
- Performance Tuning
- Data Validation
- Tables and Pivot Tables
- Charts
- VBA/Macros
- User Forms / Input Parameters
- Helper Columns
Notable Projects:
- Automated payroll processing
- Dashboards of varying complexity
- Data analysis and survey charting
- Stock Market Portfolio/Trade tracking (including equities, options, and futures)
- Fulfillment/Sales/Inventory (e.g. amazon)
- Modeling
- Investment Performance and Trade Tracking/Reporting
- Monte Carlo Simulation
- Estimation/Invoices
I am now freelancing exclusively and look forward to the opportunity to work with you.
Work history
Work history
Develop Estimate Spreadsheet
Feb 17, 2023
-
Jan 17, 2025
5.00
Private earnings
Pdf list to excel
Jan 7, 2025
-
Jan 12, 2025
4.80
Private earnings
Excel Macro Advisement
Feb 8, 2024
-
Oct 29, 2024
5.00
"Working with Kevin was phenomenal. I would highly recommend!"
Private earnings
Excel formula to calc payroll off of a lookup table and a macro to summarize each in a master sheet
Jun 17, 2019
-
Aug 6, 2024
No feedback given
Private earnings
Excel project- Take existing pricing spreadsheet and output to create contract.
Nov 8, 2023
-
May 6, 2024
5.00
Private earnings
30 minute consultation
Apr 16, 2024
-
Apr 18, 2024
5.00
Private earnings
Update Excel tracking model
Nov 8, 2019
-
Mar 19, 2024
5.00
Private earnings
Invoice Upgrade/Optimization
Sep 8, 2023
-
Feb 20, 2024
5.00
Private earnings
30 minute consultation
Jan 6, 2024
-
Jan 6, 2024
No feedback given
Private earnings
Excel Spreadsheet Optimization (Scraper)
Mar 20, 2023
-
May 17, 2023
5.00
"Kevin's work output is thorough, precise and reflects the years of experience with excel, very masterful with formulas and data modeling offering easier excel automation modelling. Kevin is a ninja…
Private earnings
Misc Excel Consulting
Aug 8, 2024
-
Present
Job in progress
Private earnings
Misc Excel Assistance/Charts
Jun 28, 2024
-
Present
Job in progress
Private earnings
1st Revision of pricing module for swimming pools
Jun 26, 2024
-
Present
Job in progress
Private earnings
Excel Work for Medical Practice
Jun 4, 2024
-
Present
Job in progress
Private earnings
Excel Financial Model
May 29, 2024
-
Present
Job in progress
Private earnings
Cabinet Sales Metrics/Dashboard
Apr 18, 2024
-
Present
Job in progress
Private earnings
Excel Spreadsheet Analytics
Mar 18, 2024
-
Present
Job in progress
Private earnings
Excel Macro Advisement/Development 2
Feb 9, 2024
-
Present
Job in progress
Private earnings
Microsoft Excel formula guru needed!
Nov 8, 2023
-
Present
Job in progress
Private earnings
Process Automation in Excel
Sep 1, 2023
-
Present
Job in progress
Private earnings
Kevin O. has more jobs. Create an account to review them
Skills
Skills
- Microsoft Excel
- Spreadsheet Software
- Requirement Analysis
- Visual Basic for Applications