Power Query and Power Pivot (Excel 365)

Advance your skills in data preparation and analysis with our Excel course on Power Query and Power Pivot. Discover how to automate data tasks and utilise advanced data modelling tools such as Power Query, Power Pivot, and DAX. This course is perfect for professionals seeking to enhance decision-making through efficient large dataset analysis.

Effective Data Analysis using Excel

This course provides practical data analysis skills using Excel, teaching learners to utilise formulas, functions, and Power Pivot to connect to multiple data sources. Key areas covered include data
modelling and visualisation, DAX language for data summarisation, statistical techniques for dashboard creation, and data protection guidelines. Learners will also master techniques for cleaning
datasets and performing comprehensive data analysis

Level Up Your Excel Skills

Take your Excel skills to the next level with advanced techniques such as advanced functions and formulas, data validation and conditional formatting. Streamline your work and enhance your productivity with advanced formatting, charts, and tables.

UEN No.: 198802365N

Main Category
IT COURSES
Generative AI Series
SOFT SKILLS COURSES
COURSE MONTH
Certification
COURSE LEVEL
Course Duration