Data & Analytics Training Program In-Person Open

Advanced Excel for Business Analysis

Master advanced Excel features — pivot tables, Power Query, complex formulas, macros, and data modelling for professional business analysis.

Doha, Qatar

3 days 21 hrs Doha, Qatar ar / 20 seats

Overview

Excel remains the most widely used analytics tool in the world — over 750 million users globally. Yet most professionals use less than 20% of its capabilities. This programme unlocks the remaining 80%: advanced formulas (INDEX-MATCH, SUMIFS, array formulas), pivot tables and pivot charts, Power Query for data transformation and cleaning, Power Pivot for data modelling, basic VBA macros for automation, and dashboard building with form controls. Participants work on real business datasets — sales, HR, financial — and leave with a toolkit of reusable templates and macros that save hours of manual work every week.

Course Objectives

Master advanced formulas: INDEX-MATCH, SUMIFS, array formulas, nested IFs.
Build dynamic pivot tables and pivot charts.
Use Power Query for data cleaning and transformation.
Create data models with Power Pivot and DAX.
Automate repetitive tasks with basic VBA macros.
Build interactive Excel dashboards.

Requirements

Intermediate Excel skills — familiarity with basic formulas, charts, and formatting.

Why This Course?

Unlock the 80% of Excel You Never Use

Excel has 750M users but most use less than 20% of its power. This programme unlocks the rest — Power Query for data cleaning, Power Pivot for modelling, VBA for automation, and dashboard building. The result: hours saved every week and insights that were previously impossible.

Course Value

Advanced Formulas

Master INDEX-MATCH, SUMIFS, array formulas, and nested logic — the formulas that separate power users from casual users.

Power Query

Automate data cleaning and transformation with Power Query — replace manual data prep with repeatable, automated processes.

VBA Automation

Record and edit VBA macros to automate repetitive Excel tasks — saving hours of manual work every week.

Excel Dashboards

Build interactive Excel dashboards with form controls, charts, and conditional formatting that update automatically.

Back to Courses

$1,200

Registration Fee

Venue Doha Tech Park Training Centre

Address Doha Tech Park, Doha

View on Map Download Brochure

Limited to 20 participants.

Discover More

Suggested Courses

Finance, Accounting & Investment Open

FinTech and Digital Banking Transformation

Understand fintech, digital payments, wallets, modern banking services, and associated risks and opportunities.

$2,000

Details

Cybersecurity & Information Protection Open

Cybersecurity Awareness for Employees

Protect email, passwords, devices, and data from phishing, social engineering, and common cyber attacks.

$900

Details

Law & Governance Open

Modern Corporate Governance

Build effective governance frameworks covering responsibilities, committees, transparency, and accountability.

$1,800

Details

Management & Leadership Open

Corporate Governance and Institutional Compliance

A practical programme on corporate governance frameworks, board effectiveness, risk oversight, and compliance — aligned with OECD and international standards.

$1,700

Details

Government & Public Policy Open

Smart City Management

Manage smart city solutions in mobility, energy, data, safety, and public services.

$1,900

Details

AI & Digital Transformation Open

Digital Transformation for Public and Private Organizations

Design a practical digital transformation roadmap covering processes, systems, data, and people — for both government entities and private sector organisations.

$1,900

Details