We're Hiring: Data Analyst (Advanced Microsoft Excel)
Location: Remote
Employment Type: Full time
Experience: 3–9 Years
shift timings- 2pm onwards
Advanced Microsoft Excel refers to using Excel beyond basic spreadsheets and formulas. It involves working with complex formulas, automation, data analysis, reporting, and modeling to solve business problems efficiently
. For the Pricing Sheet Developer role, candidates should be proficient in the following advanced Excel features
:
Analyze large datasets to identify trends, patterns, and business insigh
ts Develop and maintain advanced Excel models for reporting, forecasting, and financial analys
is Build dashboards and reports to support business decision-maki
ng Automate repetitive tasks using Excel Macros and V
BA Validate data accuracy and reconcile financial and operational repor
ts Perform data cleansing, transformation, and quality chec
ks Collaborate with cross-functional teams to gather reporting requirements and deliver actionable insigh
ts Document business logic, reporting methodologies,
and process improvemen
ts Required Skil
ls
Advanced Microsoft Excel expertise, includi
ng: Advanced Formulas & Functi
ons INDEX/MA TCHXLOO KUPIF, IFSSUM IFSArray Formu las Nested Functi ons Logical Functi ons Data Managem
ent Named Ran ges Data Validat ion Conditional Formatt ing Advanced Filter ing Sorting and Data Clean ing Data Analy
sis Pivot Tab les Pivot Cha rts What-If Analy sis Trend Analy sis Data Model ing Automat
ion Excel Mac ros VBA (Visual Basic for Applicatio ns)Report Automat ion Financial & Pricing Model
ing Financial Analy sis Pricing Mod els Forecast ing Business Calculati ons Error Checking & Validat
ion Formula Audit ing Data Reconciliat ion Error Handl ing Validation Che cks Reporting & Documentat
ion Interactive Dashboa rds Executive Repo rts Documentation of Business Lo gic Process Documentat ion
What We're Looking
For 3–5+ years of experience as a Data Analyst, MIS Analyst, Reporting