I will create dynamic excel dashboards, forecasting models,
About this Gig
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.
Technology:
Excel
•
Google Sheets
•
Python
•
RStudio
•
SAS
•
SPSS
My 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.
