Banner Image

Skills

  • Data Analysis
  • Conditional Formatting
  • Data Transformation
  • Excel Spreadsheet Automation
  • Power Query
  • Business Intelligence
  • Data Validation
  • Excel Advanced Formulas
  • Excel Automation
  • Excel Data Visualization
  • Excel Expert
  • Excel Pivot Tables
  • Excel Template Design
  • Microsoft Excel Dashboards
  • Data Engineering

Sign up or Log in to see more.

Services

  • Excel Dashboards & Data Visualization

    $40/hr Starting at $120 Ongoing

    Dedicated Resource

    As a MSFT Certified Excel Expert with 20+ years of experience in Excel, I can help you to stop digging through rows of messy data for business insights. I transform your complex spreadsheets into dynamic,...

    Advanced Excel FiltersBusiness InsightsBusiness IntelligenceConditional FormattingDashboard Design
  • Excel Templates & Data Engineering

    $40/hr Starting at $80 Ongoing

    Dedicated Resource

    As a MSFT Certified Excel Expert with 20+ years of experience in Excel, let me help you turn your manual spreadsheets into automated workflows and actionable insights. I build "plug-and-play" Excel templates...

    Advanced Data AnalyticsAdvanced Excel FiltersBusiness InsightsBusiness IntelligenceConditional Formatting
  • Excel Automation & Data Transformation

    $40/hr Starting at $40 Ongoing

    Dedicated Resource

    As a MSFT Certified Excel Expert with 20+ years of experience in Excel, let me help you reclaim your time from manual Excel "grunt work." I build robust, automated engines that transform messy exports...

    Advanced Excel FiltersBusiness InsightsBusiness IntelligenceConditional FormattingData Analysis

About

I build precision Excel automation, interactive dashboards, and custom templates as a MSFT Certified Excel Expert with 20+ years experience.

Welcome to my profile! I am new to Guru, but not new to delivering robust, scalable Excel-based solutions.
▬▬▬ EXPERTISE & QUALIFICATIONS ▬▬▬
I am a Microsoft Certified Excel Expert (MO-211) with over 20 years of Excel experience implementing complex automation logic and specialized data models, implementing complex automation logic and specialized data models. Having spent 15 years at Fortune 500 companies—Fidelity Investments, Citigroup, and AT&T—I bring a level of precision, logic, and data integrity that is rare in the freelance market.
▬▬▬ EXPERTISE YOU CAN LEVERAGE ▬▬▬
► Interactive Dashboards & Visualization: Transforming raw, messy data into dynamic, visual summaries for instant business insights.
► Custom Template Design: Building 'plug-and-play' workbooks that allow you to paste raw data and receive instant, professional-grade insights.
► Power Query & Data Transformation: Implementing custom-built, advanced automation to clean messy data from exports for seamless analysis.
► Advanced Data Modeling: Using advanced skills to create sophisticated Pivot Tables, Pivot Charts, and multi-layered data summaries.
► User-Friendly Macros (Non-VBA): Skilled at creating easy-to-use macros with user-friendly form control to easily complete repeatable tasks.
► Complex Formula Engineering: Expert-level mastery of logic-based formulas (XLOOKUP, VLOOKUP, INDEX / MATCH) and Dynamic Arrays (FILTER, UNIQUE, SORTBY) to automate manual workflows.
▬▬▬ DATA INTEGRITY MEETS CYBERSECURITY ▬▬▬
Unique to my service is my background as a Certified Information Systems Security Professional (CISSP). In an era of increasing data breaches, I specialize in the KPIs/KRIs for Cybersecurity and Risk Metrics. When I build a solution for you, I’m not just thinking about formulas—I’m thinking about the security and reliability of your information.
▬▬▬ PROFESSIONAL STANDARD ▬▬▬
Every project is performed with:
✓ Highest standard of quality
✓ Keen eye for detail
✓ Focus on scalability
✓ Highly effective communication
▬▬▬ SATISFACTION GUARANTEE ▬▬▬
My #1 goal is always your 100% satisfaction. I am not finished until the solution works perfectly for your specific needs and you are completely confident in the results.
▬▬▬ READY TO CHAT TODAY▬▬▬
Ready for a customized Excel solution? Click "Get a Quote" to discuss your project today.

Work Terms

1. BUSINESS HOURS: Mon-Fri, 8 AM–5 PM CST
2. COMMUNICATION & PROJECT ALIGNMENT
• RESPONSE TIME: Within 24 business hours
• PLATFORM: Guru’s tools are used for all communication
• INTRO MEETING: Prior to finalizing a Work Agreement, to ensure project alignment, I require a 10–15 min video/audio meeting
• PROJECT RECORD: All development is based on the Work Agreement and the clarifications/approvals documented in Workroom (see Sec 4 for handling of Change Orders/Revisions)
3. SAFEPAY & MILESTONES–Guru SafePay is exclusively used
• FIXED-PRICE: Work begins once the milestone is fully funded
• HOURLY: Minimum SafePay balance (1 week of "Max Hours") required to secure work and enable AutoPay
4. UAT & REVISIONS–I utilize an iterative UAT process
• UAT: During development, I provide locked workbooks for UAT to ensure source code is protected
• IN-SCOPE REVISIONS: 2 minor revisions (aesthetics, labels, variables) are allowed during the UAT phase
• CHANGE ORDERS: New features, or structural logic changes requested after work begins, require a separate milestone
• APPROVAL: UAT approval signifies the file meets all functional requirements
5.DELIVERY & VALIDATION
• VALIDATION PHASE: To ensure logic integrity, I deliver a functional, locked version for validation
o VALIDATION PHASE ENDS upon payment release OR 7 days–whichever comes first
o RUNS PARALLEL with Guru 7-Day AutoPay Grace Period
• INTEGRITY GUARANTEE: Locking the file during validation ensures any bugs are logic-based, not caused by user modification
• RESET PROTOCOL: If a functional bug is found, I will fix it and re-issue the invoice to restart validation window
6. Unlocked File & Privacy
• OWNERSHIP: Upon payment release, I provide means to completely unlock file and 100% ownership of file is client's
• PRIVACY: I treat all client data as proprietary and sign NDAs as needed
• RETAINED RIGHTS: I retain the right to reuse my Excel-based formulas, logic, and all other Excel-based methods