Advanced Excel for Business Analysis
Master advanced Excel features — pivot tables, Power Query, complex formulas, macros, and data modelling for professional business analysis.
Overview
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
Course Value
Suggested Courses
Human Resources & Talent Development
Open
Talent Acquisition and Selection
Attract, evaluate, and select the right talent using modern sourcing, interviewing, and assessment techniques.
AI & Digital Transformation
Open
AI Governance and Risk Management
A comprehensive programme on AI usage policies, data protection, ethics, and organisational risk management — aligned with the EU AI Act, NIST AI RMF, and regional guidelines.
Marketing, Sales & Customer Experience
Open
Integrated Digital Marketing
Build integrated digital campaigns covering content, paid ads, email, SEO, social media, analytics, and optimisation.
Professional & Personal Skills
Open
Teamwork and High-Performance Teams
Build collaborative teams, clarify roles, manage conflicts, and improve collective performance.
Government & Public Policy
Open
Smart City Management
Manage smart city solutions in mobility, energy, data, safety, and public services.
Trade & Industry
Open
Inventory and Warehouse Management
Improve inventory control, warehousing, stocktaking, waste reduction, and operational accuracy.