I will create advanced excel dashboards, formulas

India

I speak Hindi, Bengali, Oriya, English

HR Analyst

I am a results-driven Analytics professional with over 4 years of experience in HR and business operations. I pioneered the Fintech industry's first Piece-Rate Salary model for over 40,000 agents and ...
About this Gig

Are you struggling with complex Excel formulas, broken spreadsheets, or spending hours on manual reporting? Look no further!


As an experienced Analytics Professional with over 4 years of hands-on experience building high-impact data solutions for enterprise operations, I help businesses turn raw, messy data into clean, automated, and visually striking interactive dashboards.  


Whether you need a quick formula fix, a dynamic automated model, or an end-to-end interactive dashboard, I deliver accurate, high-fidelity results


What I Can Do For You:

  • Advanced Formulas & Functions: XLOOKUP, INDEX/MATCH, Dynamic Arrays, Nested IFs, SUMIFS, and custom formula building.
  • Interactive Dashboards: Dynamic visual charts, slicers, key performance indicators (KPIs), and executive summary reports in Excel or Google Sheets.
  • Automation & Scripting: Custom VBA Macros and Google Apps Script to eliminate repetitive tasks and streamline workflows.
  • Data Cleaning & Formatting: Removing duplicates, splitting/combining columns, unpivoting data, and structural optimization.
  • Pivot Tables & Analytics: Complex data summarization, calculated fields, and multi-layered data modeling.


Platform:

Excel

•

Google Sheets

•

Power BI

Development technology:

Google Apps Script

•

Power Query

•

Excel

Expertise:

Pivot tables

•

Formulas

•

Functions

•

Dashboard

•

Power Query