I will create dynamic excel dashboards, forecasting models,
Data analyst
À propos de ce service
Is your Excel full of messy data, broken formulas, or reports that take hours to update manually? It's time to work smarter.
WHAT I DELIVER IN EXCEL
- Interactive dashboards with charts, slicers, and KPI cards
- Financial models P&L, cash flow, budget vs actual, forecasting
- Advanced formulas XLOOKUP, INDEX/MATCH, dynamic arrays, LAMBDA
- Pivot tables and pivot charts with drill-down capability
- Excel automation macros (VBA) and Power Query workflows
- Data cleaning, transformation, and deduplication
- Sales, HR, operations, and inventory trackers
- What-if analysis, scenario modelling, and sensitivity tables
- AI-powered forecasting and trend analysis integrated into Excel
- Excel-to-dashboard templates your team can update with zero effort
MY EDGE AI MEETS EXCEL
I bring machine learning thinking into Excel applying statistical forecasting, regression models, and predictive analysis directly into your spreadsheets. You get the intelligence of a data scientist in a tool your team already uses.
Technologie:
Excel
•
Google Sheets
•
Python
•
RStudio
•
SAS
•
SPSS
Mon portfolio
FAQ
What version of Excel do you work with?
I work with Excel 2016, 2019, 2021, and Microsoft 365 (the latest cloud version). If you have an older version, let me know and I'll ensure compatibility — some dynamic array functions are only available in Microsoft 365.
Can you automate repetitive tasks in my Excel file?
Absolutely. I build VBA macros and Power Query pipelines to automate data imports, report refreshes, formatting, and calculations — so what used to take hours runs with one click.
Can you build a financial forecasting model in Excel?
Yes — this is one of my strongest specialities. As a Data Scientist, I build Excel models with statistical forecasting (moving averages, regression, exponential smoothing) and scenario analysis so you can model future outcomes with confidence.
My data is in multiple files or sheets — can you consolidate it?
Absolutely. Consolidating messy, scattered data into one clean model is one of the most common tasks I handle. I use Power Query to pull and transform data from multiple sources automatically.
Do you use AI or machine learning inside Excel?
Yes. I can embed AI-powered forecasting, anomaly detection, and pattern recognition into Excel using Python integrations, statistical functions, and model outputs exported into your workbook — giving you ML-grade insights in a familiar tool.
