1) Foundations & Productivity

• Efficient navigation, data entry, formatting standards, named ranges
• Data cleaning: Text to Columns, Flash Fill, Remove Duplicates, Data Validation
• Conditional Formatting for KPIs, icon sets, custom formulas

2) Formulas & Functions

• Logical & lookup: IF, IFS, AND/OR, XLOOKUP/VLOOKUP/HLOOKUP, INDEX+MATCH
• Date/time, text, math, errors, dynamic arrays: FILTER, UNIQUE, SORT, SEQUENCE
• What-If & scenarios: Goal Seek, Scenario Manager, Data Tables

3) Pivot Tables & Dashboards

• Pivot Tables, Slicers/Timelines, Grouping, Calculated Fields
• Charts (combo, waterfall, sparklines), KPI visuals
• Dashboard layout, storytelling, interactivity

4) Power Query (Get & Transform)

• Importing data (CSV, Excel, folders), transformations & merges
• Append/Merge queries, cleaning, automation
• Best practices for repeatable ETL

5) Power Pivot & Data Model (Optional)

• Data Model basics, relationships, star schema
• DAX fundamentals: Measures vs Calculated Columns
• Time intelligence & performance tips

6) Automation & Protection

• Macros (recording), intro to VBA scenarios
• Workbook/worksheet protection, version control

1) Getting Started

• Power BI Desktop & Service overview, workspaces, datasets, reports, dashboards
• Data sources & connectors, scheduled refresh basics

2) Power Query (ETL)

• Data loading, transformations, merges/appends, parameters
• Data quality checks, profiling, automation

3) Data Modeling

• Relationships, cardinality, filter directions
• Star schema, surrogate keys, role-playing dimensions

4) DAX for Analysis

• Calculated columns vs measures, aggregation patterns
• CALCULATE, FILTER, ALL, RELATED; time intelligence (YTD/QTD/MTD)

5) Visualisation & UX

• Core visuals, custom visuals, bookmarks & drill-through
• Slicers, field parameters, tooltips, responsive layouts

6) Publishing & Governance

• Publishing to Service, apps, sharing & permissions
• Row-Level Security (RLS), performance tips, deployment pipelines (overview)

1) Communication Essentials

• Business writing (emails, proposals, minutes), presentation skills
• Active listening, questioning, feedback frameworks (SBI)

2) Leadership & Teamwork

• Situational leadership, delegation, coaching conversations
• Conflict management, stakeholder alignment, meeting facilitation

3) Personal Effectiveness

• Time management, prioritization (Eisenhower), goal setting (OKRs)
• Critical thinking, problem solving, decision-making frameworks

4) Customer Focus

• Empathy mapping, objection handling, service recovery
• Negotiation basics, cross-functional collaboration

1) Fundamentals & Strategy

• Digital channels overview, funnel stages, KPI planning
• Competitor & audience analysis, positioning, messaging

2) SEO & Content

• On-page basics (title, meta, headings, internal links)
• Keyword research, content calendars, basic analytics

3) Paid Media & Social

• Intro to Google Ads / Meta Ads: campaign types, tracking basics
• LinkedIn for B2B, remarketing concepts, UTM discipline

4) Email & Automation

• List hygiene, basic segmentation, drip logic
• A/B testing fundamentals, deliverability basics

5) Measurement

• Dashboards for campaigns, lead quality feedback loop
• Attribution basics, reporting cadence

1) Visual Fundamentals

• Slide hygiene: grids, margins, typography, color discipline
• Visual hierarchy, white space, brand consistency

2) Data to Story

• Choosing the right chart, decluttering visuals
• Executive summaries, narrative flow, call-to-action slides

3) Productivity & Assets

• Masters & layouts, reusable templates, iconography
• Shortcuts, alignment/distribution, exporting best practices

4) Animation & Delivery

• Subtle transitions, emphasis animations, do’s & don’ts
• Presenter view, timing, remote delivery tips