About the role
Job description :
Job Title : Sr. Advanced Excel Specialist/AnalystLocation: BangaloreExperience: 6-9 yearsNotice Period: ImmediateCertification Required: Microsoft Office Specialist (Excel Expert) or equivalent is mandatory.About the RoleWe are seeking a highly skilled Advanced Excel Specialist to drive efficiency and insight through expert-level spreadsheet solutions. This role focuses on advanced formula development, dashboard creation, and process automation using Excel, Power Query, and VBA. The ideal candidate will be passionate about transforming raw data into actionable intelligence and reducing manual reporting efforts.Key Responsibilities
- Design dynamic Excel models and dashboards that automatically refresh, reducing manual reporting hours.
- Clean, transform, and merge data from multiple sources using Power Query or equivalent tools.
- Develop robust formulas (e.g., INDEX/MATCH, XLOOKUP, SUMIFS, array logic) that adapt to changing inputs and minimize errors.
- Create PivotTables, slicers, and charts to highlight trends and support timely decision-making.
- Automate repetitive tasks using macros and VBA, delivering significant time savings for the team.
- Standardize file structures, naming conventions, and formatting to ensure reports are auditable and maintainable.
- Proven expertise in Advanced Excel, including:
- OFFSET, INDIRECT, VLOOKUP, INDEX MATCH
- Power Query, Data Validation, Flash Fill
- PivotTables, Slicers, Conditional Formatting
- Macros and VBA
- External Data Integration and Simulations
- Experience in data analytics, financial modeling, forecasting, and dashboard development.
- Familiarity with Power BI, Tableau, SQL, and Python for Excel automation is a strong plus.
- Ability to communicate technical solutions clearly to non-technical stakeholders.
- Strong problem-solving mindset and commitment to building scalable, long-lasting models.
- Excellent collaboration, communication, and attention to detail.
- Based ont the requirement, Should be ready to work at client location at Bangalore
- Advanced Financial Modeling & Forecasting
- Statistical Analysis & Predictive Modeling
- Business Intelligence Strategy & Implementation
- AI-Enhanced Excel Analytics with Copilot Integration
- Spreadsheet Automation Tools (e.g., Power Automate)
- Industry-Specific Excel Applications (e.g., Inventory Management, Operations Analytics)
- Microsoft Office Specialist (Excel Expert) or equivalent certification is mandatory.