The Modern Excel is Dubai's leading corporate Excel and Power BI training company. Since 2005, we have delivered instructor-led training, automation projects, and business intelligence consulting to over 1,013 corporations in Dubai, Abu Dhabi, and across the UAE.
The Modern Excel is a Dubai-based corporate training and consulting firm specialising in Microsoft Excel, Power BI, Power Query, DAX, and Excel automation using VBA. Founded in 2005, the company has trained professionals from over 1,013 corporations across the United Arab Emirates — including banks, insurance companies, oil and gas firms, luxury brands, and hospitality groups in Dubai and Abu Dhabi. The core team holds over 100 combined years of hands-on Excel and Power BI practitioner experience.
Services offered: instructor-led corporate training (23 courses), Excel and Power BI project development, automation using VBA macros, Power Query data models, DAX measures, Power BI dashboards, and repair & enhancement of existing Excel and Power BI solutions.
The term Modern Excel refers to the advanced feature set Microsoft built into Excel from version 2016 onward — including Power Query, the Data Model, DAX, Power Pivot, Power BI, and Excel Online. Excel does not require an introduction: it is the backbone application of every organisation. Modern Excel transforms your experience: you achieve "Excel works for me" happiness rather than fighting the tool.
Most corporate users still operate Excel the way spreadsheets were used in the late 1990s. We founded TheModernExcel.com to create awareness about these highly powerful features. The main components are:
Automation of business processes — save costs, eliminate human errors, increase efficiency.
Excel and Power BI Projects are the fastest and most economical way to automate department-level processes:
We also Repair & Enhance your current Excel / Power BI solutions.
Our extensive work has helped us create "Practically Useful" best practices for all solutions delivered using VBA, "M" Language, and DAX. We also consider the user-facing experience: if users can see the code, they want to understand it.
Excel and Power BI solutions often become abandoned when the in-house expert or consultant leaves. Business logic changes, data structures evolve, and errors accumulate. We offer repair and enhancement services to bring your solutions back to life. Common reasons for errors include changed business logic, changed input data structure, changed output design, new visual requirements, errors or slow performance.
Designed for Excel 2016 and beyond. Post-training coaching available — we coach using your files to ensure real-world adoption.
Designed for Modern Excel (Excel 2016 and beyond). Power Query, Data Model, DAX and Power Pivot are not available in earlier versions.
Power Query is a tool for data manipulation, analysis and business intelligence. It allows importing data into Excel through external sources — text files, CSV, web, or Excel workbooks.
Data Analysis Expressions (DAX) is a formula expression language used in Analysis Services, Power BI, and Power Pivot in Excel. DAX formulas include functions, operators, and values to perform advanced calculations on tabular data models.
Microsoft Power BI is a data visualisation platform used for business intelligence. Power BI's dashboard is capable of reporting and visualising data across a wide range of styles — graphs, maps, charts, scatter plots, and more.
Programming in Excel empowers increased efficiency, enhanced data analysis, automation capabilities and facilitates complex data processes.
Harness the power of Artificial Intelligence within Excel for enhanced data analysis, automation, and smarter decision-making. Designed for end users who want to leverage AI tools without deep technical knowledge.
23 instructor-led courses across 7 categories — available for in-house corporate groups in Dubai, Abu Dhabi, and across the UAE.
Makes an Excel user benefit from the inbuilt capabilities of Excel, rather than using it as a mere electronic spreadsheet for typing reports. Topics: Tables, Pivot Tables, IF, VLOOKUP, absolute and relative references, inbuilt calculations and formatting. 100% hands-on with real corporate data — no PowerPoint slides.
View full course outline →Introduces Excel's most powerful modern features to transform how you work with data. Topics: Tables vs Range, Slicers, Pivot Tables advanced usage, VLOOKUP and XLOOKUP, IF to IFS, Power Query fundamentals, Excel default setting optimisation. 100% hands-on — real corporate data.
View full course outline →A completely hands-on course on building interactive, professional dashboards in Excel. Topics: data preparation, essential Excel functions for dashboards, basic and intermediate visualisation techniques, dashboard layout and composition, interactivity, navigation, performance optimisation, and real-world case studies.
View full course outline →A focused, hands-on course tailored for HR professionals. Topics: Excel for HR data, HR dashboard preparation, essential Excel functions for HR reporting, visualisation techniques, HR dashboard advanced features, HR data performance optimisation, and real-world HR case studies.
View full course outline →A completely hands-on finance-focused course. Topics: financial modelling foundations, advanced financial functions in Excel, financial reporting and analysis, budgeting and forecasting, advanced financial modelling, automation and macros in finance, real-world finance applications and case studies.
View full course outline →A hands-on course for building robust HR budgets in Excel using Modern Excel techniques. Covers the full HR budgeting lifecycle. Topics: HR budgeting data preparation, Excel functions for HR budgeting, building HR budgets, advanced techniques, automation with macros, real-world HR budgeting case studies.
View full course outline →Power Query is the most powerful data transformation tool in Excel. This course teaches how to import, clean, and shape data from any source without writing a single formula. Topics: introduction to Power Query, data transformation techniques, introduction to M Language, query folding and optimisation, data loading and output, real-world applications.
View full course outline →A deep-dive into Power Query's M Language, complex transformations, and enterprise-level data preparation techniques. Topics: advanced data transformation, advanced M Language functions, complex query structures and parameters, query folding and performance optimisation, combining multiple data sources, advanced loading options, real-world case studies.
View full course outline →Data Analysis Expressions (DAX) is the formula language of Power BI, Power Pivot, and Analysis Services. This course transforms your experience and engagement with data modelling and KPI calculations. Topics: DAX and Power Pivot introduction, Calculated Columns vs Measures, common DAX functions, row context vs filter context, time intelligence basics.
View full course outline →A comprehensive advanced course covering expert-level DAX patterns, context manipulation, time intelligence, and performance optimisation. Topics: DAX fundamentals review, context in DAX (row context, filter context, context transition), advanced data modelling, advanced time intelligence, performance optimisation, VAR…RETURN patterns, advanced real-world case studies.
View full course outline →Microsoft Power BI is Microsoft's premier business intelligence platform. This hands-on course takes you from zero to building live, interactive dashboards and reports. Topics: Power BI Desktop and Service, visualisation basics, report building and layout, custom visualisations and themes, Power BI Dashboards, Power BI Mobile App, real-world case studies.
View full course outline →Takes your Power BI skills to the next level with advanced data modelling, Power Query, and enterprise deployment strategies. Topics: fundamentals recap, advanced data modelling, advanced visualisation techniques, Power Query advanced techniques, Power BI Service and Desktop integration, advanced analytics, governance, security, and data refresh.
View full course outline →The expert-level Power BI programme for senior analysts and architects covering enterprise deployment, AI integration, and complex analytics. Topics: advanced data modelling strategies, expert-level DAX mastery, advanced Power Query scripting, advanced visualisation techniques, enterprise-level deployment, complex analytics and AI integration, real-world challenges.
View full course outline →After this course you will be able to write VBA programming to automate your daily tasks and reports in Excel. Topics: VBA and the Excel Object Model, procedures and functions, objects/properties/methods, expressions and variables, loops and conditions, UserForms and controls, PivotTable objects, debugging code, error handling.
View full course outline →Office Scripts is Microsoft's modern alternative to VBA, using TypeScript/JavaScript syntax. Topics: introduction to Excel Scripting and Office Scripts, VBA vs Office Scripts comparison, advanced script programming, JavaScript Add-ins for Excel, Excel automation and integration with Power Automate, real-world applications.
View full course outline →Harness the power of Artificial Intelligence within Excel for enhanced data analysis, automation, and smarter decision-making — designed for end users without deep technical knowledge. Topics: introduction to AI in Microsoft 365 and Excel, Copilot in Excel (generating formulas and insights), AI for data cleaning and transformation, AI-powered forecasting and trend analysis, natural language queries in Excel, best practices for AI-assisted reporting.
View full course outline →All courses are instructor-led, 100% hands-on, and available for in-house corporate groups across the UAE. Scroll right on mobile.
| Course | Category | Duration | Level | Best For |
|---|---|---|---|---|
| Modern Excel Essentials | Modern Excel | 1 Day | Beginner – Intermediate | All corporate staff |
| Modern Excel Advanced | Modern Excel | 2 Days | Intermediate | Regular Excel users |
| Excel Dashboards | Modern Excel | 8 Hours | Intermediate | Reporting analysts |
| Excel for HR Professionals | Modern Excel | 8 Hours | Beginner – Intermediate | HR teams |
| Excel for Finance Professionals | Modern Excel | 8 Hours | Intermediate | Finance teams |
| HR Budgeting using Modern Excel | Modern Excel | 8 Hours | Intermediate | HR & Finance teams |
| Power Query Essentials | Power Query | 8 Hours | Intermediate | Data analysts |
| Power Query Advanced | Power Query | 16 Hours | Advanced | Power Query practitioners |
| DAX Essentials | Data Model & DAX | 8 Hours | Intermediate | BI analysts |
| DAX Advanced | Data Model & DAX | 16 Hours | Advanced | BI specialists |
| Power BI Essentials | Power BI | 8 Hours | Beginner – Intermediate | Report builders |
| Power BI Advanced | Power BI | 16 Hours | Advanced | Senior analysts |
| Power BI Super Users | Power BI | 16 Hours | Expert | BI architects |
| Macro Programming (VBA) | Programming | 3 Days | Advanced | Automation specialists |
| Script Programming | Programming | 8 Hours | Advanced | TypeScript/JS developers |
| AI in Excel for End Users | AI in Excel | 8 Hours | All levels | All Excel users |
Everything you need to know about Excel and Power BI training in the UAE.
The Modern Excel is Dubai's leading corporate Excel training provider, with over 20 years of active experience and more than 1,013 corporations served since 2005. Our instructors are practicing Excel and Power BI specialists who build real solutions for UAE corporations daily — not classroom-only teachers. Every course is 100% hands-on using real corporate data, with zero PowerPoint slides.
We offer 23 instructor-led courses covering the full Microsoft Excel ecosystem — from Essential Skills to Power Query, DAX, Power Pivot, and Power BI — available in-person or virtually for corporate groups across Dubai, Abu Dhabi, and the wider UAE.
The Modern Excel offers three levels of Microsoft Power BI training in the UAE: Power BI Essentials (8 hours), Power BI Advanced (16 hours), and Power BI Super Users (16 hours). All courses are instructor-led and available for in-house corporate groups in Dubai and Abu Dhabi.
Power BI Essentials covers dashboard creation, report building, data visualisation, and the Power BI Service. Power BI Advanced adds advanced data modelling, Power Query, enterprise governance, and row-level security. The Super Users programme covers expert DAX, advanced scripting, enterprise-scale deployment, and AI integration in Power BI.
Yes. All 23 of The Modern Excel's training courses are available as in-house corporate sessions for groups of any size in Dubai, Abu Dhabi, Sharjah, and across the UAE. Courses can be adapted to use your organisation's own data and workflows.
Post-training coaching is also available: one of our specialists works directly with your team on your own Excel or Power BI files after the session to ensure training translates into lasting daily use. This post-training coaching on real files is a key differentiator of The Modern Excel's approach.
The Modern Excel has delivered 556+ Excel and Power BI projects for corporations in the UAE. Excel projects include: HR budgeting systems, financial P&L models, demand planning and inventory tools, salary slip generation and email automation, UAE VAT invoice automation, data collation and reporting models, and UAE Gratuity calculators.
Power BI projects include dashboards for sales analysis (actual vs budget vs prior year), HR head count and diversity, customer complaints trend analysis, finance revenue and cost, P&L statements, and supply chain BOM analysis. We also repair and enhance existing Excel and Power BI solutions that have broken or become outdated.
Power Query Essentials takes 8 hours (one full day). Power Query Advanced takes 16 hours (two full days). DAX Essentials takes 8 hours; DAX Advanced takes 16 hours. Both streams are available for in-house corporate groups in Dubai and Abu Dhabi.
Pre-requisite for Power Query courses: at least 6 months of active Excel use. Pre-requisite for DAX Advanced: two or more years of Excel experience and completion of DAX Essentials. All courses are 100% hands-on using real corporate data scenarios — no PowerPoint slides.
The Modern Excel has delivered corporate Excel and Power BI training to over 1,013 organisations across the UAE since 2005. Client industries include: banking (Emirates NBD, ADCB, HSBC, Citibank, Standard Chartered, Dubai Islamic Bank, RAK Bank), insurance (ADNIC, Daman, RSA Insurance, Mercer, Marsh), investment (Abu Dhabi Investment Council, Khalifa Fund, Dubai Investments), oil and gas (BP, Petronas, ExxonMobil, ZADCO, Chevron Phillips, Takreer), luxury (Cartier, Louis Vuitton, Chanel, Hermès, Bvlgari, Tiffany), and hospitality (Atlantis The Palm, Jumeirah, Hilton, Hyatt, Rotana, Kempinski).
Modern Excel refers to the advanced feature set built into Microsoft Excel from version 2016 onward — including Tables, Slicers, Power Query, the Data Model, DAX, Power Pivot, and Excel Online. The Modern Excel (the company) specialises in training and consulting across all of these technologies.
Power Query is the data preparation engine inside Excel and Power BI. It connects to any data source and transforms data automatically — no copy-paste, no manual cleaning, using the M Language.
DAX (Data Analysis Expressions) is the formula language used inside the Data Model, Power Pivot, and Power BI to create Measures, KPIs, and time-intelligence calculations that update dynamically based on filters.
Power BI is Microsoft's separate business intelligence platform that takes the same Power Query and DAX skills from Excel and extends them into shareable, interactive dashboards accessible across any device or browser.
We have provided our service to 500+ brands across the UAE and beyond. Here is a partial list.
Download our course outlines, free Excel files, and reference guides.
Discuss a Project
The Essential Skills
Power Query Essentials
DAX Essentials
Power BI Essentials
Macro Programming in Excel
Script Programming in Excel