
Microsoft Word for Business
Produce consistent, professional business documents in Microsoft Word using styles, templates, long-document tools, mail merge, tracked changes and accessibility checks.
Build reliable business reports in Microsoft Excel using PivotTables, Power Query, the data model, XLOOKUP and dynamic arrays, then turn them into refreshable dashboards.
Offered by Leaders Training Centre

These apply to the centre. See Key facts for this course's certificate.






By the end of this course, participants will be able to:
The Advanced Excel and Business Reporting course in Doha, Qatar is built for people who already use Microsoft Excel every day and now need to produce accurate, repeatable reports from large or messy data. It goes well beyond the general Excel course, focusing on how analysts clean source data, model it, summarize it and present it to managers. Participants learn to replace manual copy-and-paste routines with connected workbooks that refresh in seconds when new data arrives.
Training is hands-on throughout. Each topic is practiced on realistic sales, finance, HR and operations datasets, and participants finish by building a complete monthly reporting pack with a dashboard. The trainer explains not only which feature to use but why, so learners can choose between formulas, PivotTables and Power Query with confidence. The course is available as public classroom sessions, live online, or as an in-house program for organizations that want exercises based on their own reports and systems.
This course suits experienced Excel users whose roles depend on turning raw data into management reports.
Financial and management accountants
Business, sales and operations analysts
HR and payroll reporting specialists
Project control and planning staff
MIS and reporting officers
Managers who build or review KPI reports
XLOOKUP and XMATCH versus VLOOKUP and INDEX-MATCH
Dynamic array functions: FILTER, SORT, SORTBY, UNIQUE, SEQUENCE
Using LET and named ranges for readable formulas
Excel Tables and structured references for growing data
Connecting to workbooks, CSV files, folders and databases
Cleaning data: splitting, trimming, replacing and changing types
Unpivoting, merging and appending queries
Parameters and refreshing queries on new data
Fact and dimension tables and star schema basics
Creating relationships between tables
Writing DAX measures with SUM, CALCULATE and DIVIDE
Date tables and time intelligence calculations
PivotTables built from the data model
Grouping, show values as and calculated fields
Slicers and timelines connected to several reports
GETPIVOTDATA and CUBE functions for custom layouts
Choosing the right chart for each business question
Combo charts, sparklines and dynamic chart titles
Conditional formatting, icon sets and KPI indicators
Dashboard layout, navigation and print settings
Building a refreshable monthly reporting pack
Recording simple macros for repetitive formatting tasks
Error checking, formula auditing and data validation
Protecting, sharing and co-authoring workbooks in Microsoft 365
Organizations across Qatar, from energy and construction to banking, government and healthcare, rely on regular management reports to track budgets, projects and performance. Much of this reporting still lives in Excel, and staff who can automate it free up time for analysis rather than data entry. Building these data skills supports the knowledge-based economy and human-development goals set out in Qatar National Vision 2030, and helps teams give decision makers timely, trustworthy figures.
Join a scheduled class at our training centre in Doha or attend live online. For organizations, the course can run as an in-house program at your premises or online, tailored to your sector, examples and schedule.
It is an advanced Microsoft Excel course in Doha that teaches Power Query, the data model, Power Pivot, modern formulas such as XLOOKUP and dynamic arrays, and dashboard design, so participants can build business reports that refresh automatically instead of being rebuilt by hand.
It is aimed at accountants, analysts, HR and project control staff, reporting officers and managers who already work confidently in Excel and regularly prepare or review management reports, KPI summaries or dashboards.
The general Excel course covers core skills such as formulas, formatting and basic charts. This course assumes that foundation and concentrates on advanced reporting tools: Power Query, the data model, DAX measures, dynamic arrays and automated dashboards. If you are unsure of your level, the team can advise you before you enroll.
Yes. It can be delivered at your premises or online and tailored to your sector, your own report examples and your schedule. Contact Leaders Training Centre to plan an in-house program for your team.
Tell us a little about yourself and an advisor will contact you about batch timings, fees and eligibility. No obligation.
Sat–Thu: 09:00–22:00Fri: 08:00–22:00

Produce consistent, professional business documents in Microsoft Word using styles, templates, long-document tools, mail merge, tracked changes and accessibility checks.

Design clear, on-brand presentations in Microsoft PowerPoint using slide masters, sound design principles, effective charts and Designer, and deliver them with confidence.

Build the confidence to read charts and dashboards, understand KPIs and basic statistics, spot misleading figures and use data responsibly to make better everyday business decisions as a team.

Work smarter with Microsoft 365 by managing email in Outlook, storing files in OneDrive, collaborating in Teams, and organizing tasks with Planner, To Do, Forms and Loop.
4.8
Based on 1,027 Google reviews