
1st class free
About Mritunjay
Mritunjay Dwivedi is an experienced tutor with a Bachelor's degree and a decade of teaching experience. He is fluent in both English and Hindi, making his lessons accessible to a wide range of students. Mritunjay is dedicated to creating a supportive learning environment where students can thrive and achieve their academic goals.
With ten years of experience, Mritunjay focuses on understanding each student's unique learning style. He tailors his teaching methods to ensure that lessons are engaging and effective. His goal is to help students build confidence and improve their skills.
Courses by Mritunjay
1️⃣ Advanced Excel Functions
Lookup Functions: VLOOKUP, HLOOKUP, XLOOKUP, INDEX + MATCH
Logical Functions: IF, IFS, AND, OR, IFERROR
Text Functions: LEFT, RIGHT, MID, LEN, TRIM, CONCAT, TEXT
Date & Time: TODAY, NOW, EOMONTH, DATEDIF, NETWORKDAYS
Math & Statistical: SUMIFS, COUNTIFS, AVERAGEIFS
Dynamic Array: FILTER, SORT, UNIQUE, SEQUENCE
2️⃣ Data Cleaning & Data Handling
Remove Duplicates
Text to Columns
Flash Fill
Data Validation (Dropdown list)
Find & Replace (Advanced level)
Conditional Formatting (Advanced rules)
3️⃣ Pivot Table & Pivot Chart
Create & Modify Pivot Table
Grouping (Date, Month, Year)
Calculated Fields & Items
Slicers & Timelines
Pivot Charts & Interactive Reports
4️⃣ Dashboard & MIS Reporting
KPI Design
Interactive Dashboards
Use of Slicers, Buttons
Linking Multiple Sheets
Sales, Inventory, Purchase, MIS Dashboards
What students say
Similar tutors with Skills
Similar tutors with locations
Ready to start learning Advanced & Basic Excel? Book a free demo with Mritunjay.

0.0(0 reviews)