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

Government & Public Policy Open

Smart City Management

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

$1,900

Details

Finance, Accounting & Investment Open

Anti-Money Laundering and Financial Compliance

Training on red flags, due diligence, reporting, and compliance risk management in financial institutions.

$1,700

Details

Human Resources & Talent Development Open

Training and Professional Development

Design and implement effective training and development programs that build employee skills and drive organisational growth.

$1,300

Details

Human Resources & Talent Development Open

Modern Human Resources Management

Apply modern HR practices in recruitment, performance, compensation, training, and employee relations aligned with strategy.

$1,600

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

Human Development & Education Open

Training of Trainers

Develop presentation, classroom management, activity design, and training impact evaluation skills.

$1,200

Details