Mohammed Mustafa

1. Advanced Excel (3 Hours) Advanced Functions &amp; Logic IF, IFS, nested logic, etc SUMIFS, COUNTIFS, AVERAGEIFS XLOOKUP vs VLOOKUP (real use cases) INDEX + MATCH combination Error handling (IFERROR, ISERROR) Data Tools &amp; Analysis Data validation (dropdowns, rules) Conditional formatting (advanced rules) Text functions (LEFT, RIGHT, MID, TEXTJOIN) Date &amp; time intelligence functions Removing duplicates + data cleaning techniques Reporting &amp; Productivity Pivot Tables (advanced grouping &amp; calculated fields) Pivot Charts What-If Analysis (Goal Seek, Scenario Manager) Dynamic dashboards basics Excel shortcuts for speed ⚙️ 2. Power Query (2 Hours) Data Import &amp; Cleaning Understanding Power Query interface Importing from Excel, CSV, folders Removing errors, blanks, duplicates Splitting &amp; merging columns Data type transformations Transformation &amp; Automation of Excel files and workbooks Append vs Merge queries Group By for summaries Conditional columns Parameter-based queries (intro) Loading cleaned data to Excel / Data Model 📈 3. Power BI (3 Hours) Getting Started Power BI interface overview Importing data (Excel, Power Query connection) Data model basics (relationships) Star schema concept (simple explanation) DAX &amp; Calculations Measures vs calculated columns Basic DAX: SUM, COUNT, AVERAGE CALCULATE function Time intelligence basics (YTD, MTD) Visualization &amp; Dashboarding Charts: bar, line, matrix, cards Filters, slicers, drill-through Dashboard design best practices Publishing report (Power BI Service overview) All 3 courses for AED 750 056-6060872

Advanced Excel - Data Analysis

نظرة عامة

الوصف

منطقة