01
Excel, VBA & Macros
Advanced formulas, VBA macros, Power Query, PivotTables, and Excel automation that removes repetitive manual work.
Data & Sheet Specialist · Excel Expert
LoveThisLife
Christina Jaramillo
We help businesses turn messy spreadsheets, repetitive data work, and manual processes into clean, accurate, automated systems.
Messy data to systems.
One specialist team.
Our team handles everything from straightforward data entry, web research, Excel formatting, and Google Sheets work to advanced VBA macros, Power Query, dashboards, reporting, and workflow automation.
From PDF-to-Excel conversions and CRM cleanups to Power BI dashboards and Zapier or n8n pipelines—we build spreadsheet systems that stay accurate, reusable, and easy to run.
Services
What we help with
Five focused lanes—each revealed as you scroll. Full capabilities below.
02
Google Sheets & Smartsheet
Collaborative sheets, Apps Script automation, Smartsheet setup, and shared workbooks built for teams.
03
Data Entry, Cleaning & Migration
Accurate entry, cleanup, PDF/CSV conversion, CRM data management, and reliable migrations between systems.
04
Power BI & Dashboards
Interactive dashboards, KPI scorecards, automated reports, and clear data visualization for decisions.
05
Automation & Integrations
Power Automate, Zapier, n8n, API connections, and recurring workflows that keep data moving without busywork.
Capabilities
Skills & tools
Deep Excel expertise. Broad coverage across sheets, automation, reporting, and data ops.
Microsoft Excel Expert
- Microsoft Excel (advanced)
- VBA macros & Excel automation
- Advanced formulas & dynamic arrays
- XLOOKUP, INDEX/MATCH, SUMPRODUCT
- Power Query & data models
- PivotTables & Power Pivot / DAX
- Conditional formatting & data validation
- Charts, sparklines & scorecards
- Goal Seek, Solver & what-if analysis
- Office Scripts & Excel Online
- Workbook auditing & protection
- Financial modeling & forecasting
Google Sheets & Smartsheet
- Google Sheets expert builds
- Google Apps Script automation
- Smartsheet setup & management
- QUERY, FILTER & ARRAYFORMULA
- IMPORTRANGE & multi-sheet systems
- Google Forms → Sheets pipelines
- Named ranges & structured tables
- Collaborative permissions & workflows
- Conditional formatting & validation
- Looker Studio / Data Studio links
Data Entry, Cleaning & Processing
- Data entry & bulk processing
- Data cleaning & deduplication
- PDF to Excel conversion
- CSV / TSV import & export
- Text to Columns, Flash Fill & fuzzy match
- OCR & document data extraction
- Data migration & consolidation
- CRM data management & hygiene
- Web research & data collection
- Quality checks & error auditing
- Mail merge & list preparation
- Inventory & operations trackers
Automation & Scripting
- VBA macros & custom functions
- Google Apps Script
- Power Automate flows
- Zapier & n8n workflows
- API integration & webhooks
- Scheduled & recurring reports
- Email & notification automation
- Multi-workbook consolidation scripts
- Template-driven report engines
- Error handling & logging
Dashboards & Visualization
- Power BI & interactive dashboards
- Excel dashboard design
- PivotCharts & KPI scorecards
- Data visualization best practices
- Automated reporting packs
- Executive summary decks from data
- Refreshable / live report systems
- Chart storytelling for stakeholders
Integrations, SQL & Ops
- SQL for data pulls & joins
- API & third-party integrations
- CRM sync (HubSpot, Salesforce & more)
- SharePoint / OneDrive pipelines
- Airtable & Microsoft Lists
- Database import / export
- ETL-lite spreadsheet pipelines
- Documentation, SOPs & training
- Version control for workbooks
- Microsoft 365 collaboration
Selected work
Projects in the wild
Spreadsheets, automation, dashboards, and data ops—with the outcomes behind each engagement.
VBA automation for monthly ops reporting
Rebuilt a fragile multi-file Excel process into one workbook with macros, Power Query refreshes, and one-click report export—so the ops team stopped copy-pasting every month.
- Excel
- VBA
- Power Query
- Macros
- Automation
CRM export cleanup & data migration
Deduplicated contacts, standardized fields, fixed encoding issues, and mapped CSV exports into a clean import file—ready for CRM reload with validation checks and an audit log.
- Data cleaning
- CSV
- CRM
- Migration
- QA
Power BI KPI dashboard for leadership
Connected sales and ops sources into an interactive Power BI dashboard—filters, trend charts, and scorecards that refresh without rebuilding slides every week.
- Power BI
- DAX
- Visualization
- KPIs
- Reporting
Sheets inventory system with Apps Script
Designed a shared Google Sheets inventory and order tracker with validation, dashboards, and Apps Script alerts when stock thresholds or deadlines were hit.
- Google Sheets
- Apps Script
- Automation
- Forms
- Alerts
PDF & CSV to Excel conversion pipeline
Converted invoices, statements, and legacy PDFs into structured Excel tables—normalized columns, dates, and currencies so finance could filter, pivot, and reconcile fast.
- PDF to Excel
- CSV
- Data entry
- Formatting
- Excel
End-to-end data workflow automation
Wired form submissions into Sheets/Excel, CRM updates, and Slack or email alerts using Zapier, n8n, and Power Automate—so intake no longer depended on copy-paste.
- Zapier
- n8n
- Power Automate
- API
- CRM
How we work
Messy to automated
01
Assess
-
01
Assess
Review your spreadsheets, sources, and bottlenecks. Map what is manual today and what should become a reliable system.
-
02
Clean
Normalize fields, fix errors, structure tables, and set validation so the data is accurate before anything is automated.
-
03
Automate
Build formulas, macros, queries, dashboards, and workflows—Excel, Sheets, Power BI, Zapier, n8n, or Power Automate as needed.
-
04
Hand off
Document the system, train your team, and leave templates or SOPs so reports and updates keep running without us in every file.
About
Christina Jaramillo
Founder, LoveThisLife · Data & Sheet Specialist · Excel Expert
We help businesses turn messy spreadsheets, repetitive data work, and manual processes into clean, accurate, automated systems—with clear communication and follow-through on every engagement.
From data entry and web research to VBA, Power Query, dashboards, and workflow automation, LoveThisLife is the specialist partner for Excel, Google Sheets, Smartsheet, and the tools around them.