Office Skills · Zero to Advanced

Microsoft Excel Tutorial in English & Hinglish

Workbook basics se start karke formulas, lookups, dynamic arrays, charts, Pivot Tables, What-If Analysis, Power Query aur dashboard project tak complete practical learning path.

Zero to Advanced · 20 ChaptersBeginner + Intermediate + Advanced + Capstone · Excel Lab practice includedStart Excel Learning →

Excel course chapters

Learn concepts once, practice them in Excel Lab, then apply them in the final dashboard project.

01Excel Introduction & WorkbooksWorkbook, worksheet, rows, columns, cells, ranges and interface basics→ 02Data Entry & FormattingText, numbers, dates, editing, fill handle and number formats→ 03Formulas & Cell ReferencesOperators, relative references and calculation order→ 04Basic FunctionsSUM, AVERAGE, MIN, MAX and COUNT→ 05Sort, Filter & TablesOrganize datasets and use Excel Tables→ 06Conditional Formatting & Data ValidationHighlight patterns and control valid data entry→ 07Absolute & Mixed References$A$1, A$1 and $A1 with copy-safe formulas→ 08IF, AND, OR & IFERRORDecision formulas and controlled error handling→ 09COUNTIF, SUMIF & AVERAGEIFConditional counts, totals and averages→ 10Text & Date FunctionsLEN, LEFT, RIGHT, UPPER, LOWER, YEAR, MONTH and DAY→ 11VLOOKUP & HLOOKUPClassic vertical and horizontal lookup patterns→ 12XLOOKUPModern exact lookups with flexible return ranges and fallbacks→ 13INDEX + MATCHFlexible lookup without hard-coded column numbers→ 14Dynamic ArraysFILTER, SORT and UNIQUE spill formulas→ 15Charts & VisualizationChoose clear chart types for comparison, trend and reporting→ 16Pivot TablesSummarize and reshape large datasets quickly→ 17What-If AnalysisGoal Seek, scenarios and sensitivity analysis→ 18Power QueryImport, clean, transform and refresh repeatable data→ 19Dashboard DesignKPI cards, charts, filters and information hierarchy→ 20Sales Dashboard ProjectEnd-to-end capstone using formulas, Pivot Tables, charts and Power Query→