Overview

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, 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.

Objectives

The objectives of this 2-days training program are as follows:

1. Able to Extract, Transform, Load data from external sources into working Excel file
2. Able to use Power Query application in Excel to consolidate and merge data from multiple tables
3. Able to use Power Pivot application in Excel to manage data table relationships