Microsoft Excel Advanced Data Analysis With Using Power Query, Power Pivot and DAX
Current Status
Not Enrolled
Price
₦40,000.00
Get Started

Microsoft Excel – Advanced Data Analysis With Using Power Query, Power Pivot and DAX

Course Duration

2 Weekends
(Oct. 10, 11, 17 & 18)

Course Price

₦ 40,000.00​

Course Level

Advanced


Course Overview

This advanced Excel training focuses on three essential advanced features in Excel application Power Pivot, Power Query and Data Analysis Expressions (DAX). These are some of the advanced data analysis tools available in Excel.

In this course we will look at how to connect, transform and combine data from a wide variety of available data sources using Power Query before moving onto creating relationships between our data tables and building out a data model. We then look at performing powerful data analysis and calculations on our data model using DAX, and finally, we look at displaying our analysis using PivotTables and PivotCharts.

What You Will Learn

Course Requirements

Scroll to Top