Excel Fundamentals Revision
-
Excel Interface & Ribbon
-
Workbook & Worksheet Management
-
Rows, Columns & Cells
-
Data Entry Techniques
-
Formatting (Font, Alignment, Number Format)
-
Conditional Formatting
-
Cell Referencing (Relative, Absolute, Mixed)
2️⃣ Important Excel Formulas & Functions
-
Basic Functions
-
SUM
-
AVERAGE
-
MIN / MAX
-
COUNT / COUNTA
-
-
Logical Functions
-
IF Function
-
Nested IF
-
AND / OR
-
-
Lookup Functions
-
VLOOKUP
-
HLOOKUP
-
XLOOKUP
-
INDEX & MATCH
-
-
Text Functions
-
LEFT / RIGHT / MID
-
LEN
-
TRIM
-
CONCAT / CONCATENATE
-
-
Date & Time Functions
-
TODAY
-
NOW
-
DATEDIF
-
EOMONTH
-
3️⃣ Data Management
-
Sorting Data
-
Filtering Data
-
Advanced Filter
-
Remove Duplicates
-
Data Validation (Drop Down List)
-
Text to Columns
4️⃣ Pivot Table & Pivot Chart
-
Creating Pivot Table
-
Pivot Table Analysis
-
Grouping Data
-
Calculated Fields
-
Pivot Charts
-
Pivot Dashboard
5️⃣ Data Analysis Tools
-
What-If Analysis
-
Goal Seek
-
Scenario Manager
-
Data Tables
-
Consolidation
6️⃣ Excel Charts & Visualization
-
Column Chart
-
Line Chart
-
Pie Chart
-
Bar Chart
-
Combo Chart
-
Dashboard Design
7️⃣ Excel Automation
-
Macro Introduction
-
Recording Macro
-
Running Macro
-
Basic VBA Concept
8️⃣ Excel for Accounting & MIS Reports
-
Salary Sheet
-
GST Data Sheet
-
Profit & Loss Data Analysis
-
Inventory Sheet
-
MIS Report Creation
-
Sales Report Analysis