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
Ace it Training Logo

Microsoft Office PowerPoint

This is a comprehensive MS Powerpoint training course where you will learn to prepare a presentation by applying and adding graphical objects, diagrams, charts, multimedia and much more.

by Ace it Training
Khawarizmi Training Solutions Logo

Microsoft Office PowerPoint (2 Levels)

This course will help you understand and work with MS Powerpoint 2013 proficiently. The knowledge acquired here will empower you to create engaging and dynamic multimedia presentations.

by Khawarizmi Training Solutions
  • Price
  • Start Date
  • Duration

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