Beginner to Advanced • Data Analytics & Formulas
Master Microsoft Excel for business accounting, data analysis, and office productivity. Learn powerful formulas, functions, dynamic dashboards, Pivot Tables, and automated data processing guided by Abdullah.
| # | A (Course Name) | B (Category) | C (Status) | D (Formula Output) |
|---|---|---|---|---|
| 1 | MS Excel | Accounting | Active | =SUM(B2:B10) |
| 2 | Data Analysis | Business | Active | =XLOOKUP("Excel", A:A, B:B) |
Worksheets, basic math operations, auto-fill, and data formatting.
VLOOKUP, XLOOKUP, IF/NESTED IF, INDEX/MATCH, and SUMIFS.
Data summarization, dynamic reporting, and data visualization.
Financial modeling, data validation, conditional formatting, and auditing.