Mritunjay Dwivedi
Online
Skills :
About :
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 w…
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.
Mritunjay Dwivedi
Online
Skills :
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 w...
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.
FindMyGuru is a tutor discovery platform that helps students find and connect with experienced tutors and institutes across a wide range of subjects and skills. Students can explore tutor profiles, compare expertise, and contact tutors directly for online or in-person learning.FindMyGuru facilitates discovery and connections between students and tutors or institutes. All classes and learning arrangements are handled directly between students and the respective tutors or institutes
Courses by Mritunjay Dwivedi
Online
30 Hour
English, Hindi
Satna, Civil Line 8982566840
1000 INR
Week Days / Weekends
Course Content
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