Piyush Sharma Excel expert
No reviews yet

**Data Analysis**: Proficient in using functions such as VLOOKUP, HLOOKUP, INDEX, MATCH, and advanced formulas for comprehensive data analysis.
- **Pivot Tables**: Experienced in creating and manipulating pivot tables for data summarization and dynamic reporting.
- **Macros and VBA**: Skilled in automating repetitive tasks and enhancing functionalities using Macros and VBA (Visual Basic for Applications).
- **Conditional Formatting**: Expert in applying conditional formatting to highlight trends, patterns, and anomalies in data.
- **Data Visualization**: Adept at creating charts and graphs to present data visually, including bar charts, line charts, scatter plots, and pivot charts.
- **Data Cleaning**: Efficient in cleaning and organizing data using tools like Text to Columns, Remove Duplicates, and various text functions.
- **Financial Modeling**: Experience in building financial models, including budgeting, forecasting, and variance analysis.
- **Data Validation**: Skilled in setting up data validation rules to ensure data integrity and accuracy.
- **Collaboration and Sharing**: Familiar with sharing and collaborating on Excel files using OneDrive and other cloud-based services.
- **Advanced Functions**: Proficient in using advanced Excel functions such as SUMIFS, COUNTIFS, and array formulas.

Subjects

  • Excel Expert

  • Excel (Advanced) Beginner-Expert

Experience

No experience mentioned.

Education

  • Basis to advance excel (Oct, 2023–May, 2024) from Learnandexcel. In

Fee details

    ₹100/hour (US$1.19/hour)

Reviews

No reviews yet. Be the first one to review this tutor.