2 DAYS TRAINING
For a comprehensive quote on this course module, please don’t hesitate to contact us. We are happy to provide further details.
Introduction:
Advanced Excel skills typically involve a deep understanding and proficiency in using advanced features and functions within Microsoft Excel. This includes but is not limited to, complex formula creation, data analysis using tools like PivotTables and PivotCharts, automation through macros and
VBA (Visual Basic for Applications), extensive knowledge of data validation, advanced charting techniques, and the ability to work with large datasets efficiently.
Additionally, an advanced Excel user should be adept at utilizing features like Power Query for data import and transformation, and Power Pivot for creating data models. Overall, advanced Excel skills enable users to tackle complex data analysis, modeling, and reporting tasks with ease and efficiency.
Learning Objectives:
Introduction to Extract, Transform, Load data from external sources into working Excel file
Introduction to use Power Query application in Excel to consolidate and merge data from
multiple tables
Introduction to use Power Pivot application in Excel to manage data table relationships
Introduction to VBA macros related to actual work processes in Excel
HRDC Certificate Of Attendance:
Yes
Target Audience:
Office admin
Senior Executive
Engineers
Managers
Methodology:
Face-to-Face or Online
Hands-on exercises