Excel Power Features (Power Query & Power Pivot)

by GRCA Academy

This training will help you to learn about creating fast, repeatable data transformations that will improve your reporting and Excel analysis capabilities.

AED 1800

Contact the Institutes

Fill this form
GRCA Academy Logo

img Duration

2 Days

Course Details

This training will help you to learn about creating fast, repeatable data transformations that will improve your reporting and Excel analysis capabilities. 

You will be able to import Excel file(s), remove top rows, remove columns, change type, use the first row as a header, rename columns, rename query, etc. You will be able to link your data using data modeling and then using the datasets for creating reports using a power pivot.

Modules:

- Power Query

- Data Modelling

- Power Pivot & DAX

- Common DAX Functions

GRCA Academy is a leading training institute that is operating Globally with a primary focus on the MENA region. It values and assists in unlocking the true potential of career-oriented professionals to achieve their goals and meet objectives. 

In order to ensure that you are abreast with the current global changes, updates and technology, GRCA Academy offers several accredited programs. 

We have offices in:

  • UAE - Dubai / Abu Dhabi
  • USA - SFO
  • Pakistan - Lahore / Karachi
  • Kuwait - Salmiya
  • Kingdom of Saudia Arabia - Riyadh / Damman
  • Kingdom of Bahrain - Manama
  • Qatar - Doha

 

  • Business Bay Branch

    Binary Tower, Business Bay, Dubai

Check out more MS Excel courses in UAE

Knowledge Point Institute Logo

Certificate In MS Office

Master the essential tools of Microsoft Office with Knowledge Point Institute's comprehensive MS Office course. This course covers the core applications: Word, Excel, PowerPoint, and Outlook, providing you with the skills needed to excel in both academic and professional environments.

by Knowledge Point Institute
  • Price
  • Start Date
  • Duration
Focus Training and Educational Institute Logo

Ms Office

Microsoft Office is a program that includes all of the technological requirements for a corporate working environment. Each application performs a unique task and offers its users a certain service.

by Focus Training and Educational Institute
Focus Training and Educational Institute Logo

MS Excel

The centerpiece of Microsoft Office, "Excel," is a significant contribution and a spreadsheet application that was created exclusively for business use. It was created to manage data transformations such as arithmetic operations and more.

by Focus Training and Educational Institute
  • Price
  • Start Date
  • Duration
Zabeel International Institute of Management and Technology Logo

Microsoft - Office professional (Excel, Word, Powerpoint)

This is Cambridge IT Skill course. It comes with an Examination at the end to get the certificate. It covers office user level (basic) Ms Word, Excel, Powerpoint and Internet using skills.

by Zabeel International Institute of Management and Technology
  • Price
  • Start Date
  • Duration
Virginia Institute Of Finance Logo

Microsoft Word Certification

This is a hands-on training to practice and learn all the underlying features and functions offered by MS Word. By the end of this training, you will be familiarised with the core MS Word skills and working abilities. It includes creating a

by Virginia Institute Of Finance
  • Price
  • Start Date
  • Duration

© 2024 www.coursetakers.ae All Rights Reserved. Terms and Conditions of use | Privacy Policy