Leadership Development
412
Personal Effectiveness
53
Workforce Development
263
Auditing and Governance, Risk and Compliance
266
AI in Customer Service
6
Operations Readiness and Assurance
68
Hands-on Automation and Process Control
10
Data Management and Business Intelligence
25
Transportation Management and Aviation
88
Strategic Thinking
220
Healthcare and Pharmaceutical Management
258
Performance and Productivity
128
Engineering and Instrumentation
37
Tourism Management
164
Financial Technology (FinTech)
4
Short Masters
2
Health, Safety and Environment
69
Sales Leadership
163
Education Management Courses
12
Public Relations
213
Maintenance and Engineering
213
Leading Projects
182
Contracts Management
186
Service Leadership
49
Security Management
16
Influence and Communication
29
Business Continuity and Crisis Management
6
AI in Strategic Planning
14
Finance for Non-Financial Managers
229
Oil and Gas
50
Construction Management
109
Government and Public Sector
134
Procurement and Supply Chain Management
340
Graphics & Design Skills Courses
17
Banking, Insurance and Financial Services
156
Legal
12
Administration and Secretarial
149
IT Management and Cyber Security
336
Women Only Courses
Sustainability
155
Digital Innovation and Transformation
17
AI in Administrative & Secretariat
12
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.
Ready to develop your leaders?
Talk to us about our public courses, or a programme built around your team.
Leadership programmes from first-line supervisor to senior executive
Explore Subjects
Ready to develop your leaders?
Talk to us about our public courses, or a programme built around your team.
Leadership programmes from first-line supervisor to senior executive
Explore Subjects
© 2026 Leaders Training Institute. All rights reserved.