Project Management Certifications
182
Quality Certifications
128
Finance and Accounting Certifications
229
HR Certifications
263
Banking, Insurance and Financial Services
156
Legal
12
Education Management Courses
12
HSE Certifications
69
Short Masters
2
AI in Administrative & Secretariat
12
Maintenance and Engineering
213
Contracts Management
186
Transportation Management and Aviation
88
Tourism Management
164
AI in Customer Service
6
Customer Service
49
Public Relations
213
Supply Chain Certifications
340
Data Management and Business Intelligence
25
Business Continuity and Crisis Management
6
Women Only Courses
AI in Strategic Planning
14
Graphics & Design Skills Courses
17
Sustainability
155
Hands-on Automation and Process Control
10
Government and Public Sector
134
Security Management
16
Engineering and Instrumentation
37
Audit and Compliance Certifications
266
Administration and Secretarial
149
Healthcare and Pharmaceutical Management
258
Financial Technology (FinTech)
4
Oil and Gas
50
Management Certifications
412
Digital Innovation and Transformation
17
Planning and Strategy Management
220
Communication and Writing Skills
29
Marketing Certifications
163
Operations Readiness and Assurance
68
Interpersonal Skills and Self Development
53
IT and Security Certifications
336
Construction Management
109
Though many professionals use Excel on a daily basis, Excel has many undiscovered functions that can increase productivity even further. In this course, we will explore one of the relatively new tools brought by Excel to help professionals in cleaning up and preparing data for further analysis and reporting: Power Query. In addition, we will cover many features of pivot tables which is the main reporting tool in Excel. We will also take a look at Power Pivots, another powerful tool in Excel which will put your pivot tables on turbo. While pivot tables have some limitations, Power Pivots can be used when you have significantly big data.
Live online course where participants will be able to interact with instructor (video and audio), view slides, collaborate with others, comment on discussions, complete assessments, activities and case studies.
By the end of the course, participants will be able to:
Accountants, senior and junior accountants, business analysts, accounting and finance professionals, business analysts, research professionals and staff from any function who need to master and upgrade their skills in Excel pivot tables, Power Query and Power Pivots and work with big data analysis.
© 2026 Arab British Fellowship Training Academy. All rights reserved.