Pallavi Sonar

@pallavibijotkar

Advance Excel Specialist

India

English, Hindi, Gujarati, Marathi

About me

I extensively use Advanced Excel tools and techniques to manage, analyze, and visualize data efficiently. My work includes creating complex formulas, using functions such as VLOOKUP, INDEX-MATCH, and array formulas for dynamic data analysis. I regularly employ Pivot Tables and Pivot Charts to summarize large datasets and generate insightful reports. I also utilize Power Query for data cleaning and transformation, and Power Pivot for data modeling. I place a strong emphasis on data accuracy, integrity, and security, applying validation rules, error-checking systems.... Read more

Skills