Amar Dalvi Microsoft Excel
No reviews yet

Greetings! I'm Amar Dalvi. As a seasoned Excel professional, I'm excited to share my expertise.

Excel is a powerful tool with a wide range of applications, and the more you explore and use it, the more proficient you'll become.

Lets learn Excel!

Excel Basics:
1. Introduction to Excel:
• Understanding the Excel interface.
• Navigating workbooks and worksheets.
2. Data Entry and Formatting:
• Entering data efficiently.
• Formatting cells, rows, and columns.
3. Basic Formulas and Functions:
• SUM, AVERAGE, COUNT, MIN, MAX.
• Simple arithmetic operations.
4. Cell References:
• Relative, absolute, and mixed references.
5. Data Management:
• Sorting and filtering data.
• Data validation.
6. Basic Charts:
• Creating simple charts like bar charts and line graphs.
Intermediate Excel:
1. Advanced Formulas:
• IF statements, VLOOKUP, HLOOKUP, INDEX, MATCH.
• Logical and text functions.
2. Data Analysis Tools:
• PivotTables for summarizing and analyzing data.
• Data tables and scenarios.
3. Data Cleaning and Transformation:
• Text-to-columns, Flash Fill.
• Power Query for data transformation.
4. Advanced Charting:
• Combo charts, sparklines, trendlines.
• Customizing chart elements.
5. Workbook Management:
• Templates and advanced formatting.
• Protecting sheets and workbooks.
Advanced Excel:
1. Advanced PivotTable Techniques:
• Slicers, timelines, calculated fields.
• Power Pivot for data modeling.
2. Automation with Macros:
• Recording and editing macros.
• VBA (Visual Basic for Applications) basics.
3. Advanced Formulas and Functions:
• Array formulas, nested functions.
• Goal Seek and Solver.
4. Data Analysis with Power BI:
• Integrating Excel with Power BI.
• Creating interactive dashboards.
5. Collaboration and Sharing:
• Sharing workbooks and collaboration features.
• Excel Online and co-authoring.
6. Advanced Data Visualization:
• 3D maps, advanced chart types.
• Custom visuals and conditional formatting.

Subjects

  • Excel (Advanced) Beginner-Intermediate

Experience

  • Assistant Manager (Sep, 2014–Present) at Godrej & Boyce

Education

  • Bachelor’s Degree - Mechanical Engineering (Mar, 2011–May, 2014) from Goa University–scored 77%

Fee details

    ₹100–500/hour (US$1.18–5.90/hour)

Reviews

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