Advanced & Basic Excel Training by Mritunjay Dwivedi

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