You profile has been submitted for review.
Sanjeev Kumar Excel expert
No reviews yet
🟢 Beginner Level (Basics)
Introduction to Excel Interface
Workbook, worksheets, rows, columns, cells
Ribbon, tabs, quick access toolbar
Basic Operations
Entering/editing data
Formatting cells (bold, color, alignment, borders)
AutoFill & Flash Fill
Basic Formulas
SUM, AVERAGE, MIN, MAX, COUNT
Understanding =, cell references (A1, B2)
Absolute vs relative references ($A$1)
Data Management
Sorting & Filtering
Freeze Panes, Split View
Basic tables
🟡 Intermediate Level
Advanced Formulas
IF, AND, OR, NOT
VLOOKUP, HLOOKUP, XLOOKUP (new Excel)
INDEX & MATCH
Data Handling
Data Validation (drop-down lists)
Conditional Formatting
Named Ranges
Charts & Visualization
Column, Line, Pie, Bar, Combo Charts
Sparklines
Formatting charts for reports
Data Analysis Tools
PivotTables & PivotCharts
Slicers & Timelines
🔵 Advanced Level
Complex Formulas
Nested IFs
Text functions (LEFT, RIGHT, MID, LEN, TRIM, CONCAT, TEXTJOIN)
Date & Time functions (TODAY, NOW, DATEDIF, EOMONTH)
Data Analysis
What-If Analysis (Goal Seek, Scenario Manager, Data Tables)
Solver Add-in
Advanced PivotTable Calculations
Automation
Macros & VBA basics
Recording and running macros
Power Tools (latest Excel)
Power Query (Get & Transform)
Power Pivot & Data Model
Using DAX for advanced measures
🎯 Practical Applications
For Students: Grade calculation, attendance sheet, timetable.
For Office: Salary sheets, sales reports, inventory management.
For Data Analysts: Dashboards, KPIs, data cleaning.
Introduction to Excel Interface
Workbook, worksheets, rows, columns, cells
Ribbon, tabs, quick access toolbar
Basic Operations
Entering/editing data
Formatting cells (bold, color, alignment, borders)
AutoFill & Flash Fill
Basic Formulas
SUM, AVERAGE, MIN, MAX, COUNT
Understanding =, cell references (A1, B2)
Absolute vs relative references ($A$1)
Data Management
Sorting & Filtering
Freeze Panes, Split View
Basic tables
🟡 Intermediate Level
Advanced Formulas
IF, AND, OR, NOT
VLOOKUP, HLOOKUP, XLOOKUP (new Excel)
INDEX & MATCH
Data Handling
Data Validation (drop-down lists)
Conditional Formatting
Named Ranges
Charts & Visualization
Column, Line, Pie, Bar, Combo Charts
Sparklines
Formatting charts for reports
Data Analysis Tools
PivotTables & PivotCharts
Slicers & Timelines
🔵 Advanced Level
Complex Formulas
Nested IFs
Text functions (LEFT, RIGHT, MID, LEN, TRIM, CONCAT, TEXTJOIN)
Date & Time functions (TODAY, NOW, DATEDIF, EOMONTH)
Data Analysis
What-If Analysis (Goal Seek, Scenario Manager, Data Tables)
Solver Add-in
Advanced PivotTable Calculations
Automation
Macros & VBA basics
Recording and running macros
Power Tools (latest Excel)
Power Query (Get & Transform)
Power Pivot & Data Model
Using DAX for advanced measures
🎯 Practical Applications
For Students: Grade calculation, attendance sheet, timetable.
For Office: Salary sheets, sales reports, inventory management.
For Data Analysts: Dashboards, KPIs, data cleaning.
Subjects
-
Excel Advance Beginner-Expert
Experience
-
data entry operator (Sep, 2022–Oct, 2025) at nbpdcl, patna
Report Generation, Data Entry, Typing
Education
-
Advance Diploma in Computer Application (Jan, 2017–Jan, 2018) from vijay computer, sitamarhi
Fee details
₹100–500/hour (US$1.05–5.26/hour)
On basis of work
-
-
Sitamarhi, Bihar, India
-
Can travel:
No
-
- Last login: Oct 4, 2025
- Registered: Oct 4, 2025
- Total Teaching exp: 3.0 yrs.
- Teaches online: Yes
- Online Teaching exp: 3.0 yrs.
- Teaches at student's home: No
- Homework Help: Yes
-
Gender: Male
- Works as: Individual teacher
- Speaks: Hindi
-
Fee:₹100–500/hour(USD 1.05–5.26/hour)
Reviews
No reviews yet. Be the first one to review this tutor.
